Specifying which columns in the target table to insert into (emp in your
case) is not supported in 0.14. You have to insert into all the columns
in the table and they have to match the order of items in the select or
values clause.
This will be supported in 1.2.
Alan.
Srinivas Thunga <mailto:[email protected]>
February 26, 2015 at 4:34
Hi,
I am using Hive 0.14
Can any one help me on to execute the below type query
insert into table emp (eid,ename) select * from dept where emp.id
<http://emp.id> = dept.id <http://dept.id>
/Thanks & Regards,/
/
/
/Srinivas T/
