Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12218

Unable to create a like table for an hbase backed table

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.1
    • Fix Version/s: 1.3.0, 2.0.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      For an HBase backed table:

      CREATE TABLE hbasetbl (key string, state string, country string, country_id int)
      STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
      WITH SERDEPROPERTIES (
      "hbase.columns.mapping" = "info:state,info:country,info:country_id"
      );
      

      Create its like table using query such as
      create table hbasetbl_like like hbasetbl;

      It fails with error:
      FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: must specify an InputFormat class

        Attachments

        1. HIVE-12218-branch-1.patch
          9 kB
          Chaoyu Tang
        2. HIVE-12218.patch
          9 kB
          Chaoyu Tang

          Activity

            People

            • Assignee:
              ctang Chaoyu Tang
              Reporter:
              ctang Chaoyu Tang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: