[ https://issues.apache.org/jira/browse/HIVE-3236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15570672#comment-15570672 ]
Roger Shi commented on HIVE-3236: --------------------------------- Any update on this JIRA? > allow column names to be prefixed by table alias in select all queries > ---------------------------------------------------------------------- > > Key: HIVE-3236 > URL: https://issues.apache.org/jira/browse/HIVE-3236 > Project: Hive > Issue Type: Improvement > Components: Query Processor > Affects Versions: 0.9.1, 0.10.0 > Reporter: Keegan Mosley > Priority: Minor > Attachments: HIVE-3236.1.patch.txt > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)