hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bill Graham (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-559) Support JDBC ResultSetMetata
Date Fri, 12 Jun 2009 18:26:07 GMT
Support JDBC ResultSetMetata
----------------------------

                 Key: HIVE-559
                 URL: https://issues.apache.org/jira/browse/HIVE-559
             Project: Hadoop Hive
          Issue Type: New Feature
          Components: Clients
            Reporter: Bill Graham


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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message