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 ..)
... View more
