[ 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)