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;

Reply via email to