Pulkit Bhardwaj created PHOENIX-4725:
----------------------------------------
Summary: Hint part in a query does not take into account the
"schema" which is passed in the JDBC connection string
Key: PHOENIX-4725
URL: https://issues.apache.org/jira/browse/PHOENIX-4725
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.7.0
Reporter: Pulkit Bhardwaj
If I connect to hbase via phoenix using a jdbc connection and specify the
schema name in the connection, I would be able to do use the table names
without having to specify the schema name in the query
e.g
{code:java}
SELECT * from SCHEMA_NAME.TABLE_NAME{code}
can we written as
{code:java}
SELECT * from TABLE_NAME{code}
but
let's say I want to pass a hint to use a particular index on the table
{code:java}
SELECT /*+ INDEX(SCHEMA_NAME.TABLE_NAME IDX_TABLE) */ * from TABLE_NAME{code}
the above works, but if I remove the SCHEMA_NAME from inside the hint part, the
query would not reconise the index
in other words, the below would not work
{code:java}
SELECT /*+ INDEX(TABLE_NAME IDX_TABLE) */ * from TABLE_NAME{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
