findepi commented on issue #13822: URL: https://github.com/apache/datafusion/issues/13822#issuecomment-2550662936
Ordinary (single level) schema name can contain a dot. > I've also considered concatenating the middle namspaces with `.` and not changing DataFusion, but that would require doing `SELECT * FROM one."two.three.four".five` which is also not an ideal UX. IIUC, from internal API perspective this is exactly what's going to happen. I'm not sure about dev-ex consequences of doing so though. Would every catalog be responsible for identifier re-parsing (a task solved by SQL parser today)? I understand all you want is for SQL parser/analyzer to desugar `one.two.three.four.five` into one."two.three.four".five` so that query author doesn't need to do anything. > There is a function in DataFusion [idents_to_table_reference](https://github.com/apache/datafusion/blob/main/datafusion/sql/src/planner.rs#L668) that is responsible for transforming the Vec<Ident> into a TableReference. the dotted syntax is not only for resolving table names, it's also used for column resolution: ```sql SELECT unqualified_column, one.two.three.four.five.qualified_column, one.two.three.four.five.another_column.a.nested.field FROM one.two.three.four.five ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
