Skip to main content
Question

Move data to vertica from HBase

  • January 30, 2024
  • 1 reply
  • 2 views

prad33p2301
Forum|alt.badge.img+1

What is the recommended way of moving data from an HBase db which has >1Billion records into vertica

1 reply

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • January 30, 2024

The simplest solution is probably to export to partitioned Parquet files on shared storage and copy into Vertica from there. If you can connect to HBase using a client driver, you could also use a parallel ETL tool like odb, or write a Spark job, etc.