hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <agir...@ncsu.edu>
Subject Re: Unable to connect Hive using JDBC program
Date Wed, 21 May 2014 23:44:57 GMT
Could you try the following sequence of commands:

*$ sudo lsof -i :<port>*   (Try for 9083, 10000 and other previous ports
you may have attempted to use)

If there already exists a process, it would be listed. You could then kill
the same and then attempt to restart metastore followed by hiveserver as
shown below:

*$ hive --service metastore &*

*$ hive --service hiveserver & *


-Abhishek


On Wed, May 21, 2014 at 4:15 PM, Mohammad Tariq <dontariq@gmail.com> wrote:

> Could you please show me your code?
>
> *Warm regards,*
> *Mohammad Tariq*
> *cloudfront.blogspot.com <http://cloudfront.blogspot.com>*
>
>
> On Wed, May 21, 2014 at 11:44 PM, Sanjeevv Sriram <sanj2eevv@gmail.com>wrote:
>
>>
>>
>> When I try to start hive server with out any port, I am getting below
>> exception
>>
>> [cloudera@localhost lib]$ hive --service hiveserver
>> Starting Hive Thrift Server
>> 14/05/21 21:20:26 INFO Configuration.deprecation:
>> mapred.input.dir.recursive is deprecated. Instead, use
>> mapreduce.input.fileinputformat.input.dir.recursive
>> 14/05/21 21:20:26 INFO Configuration.deprecation: mapred.max.split.size
>> is deprecated. Instead, use mapreduce.input.fileinputformat.split.maxsize
>> 14/05/21 21:20:26 INFO Configuration.deprecation: mapred.min.split.size
>> is deprecated. Instead, use mapreduce.input.fileinputformat.split.minsize
>> 14/05/21 21:20:26 INFO Configuration.deprecation:
>> mapred.min.split.size.per.rack is deprecated. Instead, use
>> mapreduce.input.fileinputformat.split.minsize.per.rack
>> 14/05/21 21:20:26 INFO Configuration.deprecation:
>> mapred.min.split.size.per.node is deprecated. Instead, use
>> mapreduce.input.fileinputformat.split.minsize.per.node
>> 14/05/21 21:20:26 INFO Configuration.deprecation: mapred.reduce.tasks is
>> deprecated. Instead, use mapreduce.job.reduces
>> 14/05/21 21:20:26 INFO Configuration.deprecation:
>> mapred.reduce.tasks.speculative.execution is deprecated. Instead, use
>> mapreduce.reduce.speculative
>> 14/05/21 21:20:26 WARN conf.HiveConf: DEPRECATED: Configuration property
>> hive.metastore.local no longer has any effect. Make sure to provide a valid
>> value for hive.metastore.uris if you are connecting to a remote metastore.
>> org.apache.thrift.transport.TTransportException: Could not create
>> ServerSocket on address 0.0.0.0/0.0.0.0:10000.
>>     at
>> org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:93)
>>     at
>> org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:75)
>>     at
>> org.apache.hadoop.hive.metastore.TServerSocketKeepAlive.<init>(TServerSocketKeepAlive.java:34)
>>     at org.apache.hadoop.hive.service.HiveServer.main(HiveServer.java:674)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>     at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>     at java.lang.reflect.Method.invoke(Method.java:606)
>>     at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
>>
>> I am attaching hive-site.xml.
>>
>> I am using CDH 5 verson.
>>
>> Thanks,
>> Sanjeevv
>>
>>
>> On Wed, May 21, 2014 at 7:40 AM, harish tangella <
>> harish.tangella@gmail.com> wrote:
>>
>>> Hi,
>>>
>>>   Close the hive terminal and start the new without giving port number
>>> the command is
>>>
>>> hive --service hiveserver don't give any port number hope it will works
>>>
>>> On Mon, May 19, 2014 at 11:27 PM, Sanjeevv Sriram <sanj2eevv@gmail.com>wrote:
>>>
>>>> I tried with different ports... still I am getting the same issue
>>>>
>>>>
>>>> On Mon, May 19, 2014 at 8:02 AM, harish tangella <
>>>> harish.tangella@gmail.com> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>>
>>>>> Start Hive server on a different port number,and try to connect using
>>>>> JDBC connection
>>>>>
>>>>>  On Mon, May 19, 2014 at 11:06 AM, Shengjun Xin <sxin@gopivotal.com>wrote:
>>>>>
>>>>>>  Can you use command line to connect hive?
>>>>>>
>>>>>>
>>>>>> On Mon, May 19, 2014 at 4:59 AM, Sanjeevv Sriram <sanj2eevv@gmail.com
>>>>>> > wrote:
>>>>>>
>>>>>>>   Hi,
>>>>>>>
>>>>>>> Please help me I am unable to connect Hive using JDBC program.
>>>>>>>
>>>>>>> I am getting below exception:
>>>>>>>
>>>>>>> Exception in thread "main" java.sql.SQLException:
>>>>>>> org.apache.thrift.transport.TTransportException: java.net.SocketException:
>>>>>>> Connection reset
>>>>>>>     at
>>>>>>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:196)
>>>>>>>     at
>>>>>>> org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:132)
>>>>>>>     at
>>>>>>> org.apache.hadoop.hive.jdbc.HiveConnection.configureConnection(HiveConnection.java:132)
>>>>>>>     at
>>>>>>> org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:122)
>>>>>>>     at
>>>>>>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:106)
>>>>>>>     at java.sql.DriverManager.getConnection(DriverManager.java:571)
>>>>>>>     at java.sql.DriverManager.getConnection(DriverManager.java:215)
>>>>>>>     at com.hivejdbc.Con.main(Con.java:16)
>>>>>>>
>>>>>>>
>>>>>>> My connection program:
>>>>>>>
>>>>>>>   Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver");
>>>>>>>   Connection conn =
>>>>>>> DriverManager.getConnection("jdbc:hive://localhost:10000/poc",
"hiveuser1",
>>>>>>> "hiveuser1");
>>>>>>>
>>>>>>>
>>>>>>> *I am started Hive thrift server:*
>>>>>>> $ hive --service hiveserver -p 10000
>>>>>>>
>>>>>>> (tried with ports 10000 ans 10001)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> *Hive-site.xml*
>>>>>>>
>>>>>>> <property>
>>>>>>>     <name>hive.metastore.uris</name>
>>>>>>>     <value>thrift://localhost.localdomain:10000</value>
>>>>>>>   </property>
>>>>>>>
>>>>>>> <property>
>>>>>>> <name>javax.jdo.option.ConnectionURL</name>
>>>>>>>
>>>>>>> <value>jdbc:mysql://localhost:3306/metastore?createDatabaseIfNotExist=true</value>
>>>>>>>   <description>the URL of the MySQL database</description>
>>>>>>> </property>
>>>>>>>
>>>>>>> <property>
>>>>>>>   <name>javax.jdo.option.ConnectionDriverName</name>
>>>>>>>   <value>com.mysql.jdbc.Driver</value>
>>>>>>> </property>
>>>>>>>
>>>>>>> <property>
>>>>>>>   <name>javax.jdo.option.ConnectionUserName</name>
>>>>>>>   <value>hiveuser1</value>
>>>>>>> </property>
>>>>>>>
>>>>>>> <property>
>>>>>>>   <name>javax.jdo.option.ConnectionPassword</name>
>>>>>>>   <value>hiveuser1</value>
>>>>>>> </property>
>>>>>>>
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Sanjeevv
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>  Regards
>>>>>> Shengjun
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

Mime
View raw message