Luís Bianchin
Reputation: 2486
How to load data into Phoenix from Hive?
Hive has a HBase integration. Given that, would it be possible to insert into a Phoenix table from hive? (as a bulk load/insert overwrite) What about compound primary keys? Can we generate them in Hive?
Upvotes: 0
Views: 2541
Answers (1)
Anil Gupta
Reputation: 1126
No, unfortunately Hive HBase integration does not enable loading data into Phoenix table. Also, (as per my experience) support for composite rowkeys for HBase integration is not comprehensive. For example: Hive cannot support a composite keys containing Integer,String, BigDecimal.
You can either use Phoenix-mr integration or Phoenix-Pig integration. Phoenix also has a csv bulk loader.
Upvotes: 1
Related Questions
- phoenix and hive ETL on Hbase
- How to extract apache phoenix table/view data to a file
- Loading data into Hive Table from HDFS in Cloudera VM
- How to query data inserted from HBase using Phoenix
- Loading data in Hive table with Hadoop
- How to import data from a hbase table to hive table?
- Connect to Test Hbase table via Phoenix
- Hadoop with phoenix: how to write the phoenix table object to hdfs filesystem
- How to insert csv file into HBase database with help of Phoenix command line tools?
- How to Load Data into Hive from HDFS