hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Buntu Dev <>
Subject Error creating a partitioned view
Date Thu, 12 Mar 2015 22:29:26 GMT
I got a 'log' table which is currently partitioned by year, month and day.
I'm looking to create a partitioned view on top of 'log' table but running
into this error:


hive> CREATE VIEW log_view PARTITIONED ON (pagename,year,month,day) AS
SELECT pagename year,month,day,uid,properties FROM log;

FAILED: SemanticException [Error 10093]: Rightmost columns in view output
do not match PARTITIONED ON clause


How do I go about creating this view?


View raw message