Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-576 complete jdbc driver
  3. HIVE-559

Support JDBC ResultSetMetadata

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 0.5.0
    • 0.8.0
    • JDBC
    • None

    Description

      Support ResultSetMetadata for JDBC ResultSets. The getColumn* methods would be particularly useful I'd expect:
      http://java.sun.com/javase/6/docs/api/java/sql/ResultSetMetaData.html

      The challenge as I see it though, is that the JDBC client only has access to the raw query string and the result data when running in standalone mode. Therefore, it will need to get the column metadata one of two way:

      1. By parsing the query to determine the tables/columns involved and then making a request to the metastore to get the metadata for the columns. This certainly feels like duplicate work, since the query of course gets properly parsed on the server.

      2. By returning the column metadata from the server. My thrift knowledge is limited, but I suspect adding this to the response would present other challenges.

      Any thoughts or suggestions? Option #1 feels clunkier, yet safer.

      Attachments

        Issue Links

          Activity

            People

              prasadm Prasad Suresh Mujumdar
              billgraham William W. Graham Jr
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: