蜂巢--在“排序”附近创建缺少的EOF表

Question

当我试图执行下面的查询(CREATE)时，出现了这个错误。有什么建议吗？

错误：

[sshexec] 2022-08-22 11:48:36: >> Query in errore:  
  [sshexec]  CREATE EXTERNAL TABLE OVCDX
  [sshexec]  (
  [sshexec]      `AAA...
  [sshexec] 2022-08-22 11:48:36:  Errore nel parsare la query:line 26:0 missing EOF at 'SORT' near ')'

查询：

CREATE EXTERNAL TABLE OVCDX
(
    `AAA`       STRING          COMMENT '<KEY>|XA',
    `BBB`       STRING          COMMENT '<KEY>|XB',
    `CCC`       STRING          COMMENT '<KEY>|XC',
    `DDD`       STRING          COMMENT '<KEY>|XD',
    `EEE`       STRING          COMMENT '<KEY>|XE',
    `FFF`       BIGINT          COMMENT 'XF'
)
PARTITIONED BY (
    `GGG`       STRING       COMMENT '<KEY>|XG',
    `HHH`       STRING       COMMENT '<KEY>|XH',
    `III`       STRING       COMMENT '<KEY>|XI',
    `JJJ`       STRING       COMMENT '<KEY>|XJ',
    `KKK`       STRING       COMMENT '<KEY>|XK',
    `LLL`       STRING       COMMENT '<KEY>|XL'
)
SORT BY (
    `AAA`,
    `BBB`,
    `CCC`,
    `DDD`,
    `EEE`                       
)
COMMENT 'X_ABCDE'
STORED AS PARQUET;

特克斯卢卡

Answer 1

您确定在CREATE语句中使用了正确的语法吗？根据wiki，SORT BY必须与CLUSTERED BY一起使用，以防它出现在CREATE TABLE语句中：

蜂巢Wiki

CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name    -- (Note: TEMPORARY available in Hive 0.14.0 and later)
  [(col_name data_type [column_constraint_specification] [COMMENT col_comment], ... [constraint_specification])]
  [COMMENT table_comment]
  [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
  [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS]
  [SKEWED BY (col_name, col_name, ...)                  -- (Note: Available in Hive 0.10.0 and later)]
     ON ((col_value, col_value, ...), (col_value, col_value, ...), ...)
     [STORED AS DIRECTORIES]