hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bennie Schut (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1126) Missing some Jdbc functionality like getTables getColumns and HiveResultSet.get* methods based on column name.
Date Fri, 16 Jul 2010 09:17:57 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12889089#action_12889089
] 

Bennie Schut commented on HIVE-1126:
------------------------------------

Hi Carl,

Thanks for the fast response. The jdbc driver has a concept of "catalog" and "schema" (this
is jdbc terminology). You could for instance describe a table like this:
Catalog.Schema.TableName
But then it seems oracle implements the "getCatalogs" which allows you to do:
Catalog.TableName
Mysql supports the "getSchemas" which allows you to do this:
Schema.TableName

Now on mysql what they call a database = jdbc schema
On oracle what they call a schema = jdbc catalog

It seems nobody supports both and it seems to matter little which of the two you pick because
the end result seems to allow you to do exactly the same thing.
I have a personal preference in implementing getSchemas but if anyone can think of a reason
to do it differently I would love to know.

To me it seems like : schemas == databases == catalogs == namespaces

Thanks,
Bennie.

> Missing some Jdbc functionality like getTables getColumns and HiveResultSet.get* methods
based on column name.
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-1126
>                 URL: https://issues.apache.org/jira/browse/HIVE-1126
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.6.0
>            Reporter: Bennie Schut
>            Assignee: Bennie Schut
>            Priority: Minor
>         Attachments: HIVE-1126-1.patch, HIVE-1126.patch, HIVE-1126_patch(0.5.0_source).patch
>
>
> I've been using the hive jdbc driver more and more and was missing some functionality
which I added
> HiveDatabaseMetaData.getTables
> Using "show tables" to get the info from hive.
> HiveDatabaseMetaData.getColumns
> Using "describe tablename" to get the columns.
> This makes using something like SQuirreL a lot nicer since you have the list of tables
and just click on the content tab to see what's in the table.
> I also implemented
> HiveResultSet.getObject(String columnName) so you call most get* methods based on the
column name.

-- 
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