title: Find Port Number and Domain Name to connect to Hive Table
body: <p>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- <code>vip.host.com</code> and then I click <code>Open</code>. And then I entered my username and password and then few commands to get to Hive sql. Below is the list what I did</p>
  
  <pre><code>$ bash
  bash-3.00$ hive
  Hive history file=/tmp/unl/hive_job_log_unl_201207010451_1212680168.txt
  hive&gt; set mapred.job.queue.name=mdhi-technology;
  hive&gt; select * from table LIMIT 1;
  </code></pre>
  
  <p>So my question is-</p>
  
  <p>I was trying to connect to <code>Hive Tables</code> using <code>Squirrel SQL Client</code>, so in that my Connection URL is- <code>jdbc:hive://vip.host.com:10000/default</code>. So whenever I try to connect with these attributes, I always get <code>Hive: Could not establish connection to vip.host.com:10000/default: java.net.ConnectException: Connection timed out: connect</code>.</p>
  
  <p>It might be possible I am using <code>wrong port number or domain name here</code>. 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.</p>
  
  <p><strong>As I know host and port are determined by where the hive server is running</strong></p>