Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive creating empty part files when insert query has group by

Highlighted

Hive creating empty part files when insert query has group by

New Contributor

I have a complex hive table and I am selecting few columns with query which also has group by on 8 columns. When I use this select query to insert into another hive table it created over 200 empty part files.

I am using below properties to reduce it but no help so far

set hive.merge.mapfiles=true;

set hive.merge.mapredfiles=true;

set mapred.reduce.tasks=1;