Hive
  1. Hive
  2. HIVE-4549

JDBC compliance change TABLE_SCHEMA to TABLE_SCHEM

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: 0.10.0
    • Fix Version/s: 0.12.0
    • Component/s: JDBC
    • Labels:
    • Environment:

      Hive 0.10

      Description

      The ResultSet returned by HiveDatabaseMetadata.getTables has the metadata columns TABLE_CAT, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, REMARKS. The second column name is not compliant with the JDBC standard (http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getSchemas()): the column name should be TABLE_SCHEM instead of TABLE_SCHEMA.

      Suggested fix in Hive (org.apache.hive.service.cli.operation.GetTablesOperation.java) change from

      private static final TableSchema RESULT_SET_SCHEMA = new TableSchema()
      .addStringColumn("TABLE_CAT", "Catalog name. NULL if not applicable.")
      .addStringColumn("TABLE_SCHEMA", "Schema name.")
      .addStringColumn("TABLE_NAME", "Table name.")
      .addStringColumn("TABLE_TYPE", "The table type, e.g. \"TABLE\", \"VIEW\", etc.")
      .addStringColumn("REMARKS", "Comments about the table.");

      to

      private static final TableSchema RESULT_SET_SCHEMA = new TableSchema()
      .addStringColumn("TABLE_CAT", "Catalog name. NULL if not applicable.")
      .addStringColumn("TABLE_SCHEM", "Schema name.")
      .addStringColumn("TABLE_NAME", "Table name.")
      .addStringColumn("TABLE_TYPE", "The table type, e.g. \"TABLE\", \"VIEW\", etc.")
      .addStringColumn("REMARKS", "Comments about the table.");

      1. HIVE-4549-1.patch
        3 kB
        Prasad Mujumdar

        Activity

        Johndee Burks created issue -
        Johndee Burks made changes -
        Field Original Value New Value
        Summary JDBC compliance change JDBC compliance change TABLE_SCHEMA to TABLE_SCHEM
        Prasad Mujumdar made changes -
        Assignee Prasad Mujumdar [ prasadm ]
        Prasad Mujumdar made changes -
        Attachment HIVE-4549-1.patch [ 12586649 ]
        Prasad Mujumdar made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Fix Version/s 0.12.0 [ 12324312 ]
        Navis made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Ashutosh Chauhan made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Prasad Mujumdar
            Reporter:
            Johndee Burks
          • Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development