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