Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

input_format_null_as_default can work also for nested types inside Tuple/Array/Map #51100

Closed
Avogar opened this issue Jun 16, 2023 · 0 comments · Fixed by #54351
Closed

input_format_null_as_default can work also for nested types inside Tuple/Array/Map #51100

Avogar opened this issue Jun 16, 2023 · 0 comments · Fixed by #54351
Assignees
Labels

Comments

@Avogar
Copy link
Member

Avogar commented Jun 16, 2023

This can work:

avogar-dev :) select * from format('TSV', 'a Array(UInt64)', $$[\N, \N]$$)

Received exception from server (version 23.6.1):
Code: 130. DB::Exception: Received from localhost:9000. DB::ParsingException. DB::ParsingException: Cannot read array from text, expected comma or end of array, found '\': Could not print diagnostic info because two last rows aren't in buffer (rare case)
: While executing ParallelParsingBlockInputFormat: (at row 1)
. (CANNOT_READ_ARRAY_FROM_TEXT)

It's already done in JSON formats:

avogar-dev :) select * from format('JSONEachRow', 'a Array(UInt64)', '{"a" : [null, null]}')

SELECT *
FROM format('JSONEachRow', 'a Array(UInt64)', '{"a" : [null, null]}')

Query id: 3aff1137-f376-47b9-b1a0-ee7a285a5fd5

┌─a─────┐
│ [0,0] │
└───────┘
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant