Re: How to setup Hive JDBC client to connect remote Hiveserver

2016-04-04 Thread Mich Talebzadeh
This telnet does not specify the port that Hiveserver2 is running on (default 1) Mine is running on 10010 *telnet 50.140.197.217 10010*Trying 50.140.197.217... Connected to rhes564 (50.140.197.217). Escape character is '^]'. Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/

Re: How to setup Hive JDBC client to connect remote Hiveserver

2016-04-03 Thread Daniel Haviv
You can see which pid is listening on port 1 by running "netstat -pan | grep 1" The logs are usually under /var/log/hive or under a log dir inside Hive's dir Thank you. Daniel > On 4 Apr 2016, at 08:11, brajmohan saxena wrote: > > My Hiveserver2 is up and running. > But I think its no

Re: How to setup Hive JDBC client to connect remote Hiveserver

2016-04-03 Thread brajmohan saxena
My Hiveserver2 is up and running. But I think its not able to listening at port 1. What should i do now ? Also I am using apache-hive-1.2.1-bin copied in my home directory and running the Hiveserver2 from bin. But I do not find any hive.log file anywhere, Could you please suggest me the exact

Re: How to setup Hive JDBC client to connect remote Hiveserver

2016-04-03 Thread Daniel Haviv
It seems your hive server is not up (or not listening on port 1). hiveserver's logs might shed some light (usually at /var/log/hive) Thank you. Daniel > On 4 Apr 2016, at 07:00, brajmohan saxena wrote: > > Hi Shumin, > > I did telnet > > braj-laptop:bin brajmohan$ telnet 192.168.1.103 >

Re: How to setup Hive JDBC client to connect remote Hiveserver

2016-04-03 Thread brajmohan saxena
Hi Shumin, I did telnet braj-laptop:bin brajmohan$ telnet 192.168.1.103 Trying 192.168.1.103... telnet: connect to address 192.168.1.103: Connection refused telnet: Unable to connect to remote host Thanks Braj On Mon, Apr 4, 2016 at 8:41 AM, Shumin Guo wrote: > Can you telnet to that port

Re: How to setup Hive JDBC client to connect remote Hiveserver

2016-04-03 Thread Shumin Guo
Can you telnet to that port? $ telnet 192.168.1.103 1 On Sun, Apr 3, 2016 at 9:43 PM, brajmohan saxena wrote: > Hi, > > Could you please tell me how to connect a simple JDBC program to remote > Hiveserver2 with default Derby database. > > I have Hiveserver2 running on remote machine and i a