You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Buntu Dev <bu...@gmail.com> on 2015/03/12 23:29:26 UTC

Error creating a partitioned view

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?


Thanks!