[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viraj Jasani updated PHOENIX-5400: -- Fix Version/s: (was: 4.17.0) (was: 5.2.0) (was: 4.16.2) > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0, 4.14.2 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-5400: --- Fix Version/s: (was: 5.1.2) > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0, 4.14.2 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > Fix For: 4.17.0, 5.2.0, 4.16.2 > > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viraj Jasani updated PHOENIX-5400: -- Fix Version/s: (was: 4.16.1) 4.16.2 5.1.2 5.2.0 > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0, 4.14.2 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > Fix For: 4.17.0, 5.2.0, 5.1.2, 4.16.2 > > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xinyi Yan updated PHOENIX-5400: --- Fix Version/s: (was: 4.15.1) > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0, 4.14.2 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > Fix For: 5.1.1, 4.16.1, 4.17.0 > > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xinyi Yan updated PHOENIX-5400: --- Fix Version/s: 4.17.0 > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0, 4.14.2 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > Fix For: 4.15.1, 5.1.1, 4.16.1, 4.17.0 > > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xinyi Yan updated PHOENIX-5400: --- Fix Version/s: 4.16.1 > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0, 4.14.2 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > Fix For: 4.15.1, 5.1.1, 4.16.1 > > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lars Hofhansl updated PHOENIX-5400: --- Fix Version/s: (was: 5.1.0) (was: 4.15.0) 5.1.1 4.15.1 > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0, 4.14.2 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > Fix For: 4.15.1, 5.1.1 > > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-5400: Affects Version/s: 4.14.2 > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0, 4.14.2 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > Fix For: 4.15.0, 5.1.0 > > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian JIRA (v7.6.14#76016)
[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive
[ https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swaroopa Kadam updated PHOENIX-5400: Fix Version/s: 5.1.0 4.15.0 > Table name while selecting index state is case sensitive > > > Key: PHOENIX-5400 > URL: https://issues.apache.org/jira/browse/PHOENIX-5400 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.13.0 >Reporter: Ashutosh Parekh >Assignee: Swaroopa Kadam >Priority: Minor > Fix For: 4.15.0, 5.1.0 > > > Initially, the following query is executed: > > {code:java} > CREATE TABLE IF NOT EXISTS us_population ( > state CHAR(2) NOT NULL, > city VARCHAR NOT NULL, > population BIGINT, > CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0; > UPSERT INTO us_population VALUES('NY','New York',8143197); > UPSERT INTO us_population VALUES('CA','Los Angeles',3844829); > UPSERT INTO us_population VALUES('IL','Chicago',2842518); > UPSERT INTO us_population VALUES('TX','Houston',2016582); > UPSERT INTO us_population VALUES('PA','Philadelphia',1463281); > UPSERT INTO us_population VALUES('AZ','Phoenix',1461575); > UPSERT INTO us_population VALUES('TX','San Antonio',1256509); > UPSERT INTO us_population VALUES('CA','San Diego',1255540); > UPSERT INTO us_population VALUES('TX','Dallas',1213825); > UPSERT INTO us_population VALUES('CA','San Jose',912332); > CREATE VIEW us_population_global_view (name VARCHAR, > age BIGINT) AS > SELECT * FROM us_population > WHERE state = 'CA'; > CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include > (city) async; > {code} > > Then, > {code:java} > org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code} > is run. > After that, The following queries then lead to a different output: > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='us_population_gv_gi_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > +--+ > No rows selected (0.076 seconds){code} > and > {code:java} > SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE > TABLE_NAME='US_POPULATION_GV_GI_1';{code} > Output: > {code:java} > +--+ > | INDEX_STATE | > +--+ > | b | > | | > | | > | | > | | > +--+ > 5 rows selected (0.063 seconds){code} > Only the case in which the table is mentioned in different in the above > queries. > Need an appropriate resolution for this. -- This message was sent by Atlassian JIRA (v7.6.14#76016)