Hey guys,
we've reviewed the docs but still not sure why query 1 works fine and query
2 errors out with a syntax error. The only difference is that I have Hash
partition first and then a Range.
ERROR: AnalysisException: Syntax error in line 13:
),
^
Encountered: COMMA
Expected: AS, CACHED, COMMENT, LOCATION, ROW, SORT, STORED, TBLPROPERTIES,
UNCACHED, WITH
CAUSED BY: Exception: Syntax error
*Query 1:*
CREATE TABLE test2
(
source_system_id BIGINT,
id1 BIGINT,
id2 BIGINT,
name STRING,
PRIMARY KEY (source_system_id,id1,id2)
)
PARTITION BY
RANGE(source_system_id) (
PARTITION VALUE = 10000000,
PARTITION VALUE = 20000000,
PARTITION VALUE = 30000000
),
HASH(id1,id2) PARTITIONS 10
STORED AS KUDU;
*Query 2:*
CREATE TABLE test2
(
source_system_id BIGINT,
id1 BIGINT,
id2 BIGINT,
name STRING,
PRIMARY KEY (source_system_id,id1,id2)
)
PARTITION BY
RANGE(source_system_id) (
PARTITION VALUE = 10000000,
PARTITION VALUE = 20000000,
PARTITION VALUE = 30000000
),
HASH(id1,id2) PARTITIONS 10
STORED AS KUDU;