apache - 创建分区 View 时 Hive 出错

Question

我有一个“日志”表，该表当前按年、月和日进行分区。我想在“日志”表的顶部创建一个分区 View ，但遇到了这个错误:

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

创建分区 View 的正确方法是什么？

Answer 1

试试这个..

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

原因是分区列必须位于 select 语句查询的最后。