hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raihan Jamal <>
Subject Connect Squirrel SQL Client to access Hive tables
Date Sun, 01 Jul 2012 19:03:33 GMT
> 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- `
>` 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;
>     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 `` 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 `` 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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message