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

selecting Hive on Hbase table may cause FileNotFoundException

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.0
    • Fix Version/s: 2.2.0
    • Component/s: Physical Optimizer
    • Labels:
      None
    • Target Version/s:

      Description

      1. create a Hbase table hbase_table
      2. create a external Hive table test_table mapping to the hbase table

      example:

      create 'hbase_t' ,

      {NAME=>'cf',COMPRESSION=>'snappy'}

      ,

      {NUMREGIONS=>15,SPLITALGO=>'HexStringSplit'}

      create external table hbase_t_hive(key1 string,cf_train string,cf_flight string,cf_wbsw string,cf_wbxw string,cf_bgrz string,cf_bgtf string)
      stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
      with serdeproperties("hbase.columns.mapping"=":key,cf:train,cf:flight,cf:wbsw,cf:wbxw,cf:bgrz,cf:bgtf") tblproperties("hbase.table.name"="hbase_t");

      create table test3 as select * from hbase_t_hive where 1=2;

      ====

      if hive.optimize.null.scan=true, it will return an FileNotFoundException

        Attachments

        1. HIVE-14411.1.patch
          0.9 kB
          Niklaus Xiao

          Activity

            People

            • Assignee:
              niklaus.xiao Niklaus Xiao
              Reporter:
              LueChen Rudd Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: