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] Updated: (HIVE-679) Integrate JDBC driver with SQuirrelSQL for querying
Date Thu, 23 Jul 2009 19:55:15 GMT

     [ https://issues.apache.org/jira/browse/HIVE-679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Bill Graham updated HIVE-679:

    Attachment: HIVE-679.1.patch

Adding HIVE-679.1.patch. To test, apply the patch and install/run SQuirrelSQL (I've tested
with MacOSx v.3.0.2):

1. Download and install SQuirrelSQL from http://www.squirrelsql.org/#installation

2. Start SQuirrelSQL and add the Hive driver
  a. Select Drivers --> New Driver 
  b. Name the driver
  c. From the 'Extra Class Path' tab add HIVE_HOME/lib/*.jar, and HADOOP_HOME/hadoop-*-core.jar
  d. Enter Class Name: org.apache.hadoop.hive.jdbc.HiveDriver

3. Create a new connection a the Hive server
  a. Select Aliases --> New Alias
  b. Name the connection, select the Hive driver and enter your Hive server URL
  c. Test the connection

4. From the Aliases tab on the left, connect to the Hive alias.

You should now be able to do basic querying (i.e. show tables, describe table, select, create,
drop, etc).

> 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
>         Attachments: HIVE-679.1.patch
> 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.

View raw message