[PHOENIX-2498] Secondary index table is not updated in bulk load

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 4.5.2
• Labels: bulkloader secondary_index

Environment

CentOs

• Assignee: Unassigned
• Reporter: Afshin Moazami
• Created: 08/Dec/15 19:29
• Updated: 23/Jan/16 20:07
• Resolved: 23/Jan/16 20:07

Description

When using Phoenix map reduce bulk loader to load data from a csv file to a table (myTable) with a secondary index (myIndex) in schema (mySchema), if I use

 -table mySchema.myTable 

data will load only to the myTable, not myIndex.

But, both will be loaded if I use:

 -schema mySchema -table myTable 

I am not sure if it is a bug or feature, but it is not documented anywhere (or at lease I couldn't find it)

As a result of the first usage (where index is not loaded), we can have weird scenarios like

 select /*+ INDEX(mySchema.myTable myIndex) */* from myTable where myColumn  = 'myValue'; 

and it returns a row that myColumn is not equal to myValue, because where clause is validated against the index and the data will be returned from the main table ( I guess)