There is a partitioned(batch_date is partition) hive table(Table 1) with 3 columns and 1 partition
I'm trying to execute INSERT INTO TABLE PARTITION(batch_date='2018-02-22') select column 1, column 2, column 3 from Table 1 where column 1 = "ABC";
It returns zero records and in hdfs it is creating 3 empty files.
Can you please suggest me a solution on how to prevent these small files getting created in hdfs??
Note: Before running the INSERT statements I have set the below hive properties.