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!
