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

Bill Graham commented on HIVE-679:
----------------------------------

SQuirrelSQL allows a connection to be established without support for 
DatabaseMetaData, which is being handled separately as part of HIVE-576. That 
allows work on this issue to occur in parallel, ignoring the DatabaseMetaData 
support in SQuirrelSQL.

I've got this working in my dev env with unit tests and will submit a patch 
soon. Below is the scope of what I've had to implement:

HiveStatement
- getWarnings(), clearWarnings()
- close(), isClosed()
- execute(), getResultSet()
- getUpdateCount()
- setMaxRows()

HiveConnection
- getWarnings(), clearWarnings()
- close(), isClosed()

HiveDatabaseMetaData
- getDatabaseProductName() : Hive, getDatabaseProductVersion() : 0
- getProcedures() : null
- supportsCatalogsInTableDefinitions() : false
- supportsSchemasInTableDefinitions() : false
- supportsMultipleResultSets() : false
- supportsStoredProcedures() : false

HiveDriver
- getPropertyInfo : returns HOST, PORT, DBNAME properties

HiveResultSet
- getWarnings(), clearWarnings()
- wasNull()
- initializing column names and types
- support for maxRows
- Constructor throws SQLException instead of calling System.exit(1) on error

HiveResultSetMetaData
- getColumnType(int column)
- getColumnTypeName(int column)
- getColumnDisplaySize(int column)
- isAutoIncrement(int column) : false
- isCurrency(int column) : false
- isNullable(int column) : false
- getPrecision(int column) : 0 or -1 for DOUBLE ??? What should double 
precision be?
- getScale(int column) : 0 or -1 for DOUBLE ??? What should double scope be?

> Integrate JDBC driver with SQuirrelSQL for querying
> ---------------------------------------------------
>
>                 Key: HIVE-679
>                 URL: https://issues.apache.org/jira/browse/HIVE-679
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Clients
>            Reporter: Bill Graham
>            Assignee: Bill Graham
>
> Implement the JDBC methods required to support querying and other basic 
> commands using the SQuirrelSQL tool. 

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

Reply via email to