Phoenix has a neat extension to SQL for declaring dynamic columns as part of a query. This is for columns that are present in the schema-less table but we didn’t declare them when we issued the CREATE TABLE statement.
http://phoenix.apache.org/dynamic_columns.html James Taylor is proposing adding it to Calcite’s SQL: https://issues.apache.org/jira/browse/CALCITE-493 Drill developers, Would this be a useful syntax extension for Drill? I think it has some advantages over Drill's implicit, type-less columns. Julian
