hadoop - Hive 中的范围分区

Question

Hive 是否支持范围分区？

我的意思是 hive 是否支持如下内容:

insert overwrite table table2 PARTITION (employeeId BETWEEN 2001 and 3000) 
select employeeName FROM emp10 where employeeId BETWEEN 2001 and 3000;

其中 table2 和 emp10 有两列:

员工姓名&员工编号

当我运行上面的查询时，我遇到了一个错误:

FAILED: ParseException line 1:56 mismatched input 'BETWEEN' expecting ) near 'employeeId' in destination specification

Answer 1

不可能。这是来自 Hive documentation 的引述:

A table can have one or more partition columns and a separate data directory is created for each distinct value combination in the partition columns