Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5837

Methods of DatabaseMetaData with names start with supportsCatalogs in JDBC API should return false

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.10.0
    • None
    • Client - JDBC, Metadata
    • None
    • OS: Windows 7 32-bit
      Reporting tools: Crystal Reports 2008, Crystal Reports 2016

    Description

      The following 5 methods of java.sql.DatabaseMetaData 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:

      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`
      

      For consistency, all 5 methods should return false though only supportsCatalogsInProcedureCalls() and supportsCatalogsInTableDefinitions() are currently meaningful to Drill.

      Crystal Reports 2008 & 2016 currently do not work with Drill in report creation wizard (no schemata nor views are shown for report creation) due to the incorrect return values of at least the following methods of DatabaseMetaData:
      supportsCatalogsInDataManipulation()
      supportsCatalogsInProcedureCalls()
      supportsCatalogsInTableDefinitions()

      Attachments

        Activity

          People

            Unassigned Unassigned
            second88 second88
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: