Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
Kudu_Impala
-
None
-
Cloudera
Description
Getting error below while creating table in IMPALA_KUDU
Your query has the following error(s):
ImpalaRuntimeException: Error creating Kudu table CAUSED BY: IllegalArgumentException: Got out-of-order primary key column: Column name: countrytag, type: string
Creation command:
CREATE TABLE kudu_period
DISTRIBUTE BY HASH(countrytag, clienttag, categorytag) INTO 16 BUCKETS,
HASH(periodtag) INTO 4 buckets
TBLPROPERTIES (
'storage_handler' = 'com.cloudera.kudu.hive.KuduStorageHandler',
'kudu.table_name' = 'kudu_period',
'kudu.num_tablet_replicas' = '3',
'kudu.master_addresses' = 'dayrhegapd022.enterprisenet.org',
'kudu.key_columns' = 'countrytag, clienttag, categorytag, periodtag'
)
AS SELECT * FROM retail_intel_viz_rnd2.period;