Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

​​How I can connect an external hive table to an internal Hive table?

​​How I can connect an external hive table to an internal Hive table?

New Contributor

I use an external Hive table in order to connect to HBase, and then I copy the data to an internal table for other usage. but I need that any update on the HBase table appears on the internal Hive table, is there any solution to connect two tables On Hive(external and internal)

1 REPLY 1
Highlighted

Re: ​​How I can connect an external hive table to an internal Hive table?

I dont think there is a single command to keep data in both Hive over Hbase external table and Hive internal table. What is the volume of your data you want to play with. Below JRuby program can help you to schedule data and bring into hive internal table once Hbase over Hive is populated successfully...

https://community.hortonworks.com/articles/43971/jruby-code-to-purgequeryfilter-data-on-hbase-over-2...

Don't have an account?
Coming from Hortonworks? Activate your account here