I am trying to join two wide tables and save the result to a new table. They happen to be CSV on disk... Now because the tables are very wide I don't really want to manually create all the columns myself - but never fear - they are just the union of the old columns. So I expect to be able to do a Create Table As Select command like this CREATE TABLE new_table AS select * from source but it is more like this CREATE TABLE combined_table AS SELECT * FROM `default.left_table` A1, `default.right_table` B1 where A1.the_key = B1.the_key or CREATE TABLE combined_table AS SELECT * FROM (SELECT * `default.left_table` A1, `default.right_table` B1 where A1.the_key = B1.the_key); Neither work for me. Is this supposed to work in Hive? If I am saving the results of my query to a new table do I always have to know the columns in that result set and create the table with those columns first? (I am using HDP 2.4.2, so a fairly recent Hive) Thanks ... View more