hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raghotham Murthy (JIRA)" <>
Subject [jira] Commented: (HIVE-48) Support JDBC connections for interoperability between Hive and RDBMS
Date Mon, 05 Jan 2009 18:55:44 GMT


Raghotham Murthy commented on HIVE-48:

> 1. What is the motivation for change?

The reason was that there is currently no way to retrieve the result table name in the server.
Also, the driver is always returning the result of queries, so, 'result' seems to be a reasonable
name for the table. Ideally, we should have a function which converts a schema DDL to a Schema
object and we should be able to query the schema object. Right now we just pass the schema
string as is to the DynamicSerDe.

> 2. In what are execString and fileName variables used for?

Right now JdbcSessionState is a dummy class. Its not being used for anything. The plan is
to use it later on. I just copied over the class from Cli. I can make it an empty class. 

> 3. Shouldn't be doing something?

The plan was to stage the JDBC implementation. There are a bunch of auto-generated classes
which will be used later on.

> 4. In the getDouble function is missing TODO comment? Same is
true for getFloat and getInt.

The TODO comment is inside the function body. Isnt that enough?

> 5. For the non implemented functions should we throw a non implemented run time exception
instead of just returning 0. 

return 0 was auto-generated. I'll change them to throw SQLException instead.

> Support JDBC connections for interoperability between Hive and RDBMS
> --------------------------------------------------------------------
>                 Key: HIVE-48
>                 URL:
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Clients
>            Reporter: YoungWoo Kim
>            Assignee: Michi Mutsuzaki
>            Priority: Minor
>         Attachments: hadoop-4101.1.patch, hadoop-4101.2.patch, hadoop-4101.3.patch, hadoop-4101.4.patch,
hive-48.5.patch, hive-48.6.patch
> In many DW and BI systems, the data are stored in RDBMS for now such as oracle, mysql,
postgresql ... for reporting, charting and etc.
> It would be useful to be able to import data from RDBMS and export data to RDBMS using
JDBC connections.
> If Hive support JDBC connections, It wll be much easier to use 3rd party DW/BI tools.

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

View raw message