We are going to create a new table with Apache Hive from a previous one, populate it and then perform a UNION ALL of both tables. Below is the script that will create the new table.
-- Below script creates a new table USE testdb; -- show current tables SHOW tables; -- describe mytable2, table we will use to create mytable4 DESCRIBE mytable2; -- create new table copying format from mytable2 CREATE TABLE mytable4 LIKE mytable2 ; SHOW tables; -- describe newly created table DESCRIBE mytable4; -- select content from newly created table SELECT * FROM mytable4;
We proceed executing via hive in a linux shell.
hive -f create-new-table.hql Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties OK Time taken: 0.898 seconds OK mytable mytable2 newtable3 Time taken: 0.206 seconds, Fetched: 3 row(s) OK id int lname string fname string Time taken: 0.263 seconds, Fetched: 3 row(s) OK Time taken: 0.272 seconds OK mytable mytable2 mytable4 newtable3 Time taken: 0.043 seconds, Fetched: 4 row(s) OK id int lname string fname string Time taken: 0.166 seconds, Fetched: 3 row(s) OK Time taken: 0.666 seconds