Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3842

Error while creating table in IMPALA_KUDU

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Kudu_Impala
    • None
    • Backend
    • 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;

      Attachments

        Activity

          People

            Unassigned Unassigned
            ravikcse08 Ravi sharma
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: