Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

unable to bulk insert timestamp values into hive table

 
2 REPLIES 2

@Aditya Sirna

Can you please suggest in this regard. Thanks.

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.