Support Questions

Find answers, ask questions, and share your expertise

Does bulk csv data loading support local index creation?

avatar
Expert Contributor

The local index is created in existing table is +millions of records. Does bulk csv data loading support local index creation?

and does asynchronous index population support local index creation?

or

Is there any way to create local index manually rather than automatic as when we are doing bulk upload into an existing table, automatic local index becomes inconsistent. We are only using hbase bulk upload to upload data into hbase at the moment.

1 ACCEPTED SOLUTION

avatar
Master Mentor

@Cassandra Spencer

from this doc, looks like answer is yes. https://phoenix.apache.org/bulk_dataload.html

The current MR-based bulk loader will run one MR job to load your data table and one MR per index table to populate your indexes. Use the -it option to only load one of your index tables.

View solution in original post

1 REPLY 1

avatar
Master Mentor

@Cassandra Spencer

from this doc, looks like answer is yes. https://phoenix.apache.org/bulk_dataload.html

The current MR-based bulk loader will run one MR job to load your data table and one MR per index table to populate your indexes. Use the -it option to only load one of your index tables.