Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2498

Secondary index table is not updated in bulk load

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 4.5.2
    • Fix Version/s: None
    • Component/s: None
    • Environment:

      CentOs

      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)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              moazami.afshin@gmail.com Afshin Moazami
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: