phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <>
Subject [jira] [Resolved] (PHOENIX-2498) Secondary index table is not updated in bulk load
Date Sat, 23 Jan 2016 20:07:39 GMT


James Taylor resolved PHOENIX-2498.
    Resolution: Duplicate

Duplicate of PHOENIX-2521

> Secondary index table is not updated in bulk load
> -------------------------------------------------
>                 Key: PHOENIX-2498
>                 URL:
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.5.2
>         Environment: CentOs
>            Reporter: Afshin Moazami
>              Labels: bulkloader, secondary_index
> 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 
> {code} -table mySchema.myTable {code}
> data will load only to the myTable, not myIndex.
> But, both will be loaded if I use:
> {code} -schema mySchema -table myTable {code}
> 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
> {code:xml} select /*+ INDEX(mySchema.myTable myIndex) */* from myTable where myColumn
 = 'myValue'; {code}
> 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) 

This message was sent by Atlassian JIRA

View raw message