Support Questions
Find answers, ask questions, and share your expertise

Does bulk csv data loading support local index creation?

Solved Go to solution

Does bulk csv data loading support local index creation?

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

Accepted Solutions

Re: Does bulk csv data loading support local index creation?

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

Re: Does bulk csv data loading support local index creation?

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