Home Forums Hive / HCatalog Hive+HBase table creation freezing and failing

This topic contains 1 reply, has 2 voices, and was last updated by  Nick Dimiduk 10 months, 1 week ago.

  • Creator
    Topic
  • #43737

    Thomas Vial
    Member

    Hi!
    We are trying to create HBase-backed tables in Hive. We are using HDP 2 with HBase 0.95.2.2.0.5.0-67 and Hive 0.11.0.2.0.5.0-67 or 0.12.0.2.0.6.0-76 (neither will do).

    Table creation is failing, and we are wondering why. The classpath appears to be correctly set, so does the connection to zookeper, after setting HADOOP_CLASSPATH, hbase.zookeeper.quorum and hbase.master.

    When we issue the CREATE TABLE statement, HIve client freezes for a minute or so then fails with “java.io.IOException: Failed to find location, tableName=hbase:meta, …” on the client. Apparently, it’s happening when Hive is reading table metadata from HBase.

    Any idea what might be causing that?

    Thanks!

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #43745

    Nick Dimiduk
    Participant

    Hi Thomas,

    Can you try including the hbase config directory in your hive classpath? I usually specify:

    $ export HADOOP_CLASSPATH=/etc/hbase/conf:/usr/lib/hbase/hbase-security.jar:…
    $ hive …

    Also note that there is a known bug in the combination of HBase + Hive we shipped in HDP-2.0; you won’t be able to load data into HBase from Hive. See HIVE-5515. I believe we’ll be shipping that patch with the next patch release. In the mean time, things should work for you on a HDP-1.3 release (HBase 0.94 + Hive 0.11).

    Cheers,
    Nick

    Collapse
Viewing 1 replies (of 1 total)