Home Forums Hive / HCatalog copy data into hive table

This topic contains 1 reply, has 2 voices, and was last updated by  Yi Zhang 10 months ago.

  • Creator
    Topic
  • #42415

    We have two clusters and i want to copy data from hbase(source) to hive external table(on target cluster). what is preferrable approach for this. Do i need to take care of partitions and buckets of target cluster manually.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #42741

    Yi Zhang
    Moderator

    Hi Satish,

    Currently HBase is not aware of partitions and buckets of hive tables. You can try select from hbase table into hive table with hive’s hbasestoragehandler, but it may not scale.

    https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration

    Alternatively, export data from hbase and register the data into hive.

    Thanks,
    Yi

    Collapse
Viewing 1 replies (of 1 total)