Hi We've done a recent upgrade from Hive 1.1.0-cdh5.16.2 to Hive 3.1.3 and have noticed the difference in behaviour when no rows have been returned and file generation. On the older version (Hive 1.1.0-cdh5.16.2) it use to create empty part files (000000_0) whereas since the upgrade this isn't the case. The command to run this is beeline and the sql statement starts like: Insert overwrite directory 'some/path' ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' I cannot find any definitive documentation to saw this behaviour does not exist in later versions like Hive 3.1.3 Thanks ... View more