You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "second88 (JIRA)" <ji...@apache.org> on 2017/10/04 07:15:00 UTC
[jira] [Created] (DRILL-5837) Methods of DatabaseMetaData with
names start with supportsCatalogs in JDBC API should return false
second88 created DRILL-5837:
-------------------------------
Summary: Methods of DatabaseMetaData with names start with supportsCatalogs in JDBC API should return false
Key: DRILL-5837
URL: https://issues.apache.org/jira/browse/DRILL-5837
Project: Apache Drill
Issue Type: Bug
Components: Client - JDBC
Affects Versions: 1.10.0
Reporter: second88
Priority: Minor
The following 5 methods of java.sqlDatabaseMetaData in JDBC API should return false but they currently return true for Drill JDBC connection:
supportsCatalogsInDataManipulation()
supportsCatalogsInProcedureCalls()
supportsCatalogsInTableDefinitions()
supportsCatalogsInIndexDefinitions()
supportsCatalogsInPrivilegeDefinitions()
As far as I know, the synthetic catalog "DRILL" cannot be used in the creation of table, view and function in Drill.
For example, the following statement is incorrect:
{code:sql}
CREATE TABLE DRILL.df.tmp.`name_key` (N_NAME, N_NATIONKEY) AS SELECT N_NATIONKEY, N_NAME FROM dfs.`/Users/drilluser/apache-drill-1.0/sample-data/nation.parquet`
{code}
For consistency, all 5 methods should return false though only supportsCatalogsInProcedureCalls() and supportsCatalogsInTableDefinitions() are currently meaningful to Drill.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)