hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mahender Sarangam <>
Subject Re: Zero Bytes Files importance
Date Thu, 29 Dec 2016 18:43:11 GMT
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 <<>>


On 12/27/2016 12:36 PM, Mahender Sarangam wrote:


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.



View raw message