Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to create partitioned view

avatar
Expert Contributor

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

~~

 

Whats the right way to create a partitioned views? I'm using Hive 0.13 in CDH 5.3.2.

 

Thanks!

3 REPLIES 3

avatar
Contributor
It seems you missed a "," between pagename and year after SELECT.

avatar
Expert Contributor

Sorry, was a copy/paste error. I did have a comma between pagename and year but got the error I pasted.

 

Thanks!

avatar
New Contributor

@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.