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

Table name while selecting index state is case sensitive

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 4.13.0, 4.14.2
    • Fix Version/s: 4.15.1, 5.1.1, 4.16.1
    • Component/s: None
    • Labels:
      None

      Description

      Initially, the following query is executed:

       

      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;
      

       

      Then,

      org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter

      is run.

      After that, The following queries then lead to a different output:

      SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE TABLE_NAME='us_population_gv_gi_1';

      Output:

      +--------------+
      | INDEX_STATE |
      +--------------+
      +--------------+
      No rows selected (0.076 seconds)

      and

      SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE TABLE_NAME='US_POPULATION_GV_GI_1';

      Output:

      +--------------+
      | INDEX_STATE |
      +--------------+
      | b |
      | |
      | |
      | |
      | |
      +--------------+
      5 rows selected (0.063 seconds)

      Only the case in which the table is mentioned in different in the above queries.

      Need an appropriate resolution for this.

        Attachments

          Activity

            People

            • Assignee:
              swaroopa Swaroopa Kadam
              Reporter:
              ashuparekh Ashutosh Parekh
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: