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
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