CREATE TABLE temp.test_partitioning_4 (
PARTITIONED BY (
stored as parquet
INSERT INTO TABLE temp.test_partitioning_4 PARTITION (day)
select day, count as num from
hss.session where year=2016 and month=4
group by day
new directory ".hive-staging_hive_2016-12-19_15-55-11_298_3412488541559534475-4" created on HDFS. It's big issue, because I insert every day and bunch of empty dirs on HDFS is very bad for HDFS.