You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "suraj misra (JIRA)" <ji...@apache.org> on 2015/02/09 09:01:34 UTC
[jira] [Updated] (PHOENIX-1647) Fully qualified tablename query
support in Phoenix
[ https://issues.apache.org/jira/browse/PHOENIX-1647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
suraj misra updated PHOENIX-1647:
---------------------------------
Description:
I am able to execute queries having fully qualified names in table names. For example:
UPSERT INTO TEST.CUSTOMERS_TEST VALUES(102,'hbase2',20,'del')
But when I look at the phoenix driver implementation, I can see that implementation for DatabaseMetaData .supportsSchemasInDataManipulation method always return false.
As per JDBC documentation, this method retrieves whether a schema name can be used in a data manipulation statement.But as you can see in above example, I can execute DML statements with schema names as well along with other statements.
Could someone please let me know if there is any specific reason to keep it as false.
was:
I am able to execute queries having fully qualified names in table names. For example:
UPSERT INTO TEST.CUSTOMERS_TEST VALUES(102,'hbase2',20,'del')
But when I look at the phoenix driver implementation, I can see that implementation for DatabaseMetaData .supportsSchemasInDataManipulation method always return false.
As per JDBC documentation, this method retrieves whether a schema name can be used in a data manipulation statement.But as you can see in above example, I can execute DML statements with schema names as well along with other statements.
> Fully qualified tablename query support in Phoenix
> --------------------------------------------------
>
> Key: PHOENIX-1647
> URL: https://issues.apache.org/jira/browse/PHOENIX-1647
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.1.1
> Environment: Phoenix driver 4.1.1
> HBase 98.9
> Hadoop 2
> Reporter: suraj misra
>
> I am able to execute queries having fully qualified names in table names. For example:
> UPSERT INTO TEST.CUSTOMERS_TEST VALUES(102,'hbase2',20,'del')
> But when I look at the phoenix driver implementation, I can see that implementation for DatabaseMetaData .supportsSchemasInDataManipulation method always return false.
> As per JDBC documentation, this method retrieves whether a schema name can be used in a data manipulation statement.But as you can see in above example, I can execute DML statements with schema names as well along with other statements.
> Could someone please let me know if there is any specific reason to keep it as false.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)