Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of prasadm@cloudera.com
 designates 209.85.220.176 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAH0jRU9Zaz0phA0_9Nm+rA-hug8d+D8d+WGy_AW9M30ho98V_g@mail.gmail.com>
References: 
 <CAH0jRU9Zaz0phA0_9Nm+rA-hug8d+D8d+WGy_AW9M30ho98V_g@mail.gmail.com>
Date: Sun, 1 Jul 2012 22:51:54 -0700
Message-ID: 
 <CAC-RAHM8mwDDWHF9Znt_Qm2pLETd4UV0NB82GGLv3RPaG6ZBQw@mail.gmail.com>
Subject: Re: Connect Squirrel SQL Client to access Hive tables
From: Prasad Mujumdar <prasadm@cloudera.com>
To: dev@hive.apache.org
Content-Type: multipart/alternative; boundary=f46d043c7d0622ba4d04c3d26572

--f46d043c7d0622ba4d04c3d26572
Content-Type: text/plain; charset=ISO-8859-1

   Check HIVE-3100 which is to include SQLLine as command line tool for
Hive.

thanks
Prasad

On Sun, Jul 1, 2012 at 11:58 AM, Raihan Jamal <jamalraihan@gmail.com> wrote:

> I am new to Hive, MapReduce and Hadoop, so I am newbie in this.
> I am using Putty to connect to hive table and access records in the tables.
> So what I did is- I opened Putty and in the host name I typed- `
> ares-ingest.vip.name.com` and then I click `Open`. And then I entered my
> username and password and then few commands to get to Hive sql. Below is
> the list what I did
>
>     $ bash
>     bash-3.00$ hive
>     Hive history
> file=/tmp/rjamal/hive_job_log_rjamal_201207010451_1212680168.txt
>     hive> set mapred.job.queue.name=hdmi-technology;
>     hive> select * from table LIMIT 1;
>
> So my question is-
>
> **Is there any other way I can do the same thing in any Sql client like Sql
> Developer or Squirel SQL Client instead of doing it from the command
> prompt. And if it is there then what is the step by step process to do this
> considering my example as I am logging to `ares-ingest.vip.name.com` from
> Putty .**
>
> And same thing if I need to do through JDBC Program in my windows machine
> then how I can do it. Means with the use of JDBC Program, how I can access
> Hive tables and get the result back. As I know how I can do this with the
> oracle tables. But the only confusion I have is, as I am using this
> hostname `ares-ingest.vip.name.com` to log into Putty. I am hoping the
> question is clear. Any suggestion will be appreciated.
>
> **In short my question is- Can I do the same thing in any SQLClient instead
> of logging from the Putty?**
>
>
> -Raihan Jamal
>

--f46d043c7d0622ba4d04c3d26572--