Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

unable to bulk insert timestamp values into hive table

unable to bulk insert timestamp values into hive table

New Contributor
 
2 REPLIES 2
Highlighted

Re: unable to bulk insert timestamp values into hive table

New Contributor

@Aditya Sirna

Can you please suggest in this regard. Thanks.

Re: unable to bulk insert timestamp values into hive table

Hi @Gayathri Devi

If you want to insert multiple rows in one statement then syntax which you have used wont work. You may need to write one insert statement for one record. Orelse you can have all the records in a Textfile and create an external table over it. Use the external table to insert into 'tryins' table.

insert into tryins select * from external_table

Hope it helps!!

Don't have an account?
Coming from Hortonworks? Activate your account here