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
data will load only to the myTable, not myIndex.
But, both will be loaded if I use:
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
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)