Hi Sranislavs, It is simple Insert statement with Select statements which are union together like below
Insert into TargetTable Select C1,C2 from Table1 Union All Select C1,C2 from Table2 3 reducers are been created so 3 folders are created. For any insert operation, there will be one Zero bytes file. I would like to know importance of this Zero bytes file. On 12/28/2016 11:35 AM, Staņislavs Rogozins wrote: What are the actual queries used to create the table and insert data? Are you enforcing bucketing or partitioning? On Wed, Dec 28, 2016 at 1:22 PM, Mahender Sarangam <[email protected]<mailto:[email protected]>> wrote: ping. On 12/27/2016 12:36 PM, Mahender Sarangam wrote: Hi When we dump or have hive query to insert data into another hive table. There will be Folder which contains actual data and apart from that we see another 0 Byte File present at same level. I would like to understand importance of Zero byte files. What happens if we delete this file. Please find below screen shot like 1,2,3 with Zero bytes files. [cid:[email protected]] /Mahender
