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
>>>>
>>>
>>>
>>
>
<?xml version="1.0" encoding="UTF-8"?>
<!--Autogenerated by Cloudera Manager-->
<configuration>
<property>
<name>hive.metastore.local</name>
<value>true</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://localhost:9083</value>
</property>
<property>
<name>hive.metastore.client.socket.timeout</name>
<value>300</value>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>hive.warehouse.subdir.inherit.perms</name>
<value>true</value>
</property>
<property>
<name>mapred.reduce.tasks</name>
<value>-1</value>
</property>
<property>
<name>hive.exec.reducers.bytes.per.reducer</name>
<value>1073741824</value>
</property>
<property>
<name>hive.exec.reducers.max</name>
<value>999</value>
</property>
<property>
<name>hive.metastore.execute.setugi</name>
<value>true</value>
</property>
<property>
<name>hive.support.concurrency</name>
<value>true</value>
</property>
<property>
<name>hive.zookeeper.quorum</name>
<value>localhost.localdomain</value>
</property>
<property>
<name>hive.zookeeper.client.port</name>
<value>2181</value>
</property>
<property>
<name>hbase.zookeeper.quorum</name>
<value>localhost.localdomain</value>
</property>
<property>
<name>hbase.zookeeper.property.clientPort</name>
<value>2181</value>
</property>
<property>
<name>hive.zookeeper.namespace</name>
<value>hive_zookeeper_namespace_hive</value>
</property>
<property>
<name>hive.server2.enable.doAs</name>
<value>true</value>
</property>
<property>
<name>fs.hdfs.impl.disable.cache</name>
<value>true</value>
</property>
<property>
<name>hive.server2.use.SSL</name>
<value>false</value>
</property>
<!-- peopertied added by Sanjeevv fr Hive metastore-->
<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>hive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
</property>
<property>
<name>hive.server.thrift.port</name>
<value>10000</value>
</property>
</configuration>
