You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Shubham (JIRA)" <ji...@apache.org> on 2018/05/10 21:03:00 UTC
[jira] [Commented] (PHOENIX-4725) Hint part in a query does not
take into account the "schema" which is passed in the JDBC connection
string
[ https://issues.apache.org/jira/browse/PHOENIX-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16471106#comment-16471106 ]
Shubham commented on PHOENIX-4725:
----------------------------------
I would like to work on this jira, [~ankit@apache.org] can you please assign this to me?
> 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
> Priority: Major
>
> 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)