Uploaded image for project: 'CDH (READ-ONLY)'
  1. CDH (READ-ONLY)
  2. DISTRO-604

CREATE INDEX fails with qualified table name

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: CDH 5.0.1
    • Fix Version/s: None
    • Component/s: Hive
    • Labels:

      Description

      Hive doesn't consistently handle db qualified names across all HiveQL statements. While some HiveQL statements such as SELECT support DB qualified names, other such as CREATE INDEX doesn't.

      Steps to reproduce the issue:

      create database ck_dev_d_1

      create table ck_dev_d_1.src_customer (
      col1 string,
      sales_pers_id bigint
      )

      CREATE INDEX IX_0src_customer
      ON TABLE ck_dev_d_1.src_customer
      ( sales_pers_id )
      AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler'

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mkempanna Mala Chikka Kempanna
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: