SQL Impala 从视图创建分区表

Question

我有兴趣将视图转换为表，但我希望将表分区为一个变量： 我的查询是：

CREATE TABLE table_test AS ( 选择 * FROM view_test

我想让表按变量“时间段”分区。

先感谢您。

Answer 1

你可以像这样直接这样做

CREATE TABLE table_test
PARTITIONED BY (time_period)
as 
SELECT col1,col2,
time_period -- Pls make sure this partition column as the last column in SELECT.
FROM  schema.view_test;