Skip to content

datatypes in file structure can't have commas (like Decimal) #6217

@filimonov

Description

@filimonov
SELECT *
FROM file('a', 'CSV', 'a Decimal(10,1)')

Received exception from server (version 19.11.2):
Code: 49. DB::Exception: Received from localhost:9000. DB::Exception: Odd number of elements in section structure: must be a list of name type pairs. 

0 rows in set. Elapsed: 0.062 sec. 

Workaround & proper behaviour

SELECT *
FROM file('a', 'CSV', 'a Decimal64(1)')

Received exception from server (version 19.11.2):
Code: 107. DB::Exception: Received from localhost:9000. DB::Exception: File /var/lib/clickhouse/user_files/a is not exist. 

0 rows in set. Elapsed: 0.069 sec. 

Metadata

Metadata

Assignees

Labels

bugConfirmed user-visible misbehaviour in official releaseunfinished code

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions