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-
ares-ingest.vip.host.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-
I was trying to connect to
Hive Tables using
Squirrel SQL Client, so in that my Connection URL is-
jdbc:hive://ares-ingest.vip.host.com:10000/default. So whenever I try to connect with these attributes, I always get
Hive: Could not establish connection to ares-ingest.vip.host.com:10000/default: java.net.ConnectException: 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