Find Port Number and Domain Name to connect to Hive Table

Posted by user1419563 on Stack Overflow See other posts from Stack Overflow or by user1419563
Published on 2012-07-02T01:05:28Z Indexed on 2012/07/02 3:16 UTC
Read the original article Hit count: 337

Filed under:

I am new to Hive, MapReduce and Hadoop. 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-

I was trying to connect to Hive Tables using Squirrel SQL Client, so in that my Connection URL is- jdbc:hive:// So whenever I try to connect with these attributes, I always get Hive: Could not establish connection to Connection timed out: connect.

It might be possible I am using wrong port number or domain name here. Is there any way from the command prompt I can find out these two things, like what Domain Name and Port Number(where Hive server is running) should I use to connect to Hive table from Squirrel SQL Client.

As I know host and port are determined by where the hive server is running

© Stack Overflow or respective owner

Related posts about bash

Related posts about unix