List the structure of the file() function for various formats

[danthegoodman1]

The docs do not indicate what the column from each format when using https://clickhouse.com/docs/en/sql-reference/table-functions/file

For example using 'LineAsString' returns the line column. Nowhere (that I could reasonably find) is this documented.

The shortcut was to make a crap tiny file and print out the select so I could see what the columns are.

I am also not sure there is a function to read the columns returned by a subquery so that I could use a query to inspect it like:

select columns(select * from file('...', 'LineAsString'))

[danthegoodman1]

Ok so they are not listed in https://clickhouse.com/docs/en/interfaces/formats#lineasstring

but listed in https://clickhouse.com/docs/en/interfaces/schema-inference#line-as-string

Would assume some inter-linking

[gingerwizard]

I think we can link from https://clickhouse.com/docs/en/interfaces/formats to https://clickhouse.com/docs/en/interfaces/schema-inference where appropriate with the comment

"For how this format behaves with schema inference see here)"

I'm not sure we can cleanly link in the other direction @danthegoodman1 hopefully this is sufficient and would have helped in your case.

[danthegoodman1]

Yeah please link that schema-inference one!