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

hive connect to hbase cause select results error

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.12.0
    • Fix Version/s: None
    • Component/s: HBase Handler
    • Labels:
      None
    • Environment:

      Hadoop 1.0.4, HBase 0.94.6.1, Hive 0.12.0

      Description

      CREATE EXTERNAL TABLE hb_test(key string, `_plat` int, `_uid` int)STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,d:_plat#b,d:_uid#b")TBLPROPERTIES("hbase.table.name" = "test");
      insert overwrite local directory '/data/mf/app/data/check' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' select key, `_plat`, `_uid` from hb_test where key>'00604' and key<'00605';

      after finish the query, under fold /data/mf/app/data/check output eight files. and each file has the same duplicate data

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhengzhuangjie zhengzhuangjie
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: