Hello, In hive we got a need that we need to create a new table like the old table with an extra column at run time. This must be done in a single query. No second query with alter table statement.
Query like: Create table new_table like old_table , new_column datatype; Please help me out, searched in many forums but not found the solution. Please inform me if any other information is needed. Thanks & Regards Venkatesh