[jira] [Created] (PHOENIX-3523) Secondary index on case sensitive table breaks all queries

["Karthick Duraisamy Soundararaj (JIRA)" <ji...@apache.org>]

Karthick Duraisamy Soundararaj created PHOENIX-3523:
-------------------------------------------------------

             Summary: Secondary index on case sensitive table breaks all queries
                 Key: PHOENIX-3523
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3523
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.8.1
            Reporter: Karthick Duraisamy Soundararaj


Phoenix creates the HBase table for case sensitive Phoenix table under "default" namespace rather than creating it under the namespace that the table belongs to. Please see the following for illustration of the problem.

{panel:title=Map an existing table on HBase to Phoenix}
On HBase, I have "m3:merchants". It is mapped to "m3.merchants" on phoenix. As you can see below, I can query the table just fine.
{code}
0: jdbc:phoenix:dev.snc1> drop index "merchant_feature_country_idx" on "m3.merchants";
No rows affected (4.006 seconds)
0: jdbc:phoenix:dev.snc1> select "primary", "merchant.name", "merchant.feature_country" from "m3.merchants" limit 1;
+---------------------------------------+-------------------+---------------------------+
|                primary                |   merchant.name   | merchant.feature_country  |
+---------------------------------------+-------------------+---------------------------+
| 00001860-00259060b612  | XXXXX                 | US                        |
+---------------------------------------+-------------------+---------------------------+
{code}
{panel}





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)