[HIVE-3236] allow column names to be prefixed by table alias in select all queries

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.9.1, 0.10.0
• Component/s: Query Processor
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Keegan Mosley
• Created: 06/Jul/12 01:00
• Updated: 02/Jul/20 00:31

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.

Issue Links

• links to: GitHub Pull Request #5