Fwd: Hive Insert and Select only specific columns ( not all columns ) - Partitioned table

2019-05-29 Thread Raviprasad T
Is it possible to Insert only specific columns in Hive ( Partitioned tables ) ? For Non partitioned tables, it is working as below. insert into emp (empno,sal) select empno,sal from emp_hist.; --- This is working ( emp_hist table is having empno,ename,sal,job_desc columns, I am able to

RE: Delete all databases in hive

2019-05-29 Thread Jon Morisi
Dump a list of databases to a file, write a bash script to iterate through and execute drop database with cascade commands? Something like: hive --outputformat=dsv --showHeader=false -e "drop database $LINE with cascade;" done < "$FILE" From: Terry Sent: Sunday, May 26, 2019 2:14 AM To: user@h