Details
-
Improvement
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
0.9.1, 0.10.0
-
None
Description
When using "CREATE TABLE x AS SELECT ..." where the select joins tables with hundreds of columns it is not a simple task to resolve duplicate column name exceptions (particularly with self-joins). The user must either manually specify aliases for all duplicate columns (potentially hundreds) or write a script to generate the data set in a separate select query, then create the table and load the data in.
There should be some conf flag that would allow queries like
"create table joined as select one.*, two.* from mytable one join mytable two on (one.duplicate_field = two.duplicate_field1);"
to create a table with columns one_duplicate_field and two_duplicate_field.
Attachments
Attachments
Issue Links
- links to