You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Raihan Jamal <ja...@gmail.com> on 2012/07/01 20:58:14 UTC
Connect Squirrel SQL Client to access Hive tables
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
Connect Squirrel SQL Client to access Hive tables
Posted by Raihan Jamal <ja...@gmail.com>.
>
> 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
>
Connect Squirrel SQL Client to access Hive tables
Posted by Raihan Jamal <ja...@gmail.com>.
>
> 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
>
Re: Connect Squirrel SQL Client to access Hive tables
Posted by Raihan Jamal <ja...@gmail.com>.
You mean by the use of HIVE-3100 I can connect to Hive using some web
interface vid jdbc? Can you provide me links or tutorials where I can
achieve this?
*Raihan Jamal*
On Sun, Jul 1, 2012 at 10:51 PM, Prasad Mujumdar <pr...@cloudera.com>wrote:
> 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 <ja...@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
> >
>
Re: Connect Squirrel SQL Client to access Hive tables
Posted by Prasad Mujumdar <pr...@cloudera.com>.
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 <ja...@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
>