Skip to content

CLI cannot create external tables with format options  #10737

@jonahgao

Description

@jonahgao

Describe the bug

It raised an error for such a case:

Invalid or Unsupported Configuration: Specify a format for TableOptions

To Reproduce

DataFusion CLI v38.0.0

> CREATE EXTERNAL TABLE aggregate_test_100 (
  c1  VARCHAR NOT NULL,
  c2  TINYINT NOT NULL,
  c3  SMALLINT NOT NULL,
  c4  SMALLINT,
  c5  INT,
  c6  BIGINT NOT NULL,
  c7  SMALLINT NOT NULL,
  c8  INT NOT NULL,
  c9  BIGINT UNSIGNED NOT NULL,
  c10 VARCHAR NOT NULL,
  c11 FLOAT NOT NULL,
  c12 DOUBLE NOT NULL,
  c13 VARCHAR NOT NULL
)
STORED AS csv
LOCATION '../testing/data/csv/aggregate_test_100.csv'
OPTIONS('format.has_header' 'true');

Invalid or Unsupported Configuration: Specify a format for TableOptions

Expected behavior

No response

Additional context

No response

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions