0

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?

Luís Bianchin
  • 2,327
  • 1
  • 28
  • 36

1 Answers1

1

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.

Anil Gupta
  • 1,116
  • 2
  • 8
  • 13