[ https://issues.apache.org/jira/browse/PHOENIX-6854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kadir Ozdemir updated PHOENIX-6854: ----------------------------------- Summary: Salted global indexes do not work for queries with uncovered columns (was: Salted global indexes does not work for queries with uncovered columns) > Salted global indexes do not work for queries with uncovered columns > -------------------------------------------------------------------- > > Key: PHOENIX-6854 > URL: https://issues.apache.org/jira/browse/PHOENIX-6854 > Project: Phoenix > Issue Type: Bug > Reporter: Kadir Ozdemir > Priority: Major > Fix For: 5.2.0, 5.1.3 > > > With an index hint, global indexes can be used for queries with uncovered > columns. However, when the data table is salted, Phoenix does not project the > columns correctly for for queries with uncovered columns, and thus the result > set returns wrong columns. For example, the following select statement > returns 'b' instead of 'bcde'. > create table T1 (id varchar not null primary key, val1 varchar, val2 varchar, > val3 varchar) SALT_BUCKETS=4; > upsert into T1 values ('b', 'bc', 'bcd', 'bcde'); > CREATE INDEX I1 on T1 (val1) include (val2); > SELECT /*+ INDEX(T1 I1)*/ val3 from T1 WHERE val1 = 'bc'; -- This message was sent by Atlassian Jira (v8.20.10#820010)