HBase via Hive External table

to create new topics or reply. | New User Registration


This topic contains 1 reply, has 2 voices, and was last updated by  abdelrahman 1 year, 7 months ago.

  • Creator
  • #45296


    I have HDP2 , I created a Hbase table

    create ‘hivehbase’,’cf1′

    Now when I tried to create an external Hive table and map to it ,I am getting the below error

    CREATE EXTERNAL TABLE hivehbase(key int, name string)
    STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’
    WITH SERDEPROPERTIES (“hbase.columns.mapping” = “:key,cf:name”)
    TBLPROPERTIES(“hbase.table.name” = “hivehbase”)

    ERROR exec.DDLTask: java.lang.NoClassDefFoundError: org/apache/hadoop/hbase/HBaseConfiguration
    at org.apache.hadoop.hive.hbase.HBaseStorageHandler.setConf(HBaseStorageHandler.java:249)
    at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
    at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
    at org.apache.hadoop.hive.ql.metadata.HiveUtils.getStorageHandler(HiveUtils.java:290)
    at org.apache.hadoop.hive.ql.metadata.Table.getStorageHandler(Table.java:285)

    If any class paths needs to be added I need more info as to what class path and where it needs to be added.
    Please advice.

Viewing 1 replies (of 1 total)

You must be to reply to this topic. | Create Account

Viewing 1 replies (of 1 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.