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 <sanj2e...@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.tange...@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 <sanj2e...@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.tange...@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 <s...@gopivotal.com>wrote:
>>>>
>>>>> Can you use command line to connect hive?
>>>>>
>>>>>
>>>>> On Mon, May 19, 2014 at 4:59 AM, Sanjeevv Sriram
>>>>> <sanj2e...@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
>>>>>
>>>>
>>>>
>>>
>>
>
