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.

Hive not generating unique file names when using insert into select

Hive not generating unique file names when using insert into select

New Contributor

I've an external table (tbl_external) pointing to s3 location I am trying to insert data into external table using another table (tbl_test) which is not an external table insert into tbl_external select * from tbl_test; But hive is always generating a file with same file name (000000_0) when i run the above insert statement, due to this the file is getting overwritten and the s3 location will always have single file instead of multiple files when i run the insert statements multiple times How to make hive generate different file names for ex : (000000_0_copy_1, 000000_0_copy_2 etc ..)

1 REPLY 1

Re: Hive not generating unique file names when using insert into select

Cloudera Employee

This may be related to HIVE-15199. Please check the Apache Jira https://issues.apache.org/jira/browse/HIVE-15199

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