@buntu   Try this: hive> CREATE VIEW log_view PARTITIONED ON (pagename,year,month,day) AS SELECTuid,properties,pagename year,month,day FROM log;    Reason: The column names used in the partition must be available at the end of view creation in the same order as mentioned in as partitions. ... View more