[jira] [Updated] (DRILL-5837) Methods of DatabaseMetaData with names start with supportsCatalogs in JDBC API should return false

["second88 (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

second88 updated DRILL-5837:
----------------------------
    Component/s: Metadata

> 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, Metadata
>    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)