Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Connect Squirrel SQL Client to access Hive tables


Copy link to this message
-
Re: Connect Squirrel SQL Client to access Hive tables
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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>
> 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
> >
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB