hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From demian rosas <demia...@gmail.com>
Subject Re: Problem when trying to connect to hive server using jdbc
Date Wed, 03 Apr 2013 02:50:57 GMT
Done, unfortunately the output remain the same.

with both,

<property>
  <name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>

commented and uncommented.




On 2 April 2013 19:38, Sanjay Subramanian <
Sanjay.Subramanian@wizecommerce.com> wrote:

>  Add
> 127.0.0.1       localhost
>
>  Comment
>  #127.0.0.1 localhost.localdomainloghost
>
>  So the file should look like
>
>  127.0.0.1       localhost
>  #127.0.0.1 localhost.localdomainloghost
>   10.240.81.72 myhost.myemployer.com myhost
>
>
>
>    From: demian rosas <demianrh@gmail.com>
> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
> Date: Tuesday, April 2, 2013 7:33 PM
> To: "user@hive.apache.org" <user@hive.apache.org>
> Subject: Re: Problem when trying to connect to hive server using jdbc
>
>   # Do not remove the following line, or various programs
>  # that require network functionality will fail.
> 127.0.0.1 localhost.localdomainloghost
> 10.240.81.72 myhost.myemployer.com myhost
>
>
> On 2 April 2013 19:27, Sanjay Subramanian <
> Sanjay.Subramanian@wizecommerce.com> wrote:
>
>>  Whats in your /etc/hosts ?
>>
>>   From: demian rosas <demianrh@gmail.com>
>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>> Date: Tuesday, April 2, 2013 7:24 PM
>> To: "user@hive.apache.org" <user@hive.apache.org>
>> Subject: Re: Problem when trying to connect to hive server using jdbc
>>
>>   I did it. It seems to get connected to the metastore at least for a
>> moment, but then the connection is lost.
>>
>>  This is the output:
>>
>>  hive> show tables;
>> 13/04/02 19:22:37 INFO ql.Driver: <PERFLOG method=Driver.run>
>> 13/04/02 19:22:37 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
>> 13/04/02 19:22:37 INFO ql.Driver: <PERFLOG method=compile>
>> 13/04/02 19:22:37 INFO parse.ParseDriver: Parsing command: show tables
>> 13/04/02 19:22:37 INFO parse.ParseDriver: Parse Completed
>> 13/04/02 19:22:37 INFO ql.Driver: Semantic Analysis Completed
>> 13/04/02 19:22:37 INFO exec.ListSinkOperator: Initializing Self 0 OP
>> 13/04/02 19:22:37 INFO exec.ListSinkOperator: Operator 0 OP initialized
>> 13/04/02 19:22:37 INFO exec.ListSinkOperator: Initialization Done 0 OP
>> 13/04/02 19:22:37 INFO ql.Driver: Returning Hive schema:
>> Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from
>> deserializer)], properties:null)
>> 13/04/02 19:22:37 INFO ql.Driver: </PERFLOG method=compile
>> start=1364955757591 end=1364955757956 duration=365>
>> 13/04/02 19:22:37 INFO ql.Driver: <PERFLOG method=Driver.execute>
>> 13/04/02 19:22:37 INFO ql.Driver: Starting command: show tables
>> 13/04/02 19:22:37 INFO ql.Driver: </PERFLOG method=TimeToSubmit
>> start=1364955757591 end=1364955757969 duration=378>
>> 13/04/02 19:22:38 INFO hive.metastore: Trying to connect to metastore
>> with URI thrift://10.240.81.72:3306
>> 13/04/02 19:22:38 INFO hive.metastore: Waiting 1 seconds before next
>> connection attempt.
>> 13/04/02 19:22:39 INFO hive.metastore: Connected to metastore.
>> 13/04/02 19:22:40 WARN metastore.RetryingMetaStoreClient: MetaStoreClient
>> lost connection. Attempting to reconnect.
>> org.apache.thrift.transport.TTransportException
>>         at
>> org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
>>         at
>> org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
>>         at
>> org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:354)
>>         at
>> org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:215)
>>         at
>> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
>>         at
>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_database(ThriftHiveMetastore.java:412)
>>         at
>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_database(ThriftHiveMetastore.java:399)
>>         at
>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabase(HiveMetaStoreClient.java:736)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>         at
>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74)
>>         at $Proxy9.getDatabase(Unknown Source)
>>         at
>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1114)
>>         at
>> org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1103)
>>         at
>> org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206)
>>         at
>> org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334)
>>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
>>         at
>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1352)
>>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1138)
>>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>>         at
>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
>>         at
>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
>>         at
>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
>>         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
>>         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>         at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
>> 13/04/02 19:22:41 INFO hive.metastore: Trying to connect to metastore
>> with URI thrift://10.240.81.72:3306
>> 13/04/02 19:22:41 INFO hive.metastore: Waiting 1 seconds before next
>> connection attempt.
>>  13/04/02 19:22:42 INFO hive.metastore: Connected to metastore.
>> FAILED: Error in metadata: org.apache.thrift.transport.TTransportException
>> 13/04/02 19:22:43 ERROR exec.Task: FAILED: Error in metadata:
>> org.apache.thrift.transport.TTransportException
>> org.apache.hadoop.hive.ql.metadata.HiveException:
>> org.apache.thrift.transport.TTransportException
>>         at
>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1118)
>>         at
>> org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1103)
>>         at
>> org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206)
>>         at
>> org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334)
>>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
>>         at
>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1352)
>>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1138)
>>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>>         at
>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
>>         at
>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
>>         at
>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
>>         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
>>         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>         at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
>> Caused by: org.apache.thrift.transport.TTransportException
>>         at
>> org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
>>         at
>> org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
>>         at
>> org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:354)
>>         at
>> org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:215)
>>         at
>> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
>>         at
>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_database(ThriftHiveMetastore.java:412)
>>         at
>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_database(ThriftHiveMetastore.java:399)
>>         at
>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabase(HiveMetaStoreClient.java:736)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>         at
>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74)
>>         at $Proxy9.getDatabase(Unknown Source)
>>         at
>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1114)
>>         ... 18 more
>>
>>  FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask
>> 13/04/02 19:22:43 ERROR ql.Driver: FAILED: Execution Error, return code 1
>> from org.apache.hadoop.hive.ql.exec.DDLTask
>> 13/04/02 19:22:43 INFO ql.Driver: </PERFLOG method=Driver.execute
>> start=1364955757956 end=1364955763090 duration=5134>
>> 13/04/02 19:22:43 INFO ql.Driver: <PERFLOG method=releaseLocks>
>> 13/04/02 19:22:43 INFO ql.Driver: </PERFLOG method=releaseLocks
>> start=1364955763090 end=1364955763090 duration=0>
>> 13/04/02 19:22:43 INFO exec.ListSinkOperator: 0 finished. closing...
>> 13/04/02 19:22:43 INFO exec.ListSinkOperator: 0 forwarded 0 rows
>> 13/04/02 19:22:43 INFO ql.Driver: <PERFLOG method=releaseLocks>
>> 13/04/02 19:22:43 INFO ql.Driver: </PERFLOG method=releaseLocks
>> start=1364955763092 end=1364955763092 duration=0>
>> hive>
>>
>>
>>
>>
>> On 2 April 2013 19:12, Sanjay Subramanian <
>> Sanjay.Subramanian@wizecommerce.com> wrote:
>>
>>>  Can u try commenting out this section and restart
>>>
>>>   <property>
>>>    <name>javax.jdo.option.ConnectionURL</name>
>>>
>>> <value>jdbc:mysql://FQDN/metastore?createDatabaseIfNotExist=false</value>
>>>    <description>JDBC connect string for a JDBC metastore</description>
>>>  </property>
>>>
>>>
>>>   From: demian rosas <demianrh@gmail.com>
>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>> Date: Tuesday, April 2, 2013 7:06 PM
>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>> Subject: Re: Problem when trying to connect to hive server using jdbc
>>>
>>>   I could not connect to the metastore. The output is this:
>>>
>>>  hive> show tables;
>>> 13/04/02 19:01:14 INFO ql.Driver: <PERFLOG method=Driver.run>
>>> 13/04/02 19:01:14 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
>>> 13/04/02 19:01:14 INFO ql.Driver: <PERFLOG method=compile>
>>> 13/04/02 19:01:14 INFO parse.ParseDriver: Parsing command: show tables
>>> 13/04/02 19:01:15 INFO parse.ParseDriver: Parse Completed
>>> 13/04/02 19:01:15 INFO ql.Driver: Semantic Analysis Completed
>>> 13/04/02 19:01:15 INFO exec.ListSinkOperator: Initializing Self 0 OP
>>> 13/04/02 19:01:15 INFO exec.ListSinkOperator: Operator 0 OP initialized
>>> 13/04/02 19:01:15 INFO exec.ListSinkOperator: Initialization Done 0 OP
>>> 13/04/02 19:01:15 INFO ql.Driver: Returning Hive schema:
>>> Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from
>>> deserializer)], properties:null)
>>> 13/04/02 19:01:15 INFO ql.Driver: </PERFLOG method=compile
>>> start=1364954474899 end=1364954475234 duration=335>
>>> 13/04/02 19:01:15 INFO ql.Driver: <PERFLOG method=Driver.execute>
>>> 13/04/02 19:01:15 INFO ql.Driver: Starting command: show tables
>>> 13/04/02 19:01:15 INFO ql.Driver: </PERFLOG method=TimeToSubmit
>>> start=1364954474899 end=1364954475247 duration=348>
>>> 13/04/02 19:01:15 INFO hive.metastore: Trying to connect to metastore
>>> with URI thrift://10.240.81.72:9083
>>> 13/04/02 19:01:15 WARN hive.metastore: Failed to connect to the
>>> MetaStore Server...
>>> 13/04/02 19:01:15 INFO hive.metastore: Waiting 1 seconds before next
>>> connection attempt.
>>> 13/04/02 19:01:16 INFO hive.metastore: Trying to connect to metastore
>>> with URI thrift://10.240.81.72:9083
>>> 13/04/02 19:01:16 WARN hive.metastore: Failed to connect to the
>>> MetaStore Server...
>>> 13/04/02 19:01:16 INFO hive.metastore: Waiting 1 seconds before next
>>> connection attempt.
>>> 13/04/02 19:01:17 INFO hive.metastore: Trying to connect to metastore
>>> with URI thrift://10.240.81.72:9083
>>> 13/04/02 19:01:17 WARN hive.metastore: Failed to connect to the
>>> MetaStore Server...
>>> 13/04/02 19:01:17 INFO hive.metastore: Waiting 1 seconds before next
>>> connection attempt.
>>> FAILED: Error in metadata: java.lang.RuntimeException: Unable to
>>> instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>>> 13/04/02 19:01:18 ERROR exec.Task: FAILED: Error in metadata:
>>> java.lang.RuntimeException: Unable to instantiate
>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>>> org.apache.hadoop.hive.ql.metadata.HiveException:
>>> java.lang.RuntimeException: Unable to instantiate
>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>>>         at
>>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1118)
>>>         at
>>> org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1103)
>>>         at
>>> org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206)
>>>         at
>>> org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334)
>>>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
>>>         at
>>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1352)
>>>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1138)
>>>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>>>         at
>>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
>>>         at
>>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
>>>         at
>>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
>>>         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
>>>         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
>>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>         at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>         at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>>         at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
>>> Caused by: java.lang.RuntimeException: Unable to instantiate
>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>>>          at
>>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1084)
>>>         at
>>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:51)
>>>         at
>>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:61)
>>>         at
>>> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2140)
>>>         at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2151)
>>>         at
>>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1114)
>>>         ... 18 more
>>> Caused by: java.lang.reflect.InvocationTargetException
>>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>> Method)
>>>         at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>>         at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>>         at
>>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>>         at
>>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1082)
>>>         ... 23 more
>>> Caused by: MetaException(message:Could not connect to meta store using
>>> any of the URIs provided. Most recent failure:
>>> org.apache.thrift.transport.TTransportException: java.net.ConnectException:
>>> Connection refused
>>>         at org.apache.thrift.transport.TSocket.open(TSocket.java:185)
>>>         at
>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:277)
>>>         at
>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:163)
>>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>> Method)
>>>         at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>>         at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>>         at
>>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>>         at
>>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1082)
>>>         at
>>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:51)
>>>         at
>>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:61)
>>>         at
>>> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2140)
>>>         at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2151)
>>>         at
>>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1114)
>>>         at
>>> org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1103)
>>>         at
>>> org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206)
>>>         at
>>> org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334)
>>>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
>>>         at
>>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1352)
>>>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1138)
>>>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>>>         at
>>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
>>>         at
>>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
>>>         at
>>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
>>>         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
>>>         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
>>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>         at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>         at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>>         at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
>>> Caused by: java.net.ConnectException: Connection refused
>>>         at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>         at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
>>>         at
>>> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
>>>         at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
>>>         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
>>>         at java.net.Socket.connect(Socket.java:529)
>>>         at org.apache.thrift.transport.TSocket.open(TSocket.java:180)
>>>         ... 30 more
>>> )
>>>         at
>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:323)
>>>         at
>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:163)
>>>         ... 28 more
>>>  FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>> 13/04/02 19:01:18 ERROR ql.Driver: FAILED: Execution Error, return code
>>> 1 from org.apache.hadoop.hive.ql.exec.DDLTask
>>> 13/04/02 19:01:18 INFO ql.Driver: </PERFLOG method=Driver.execute
>>> start=1364954475234 end=1364954478298 duration=3064>
>>> 13/04/02 19:01:18 INFO ql.Driver: <PERFLOG method=releaseLocks>
>>> 13/04/02 19:01:18 INFO ql.Driver: </PERFLOG method=releaseLocks
>>> start=1364954478298 end=1364954478298 duration=0>
>>> 13/04/02 19:01:18 INFO exec.ListSinkOperator: 0 finished. closing...
>>> 13/04/02 19:01:18 INFO exec.ListSinkOperator: 0 forwarded 0 rows
>>> 13/04/02 19:01:18 INFO ql.Driver: <PERFLOG method=releaseLocks>
>>> 13/04/02 19:01:18 INFO ql.Driver: </PERFLOG method=releaseLocks
>>> start=1364954478301 end=1364954478301 duration=0>
>>>
>>>
>>>
>>>
>>>  I have run the script to create the metastore tables and created the
>>> user with the appropriate permissions. This is the output I get when I
>>> connect to the metastore database using the my hive_user and executing
>>> "show tables":
>>>
>>>  BUCKETING_COLS
>>> CDS
>>> COLUMNS_V2
>>> DATABASE_PARAMS
>>> DBS
>>> DB_PRIVS
>>> GLOBAL_PRIVS
>>> IDXS
>>> INDEX_PARAMS
>>> NUCLEUS_TABLES
>>> PARTITIONS
>>> PARTITION_EVENTS
>>> PARTITION_KEYS
>>> PARTITION_KEY_VALS
>>> PARTITION_PARAMS
>>> PART_COL_PRIVS
>>> PART_COL_STATS
>>> PART_PRIVS
>>> ROLES
>>> ROLE_MAP
>>> SDS
>>> SD_PARAMS
>>> SEQUENCE_TABLE
>>> SERDES
>>> SERDE_PARAMS
>>> SKEWED_COL_NAMES
>>> SKEWED_COL_VALUE_LOC_MAP
>>> SKEWED_STRING_LIST
>>> SKEWED_STRING_LIST_VALUES
>>> SKEWED_VALUES
>>> SORT_COLS
>>> TABLE_PARAMS
>>> TAB_COL_STATS
>>> TBLS
>>> TBL_COL_PRIVS
>>> TBL_PRIVS
>>> TYPES
>>> TYPE_FIELDS
>>>
>>>
>>>
>>>
>>>
>>> On 2 April 2013 18:55, Sanjay Subramanian <
>>> Sanjay.Subramanian@wizecommerce.com> wrote:
>>>
>>>>   Try the following…I am hoping you have run the hive MYSQL SOURCE
>>>> script to create the metastore tables and created hive_user  with
>>>> appropriate permissions
>>>>
>>>>  Change localhost to FQDN
>>>>  <property>
>>>>    <name>javax.jdo.option.ConnectionURL</name>
>>>>
>>>> <value>jdbc:mysql://FQDN/metastore?createDatabaseIfNotExist=false</value>
>>>>    <description>JDBC connect string for a JDBC metastore</description>
>>>>  </property>
>>>>
>>>>  Change port from 3306 to 9083
>>>>  <property>
>>>>    <name>hive.metastore.uris</name>
>>>>    <value>thrift://my_ipaddress:3306</value>
>>>>    <description>IP address (or fully-qualified domain name) and port of
>>>> the metastore host</description>
>>>>  </property>
>>>>
>>>>
>>>>
>>>>
>>>>   From: demian rosas <demianrh@gmail.com>
>>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>>> Date: Tuesday, April 2, 2013 6:48 PM
>>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>>> Subject: Re: Problem when trying to connect to hive server using jdbc
>>>>
>>>>   My linux version is
>>>>
>>>>  Linux myhost 2.6.18-308.4.1.0.1.el5xen #1 SMP Tue Apr 17 16:41:30 EDT
>>>> 2012 x86_64 x86_64 x86_64 GNU/Linux
>>>>
>>>>  which is some version of Oracle linux which is supposed to be Red Hat
>>>> compatible
>>>>
>>>>  > echo $HADOOP_MAPRED_HOME
>>>>  /usr/lib/hadoop-0.20-mapreduce
>>>>
>>>>  > echo $HIVE_HOME
>>>>  /usr/lib/hive/
>>>>
>>>>  These variables see to be fine.
>>>>
>>>>  Just a little bit more of context:
>>>>
>>>>  I am trying to set a hive installation using a remote mysql
>>>> metastore. I am using CDH4.2 on a fresh installation. All this in a single
>>>> machine, so I am using hadoop pseudo distributed mode.
>>>>
>>>>  So far I have Hadoop working fine. MySql is working and I can connect
>>>> to it using jdbc from a java application. When I installed hive for the
>>>> first time, it was using the embedded mode and I was able to define an
>>>> external table pointing to an hdfs location and query the data with a hive
>>>> query. Until here everything was fine.
>>>>
>>>>  The problems started when I tried to set the remote mysql metastore.
>>>> I have followed the instructions provided here:
>>>> https://ccp.cloudera.com/display/CDH4DOC/Hive+Installation#HiveInstallation-ConfiguringtheHiveMetastore
>>>>
>>>>   Right now I am using hive-server 1 configuration. This are the
>>>> properties in my hive-site.xml file:
>>>>
>>>>  <property>
>>>>   <name>javax.jdo.option.ConnectionURL</name>
>>>>
>>>> <value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value>
>>>>   <description>JDBC connect string for a JDBC metastore</description>
>>>> </property>
>>>>
>>>>  <property>
>>>>   <name>javax.jdo.option.ConnectionDriverName</name>
>>>>   <value>com.mysql.jdbc.Driver</value>
>>>>   <description>Driver class name for a JDBC metastore</description>
>>>> </property>
>>>>
>>>>  <property>
>>>>   <name>javax.jdo.option.ConnectionUserName</name>
>>>>   <value>myuser</value>
>>>> </property>
>>>>
>>>>  <property>
>>>>   <name>javax.jdo.option.ConnectionPassword</name>
>>>>   <value>mypassword</value>
>>>> </property>
>>>>
>>>> <property>
>>>>   <name>datanucleus.autoCreateSchema</name>
>>>>   <value>false</value>
>>>> </property>
>>>>
>>>> <property>
>>>>   <name>datanucleus.fixedDatastore</name>
>>>>   <value>true</value>
>>>> </property>
>>>>
>>>> <property>
>>>>   <name>hive.metastore.uris</name>
>>>>   <value>thrift://my_ipaddress:3306</value>
>>>>   <description>IP address (or fully-qualified domain name) and port of
>>>> the metastore host</description>
>>>> </property>
>>>>
>>>>  <property>
>>>>   <name>hive.metastore.warehouse.dir</name>
>>>>   <value>/user/hive/warehouse</value>
>>>> </property>
>>>>
>>>>  <property>
>>>>   <name>hive.server.thrift.port</name>
>>>>    <value>10000</value>
>>>> </property>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 2 April 2013 18:36, Sanjay Subramanian <
>>>> Sanjay.Subramanian@wizecommerce.com> wrote:
>>>>
>>>>>  I just modified the hive batch file to echo some variables. These
>>>>> are what the variables are set to when I execute /usr/lib/hive/bin/hive
>>>>>
>>>>>  HADOOP=/usr/bin/../bin/hadoop
>>>>> HADOOP_HOME=/usr/bin/..
>>>>> HADOOP_VERSION=2.0.0-cdh4.1.2
>>>>>
>>>>>  R these variables set correctly for u  ?
>>>>> HADOOP_MAPRED_HOME=/usr/lib/hadoop-mapreduce
>>>>> HIVE_HOME=/usr/lib/hive
>>>>>
>>>>>  Which linux  are u running ?
>>>>>
>>>>>   From: demian rosas <demianrh@gmail.com>
>>>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>  Date: Tuesday, April 2, 2013 6:18 PM
>>>>>
>>>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>>>> Subject: Re: Problem when trying to connect to hive server using jdbc
>>>>>
>>>>>   The content of the indicated file on line 179 "area" is
>>>>>
>>>>>  # Save the regex to a var to workaround quoting incompatabilities
>>>>> # between Bash 3.1 and 3.2
>>>>>
>>>>> hadoop_version_re="^([[:digit:]]+)\.([[:digit:]]+)(\.([[:digit:]]+))?.*$"
>>>>>
>>>>>  if [[ "$HADOOP_VERSION" =~ $hadoop_version_re ]]; then
>>>>> #-------------------------------------------------------------------------------------->
>>>>> This is line 179
>>>>>     hadoop_major_ver=${BASH_REMATCH[1]}
>>>>>     hadoop_minor_ver=${BASH_REMATCH[2]}
>>>>>     hadoop_patch_ver=${BASH_REMATCH[4]}
>>>>> else
>>>>>     echo "Unable to determine Hadoop version information."
>>>>>     echo "'hadoop version' returned:"
>>>>>     echo `$HADOOP version`
>>>>>     exit 5
>>>>> fi
>>>>>
>>>>>  I do not see anything particularly wrong there.
>>>>>
>>>>>  What do you think?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On 2 April 2013 18:09, Sanjay Subramanian <
>>>>> Sanjay.Subramanian@wizecommerce.com> wrote:
>>>>>
>>>>>>  In the hive batch file
>>>>>> There seem to be some errors on 179…can u verify
>>>>>> sanjay
>>>>>>
>>>>>>   From: demian rosas <demianrh@gmail.com>
>>>>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>>  Date: Tuesday, April 2, 2013 5:56 PM
>>>>>>
>>>>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>> Subject: Re: Problem when trying to connect to hive server using jdbc
>>>>>>
>>>>>>   Yes,
>>>>>>
>>>>>>  I restart all Hadoop/Hive services every time I change something.
>>>>>>
>>>>>>  The content of my /var/log/hive/hive-metastore.log file is
>>>>>>
>>>>>>
>>>>>> -------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>  Exception in thread "main" java.lang.NoClassDefFoundError:
>>>>>> org/apache/hadoop/util/VersionInfo
>>>>>> Caused by: java.lang.ClassNotFoundException:
>>>>>> org.apache.hadoop.util.VersionInfo
>>>>>> at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
>>>>>> at java.security.AccessController.doPrivileged(Native Method)
>>>>>> at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
>>>>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
>>>>>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
>>>>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
>>>>>> Could not find the main class: org.apache.hadoop.util.VersionInfo.
>>>>>> Program will exit.
>>>>>> /usr/lib/hive/bin/hive: line 179: conditional binary operator expected
>>>>>> /usr/lib/hive/bin/hive: line 179: syntax error near unexpected token
>>>>>> `=~'
>>>>>> /usr/lib/hive/bin/hive: line 179: `if [[ "$HADOOP_VERSION" =~
>>>>>> $hadoop_version_re ]]; then'
>>>>>>
>>>>>> -------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>
>>>>>>   /var/log/hive/hive-server.log and  /var/log/hive/hive-server2.log
>>>>>> have the same content. But I do not think these seem to be outdated logs.
>>>>>>
>>>>>>  ll /var/log/hive/
>>>>>> total 24
>>>>>> 4 drwxr-xr-x  2 hive 4096 Feb 15 12:16 ./
>>>>>> 8 drwxr-xr-x 41 root 4096 Apr  1 21:02 ../
>>>>>> 4 -rw-r--r--  1 hive  863 Apr  2 17:06 hive-metastore.log
>>>>>> 4 -rw-r--r--  1 hive  863 Mar 28 14:01 hive-server.log
>>>>>> 4 -rw-r--r--  1 hive  863 Mar 29 19:10 hive-server2.log
>>>>>>
>>>>>>
>>>>>>  I suppose there must be others containing recent operations.
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 2 April 2013 17:38, Sanjay Subramanian <
>>>>>> Sanjay.Subramanian@wizecommerce.com> wrote:
>>>>>>
>>>>>>>  I assume u Restarted all services
>>>>>>> Sequence
>>>>>>> Stop hive-server2; hive-server1; Hive-meta-store
>>>>>>> Stop Hive-meta-store, hive-server1; hive-server2;
>>>>>>>
>>>>>>>  We should see  /var/log/hive/*.log to see any startup errors…we
>>>>>>> need to fix those first
>>>>>>>
>>>>>>>
>>>>>>>   From: demian rosas <demianrh@gmail.com>
>>>>>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>>>  Date: Tuesday, April 2, 2013 5:30 PM
>>>>>>>
>>>>>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>>> Subject: Re: Problem when trying to connect to hive server using
>>>>>>> jdbc
>>>>>>>
>>>>>>>   By the way, I have hive-metastore and hive-server services running
>>>>>>>
>>>>>>>
>>>>>>> On 2 April 2013 17:26, demian rosas <demianrh@gmail.com> wrote:
>>>>>>>
>>>>>>>> Thanks for the hints.
>>>>>>>>
>>>>>>>>  I have tried everything suggested.
>>>>>>>>
>>>>>>>>  Configured for using hive-server 1, got mysql connector 5.1.22,
>>>>>>>> set  hive.server.thrift.port in hive-site.xml have also double
>>>>>>>> checked the CLASSPATH.
>>>>>>>>
>>>>>>>>  My mysql server is in the same machine as my hadoop/hive
>>>>>>>> configuration.
>>>>>>>>
>>>>>>>>  I can connect to mysql using jdbc with the credentials set in
>>>>>>>> hive-site.xml.
>>>>>>>>
>>>>>>>>  I fixed hive.metastore.uris to contain the IP address of my
>>>>>>>> machine instead of "localhost". Now when I run "show tables" with debug
>>>>>>>> messages in the hive console I get this:
>>>>>>>>
>>>>>>>>
>>>>>>>> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>  hive> show tables;
>>>>>>>> 13/04/02 17:10:25 INFO ql.Driver: <PERFLOG method=Driver.run>
>>>>>>>> 13/04/02 17:10:25 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
>>>>>>>> 13/04/02 17:10:25 INFO ql.Driver: <PERFLOG method=compile>
>>>>>>>> 13/04/02 17:10:25 INFO parse.ParseDriver: Parsing command: show
>>>>>>>> tables
>>>>>>>> 13/04/02 17:10:25 INFO parse.ParseDriver: Parse Completed
>>>>>>>> 13/04/02 17:10:26 INFO ql.Driver: Semantic Analysis Completed
>>>>>>>> 13/04/02 17:10:26 INFO exec.ListSinkOperator: Initializing Self 0 OP
>>>>>>>> 13/04/02 17:10:26 INFO exec.ListSinkOperator: Operator 0 OP
>>>>>>>> initialized
>>>>>>>> 13/04/02 17:10:26 INFO exec.ListSinkOperator: Initialization Done 0
>>>>>>>> OP
>>>>>>>> 13/04/02 17:10:26 INFO ql.Driver: Returning Hive schema:
>>>>>>>> Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from
>>>>>>>> deserializer)], properties:null)
>>>>>>>> 13/04/02 17:10:26 INFO ql.Driver: </PERFLOG method=compile
>>>>>>>> start=1364947825805 end=1364947826183 duration=378>
>>>>>>>> 13/04/02 17:10:26 INFO ql.Driver: <PERFLOG method=Driver.execute>
>>>>>>>> 13/04/02 17:10:26 INFO ql.Driver: Starting command: show tables
>>>>>>>> 13/04/02 17:10:26 INFO ql.Driver: </PERFLOG method=TimeToSubmit
>>>>>>>> start=1364947825805 end=1364947826197 duration=392>
>>>>>>>> 13/04/02 17:10:26 INFO hive.metastore: Trying to connect to
>>>>>>>> metastore with URI thrift://10.240.81.72:3306
>>>>>>>> 13/04/02 17:10:26 INFO hive.metastore: Waiting 1 seconds before
>>>>>>>> next connection attempt.
>>>>>>>> 13/04/02 17:10:27 INFO hive.metastore: Connected to metastore.
>>>>>>>> 13/04/02 17:10:28 WARN metastore.RetryingMetaStoreClient:
>>>>>>>> MetaStoreClient lost connection. Attempting to reconnect.
>>>>>>>> org.apache.thrift.transport.TTransportException
>>>>>>>>         at
>>>>>>>> org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:354)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:215)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_database(ThriftHiveMetastore.java:412)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_database(ThriftHiveMetastore.java:399)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabase(HiveMetaStoreClient.java:736)
>>>>>>>>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>>>>>>> Method)
>>>>>>>>         at
>>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>>>>>>         at
>>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>>>>>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>>>>          at
>>>>>>>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74)
>>>>>>>>         at $Proxy9.getDatabase(Unknown Source)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1114)
>>>>>>>>          at
>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1103)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1352)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1138)
>>>>>>>>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
>>>>>>>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>>>>>>> Method)
>>>>>>>>         at
>>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>>>>>>         at
>>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>>>>>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>>>>         at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
>>>>>>>>  13/04/02 17:10:29 INFO hive.metastore: Trying to connect to
>>>>>>>> metastore with URI thrift://10.240.81.72:3306
>>>>>>>> 13/04/02 17:10:29 INFO hive.metastore: Waiting 1 seconds before
>>>>>>>> next connection attempt.
>>>>>>>> 13/04/02 17:10:30 INFO hive.metastore: Connected to metastore.
>>>>>>>> FAILED: Error in metadata:
>>>>>>>> org.apache.thrift.transport.TTransportException
>>>>>>>> 13/04/02 17:10:31 ERROR exec.Task: FAILED: Error in metadata:
>>>>>>>> org.apache.thrift.transport.TTransportException
>>>>>>>> org.apache.hadoop.hive.ql.metadata.HiveException:
>>>>>>>> org.apache.thrift.transport.TTransportException
>>>>>>>>          at
>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1118)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1103)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1352)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1138)
>>>>>>>>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
>>>>>>>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>>>>>>> Method)
>>>>>>>>         at
>>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>>>>>>         at
>>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>>>>>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>>>>         at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
>>>>>>>>  Caused by: org.apache.thrift.transport.TTransportException
>>>>>>>>         at
>>>>>>>> org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:354)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:215)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_database(ThriftHiveMetastore.java:412)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_database(ThriftHiveMetastore.java:399)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabase(HiveMetaStoreClient.java:736)
>>>>>>>>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>>>>>>> Method)
>>>>>>>>         at
>>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>>>>>>         at
>>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>>>>>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>>>>          at
>>>>>>>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74)
>>>>>>>>         at $Proxy9.getDatabase(Unknown Source)
>>>>>>>>          at
>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1114)
>>>>>>>>         ... 18 more
>>>>>>>>
>>>>>>>>   FAILED: Execution Error, return code 1 from
>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>>>>>>  13/04/02 17:10:31 ERROR ql.Driver: FAILED: Execution Error,
>>>>>>>> return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
>>>>>>>> 13/04/02 17:10:31 INFO ql.Driver: </PERFLOG method=Driver.execute
>>>>>>>> start=1364947826183 end=1364947831388 duration=5205>
>>>>>>>> 13/04/02 17:10:31 INFO ql.Driver: <PERFLOG method=releaseLocks>
>>>>>>>> 13/04/02 17:10:31 INFO ql.Driver: </PERFLOG method=releaseLocks
>>>>>>>> start=1364947831388 end=1364947831388 duration=0>
>>>>>>>> 13/04/02 17:10:31 INFO exec.ListSinkOperator: 0 finished.
>>>>>>>> closing...
>>>>>>>> 13/04/02 17:10:31 INFO exec.ListSinkOperator: 0 forwarded 0 rows
>>>>>>>> 13/04/02 17:10:31 INFO ql.Driver: <PERFLOG method=releaseLocks>
>>>>>>>> 13/04/02 17:10:31 INFO ql.Driver: </PERFLOG method=releaseLocks
>>>>>>>> start=1364947831391 end=1364947831391 duration=0>
>>>>>>>> hive>
>>>>>>>>
>>>>>>>> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>
>>>>>>>>  When I try to connect using jdbc from a java program I get this:
>>>>>>>>
>>>>>>>>
>>>>>>>> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>
>>>>>>>>   log4j:ERROR Could not instantiate class
>>>>>>>> [org.apache.hadoop.log.metrics.EventCounter].
>>>>>>>> java.lang.ClassNotFoundException:
>>>>>>>> org.apache.hadoop.log.metrics.EventCounter
>>>>>>>>         at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>>>>>>>>         at java.security.AccessController.doPrivileged(Native
>>>>>>>> Method)
>>>>>>>>         at
>>>>>>>> java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>>>>>>>>         at
>>>>>>>> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>>>>>>>>         at java.lang.Class.forName0(Native Method)
>>>>>>>>         at java.lang.Class.forName(Class.java:169)
>>>>>>>>         at
>>>>>>>> org.apache.log4j.helpers.Loader.loadClass(Loader.java:198)
>>>>>>>>          at
>>>>>>>> org.apache.log4j.helpers.OptionConverter.instantiateByClassName(OptionConverter.java:327)
>>>>>>>>         at
>>>>>>>> org.apache.log4j.helpers.OptionConverter.instantiateByKey(OptionConverter.java:124)
>>>>>>>>         at
>>>>>>>> org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:785)
>>>>>>>>         at
>>>>>>>> org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:768)
>>>>>>>>         at
>>>>>>>> org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:648)
>>>>>>>>         at
>>>>>>>> org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:514)
>>>>>>>>         at
>>>>>>>> org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:580)
>>>>>>>>         at
>>>>>>>> org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526)
>>>>>>>>          at
>>>>>>>> org.apache.log4j.LogManager.<clinit>(LogManager.java:127)
>>>>>>>>          at
>>>>>>>> org.slf4j.impl.Log4jLoggerFactory.getLogger(Log4jLoggerFactory.java:73)
>>>>>>>>         at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:242)
>>>>>>>>         at
>>>>>>>> org.apache.thrift.transport.TIOStreamTransport.<clinit>(TIOStreamTransport.java:38)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:110)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>>>>>>>>          at
>>>>>>>> java.sql.DriverManager.getConnection(DriverManager.java:582)
>>>>>>>>         at
>>>>>>>> java.sql.DriverManager.getConnection(DriverManager.java:185)
>>>>>>>>          at Conn.main(Conn.java:19)
>>>>>>>>  log4j:ERROR Could not instantiate appender named "EventCounter".
>>>>>>>>  Exception in thread "main" java.lang.NoClassDefFoundError:
>>>>>>>> org/apache/hadoop/io/Writable
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:193)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:127)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.jdbc.HiveConnection.configureConnection(HiveConnection.java:126)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:121)
>>>>>>>>         at
>>>>>>>> org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>>>>>>>>          at
>>>>>>>> java.sql.DriverManager.getConnection(DriverManager.java:582)
>>>>>>>>         at
>>>>>>>> java.sql.DriverManager.getConnection(DriverManager.java:185)
>>>>>>>>          at Conn.main(Conn.java:19)
>>>>>>>> Caused by: java.lang.ClassNotFoundException:
>>>>>>>> org.apache.hadoop.io.Writable
>>>>>>>>          at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>>>>>>>>         at java.security.AccessController.doPrivileged(Native
>>>>>>>> Method)
>>>>>>>>         at
>>>>>>>> java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>>>>>>>>         at
>>>>>>>> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>>>>>>>>          ... 8 more
>>>>>>>>
>>>>>>>> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>
>>>>>>>>  I have included serveral jars in my CLASSPATH
>>>>>>>>
>>>>>>>>
>>>>>>>> /usr/lib/hadoop/lib/slf4j-log4j12-1.6.1.jar:/usr/lib/hadoop-hdfs/hadoop-hdfs-2.0.0-cdh4.2.0.jar:/ade/b/
>>>>>>>> 4124940812
>>>>>>>> /oracle/jlib/oraclepki.jar:/home/drosash/hadoopConnectors/oraloaderHadoop/oraloaderV2forCDH4/oraloader-2.0.1-2/oraloader.jar:/usr/lib/hive/lib:/home/drosash/miscelaneous/mysql-connector-java-5.1.24/mysql-connector-java-5.1.22.jar:/usr/lib/hive/lib/hive-exec-0.10.0-cdh4.2.0.jar:/usr/lib/hive/lib/hive-jdbc-0.10.0-cdh4.2.0.jar:/usr/lib/hive/lib/hive-metastore-0.10.0-cdh4.2.0.jar:/usr/lib/hive/lib/hive-service-0.10.0-cdh4.2.0.jar:/usr/lib/hive/lib/libfb303-0.9.0.jar:/usr/lib/hadoop-0.20-mapreduce/hadoop-2.0.0-mr1-cdh4.2.0-core.jar:/usr/lib/hive/lib/commons-logging-api-1.0.4.jar:/usr/lib/hive/lib/commons-logging-1.0.4.jar:/usr/lib/hive/lib/commons-configuration-1.6.jar:/usr/lib/hadoop/lib/slf4j-api-1.6.1.jar:/usr/lib/hadoop/lib/log4j-1.2.17.jar:/usr/lib/hadoop/lib/commons-configuration-1.6.jar:/usr/lib/hadoop/lib/commons-io-2.4.jar:/usr/bin/hadoop:/usr/lib/hive/lib/commons-collections-3.2.1.jar
>>>>>>>>
>>>>>>>>  any other idea I could try?
>>>>>>>>
>>>>>>>>  Thank you very much,
>>>>>>>> Demian
>>>>>>>>
>>>>>>>>
>>>>>>>> On 1 April 2013 18:47, Sanjay Subramanian <
>>>>>>>> Sanjay.Subramanian@wizecommerce.com> wrote:
>>>>>>>>
>>>>>>>>>  Hi
>>>>>>>>>
>>>>>>>>>  Have u started hive-metastore service ? And Hive Server service ?
>>>>>>>>>
>>>>>>>>>  Check this value in hive-site.xml
>>>>>>>>> <property>
>>>>>>>>>    <name>hive.metastore.uris</name>
>>>>>>>>>   <value>thrift://FQDN:9083</value>
>>>>>>>>>   <description>IP address (or fully-qualified domain name) and
>>>>>>>>> port of the metastore host</description>
>>>>>>>>> </property>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>  I see that u r connecting to hive-server2.  If so then u must
>>>>>>>>> start hive-server2 service (u can check it using command line beeline CLI
>>>>>>>>> instead of hive CLI)
>>>>>>>>>
>>>>>>>>>  If u r using Hive-server and hive-server2 they must listen on
>>>>>>>>> separate ports
>>>>>>>>>
>>>>>>>>>  <property>
>>>>>>>>>   <name>hive.server2.thrift.port</name>
>>>>>>>>>    <value>10786</value>
>>>>>>>>> </property>
>>>>>>>>>
>>>>>>>>>  <property>
>>>>>>>>>   <name>hive.server.thrift.port</name>
>>>>>>>>>    <value>10000</value>
>>>>>>>>> </property>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>  I suggest u try the hive-server on 10000 first then move on to
>>>>>>>>> hive-server2
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>  Thanks
>>>>>>>>> sanjay
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>   From: demian rosas <demianrh@gmail.com>
>>>>>>>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>>>>>  Date: Monday, April 1, 2013 6:36 PM
>>>>>>>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>>>>> Subject: Re: Problem when trying to connect to hive server using
>>>>>>>>> jdbc
>>>>>>>>>
>>>>>>>>>   Hi,
>>>>>>>>>
>>>>>>>>>  Thanks a lot for your answer. I have done what you indicate
>>>>>>>>> already.
>>>>>>>>>
>>>>>>>>>  Actually now I was able to go a little bit ahead.
>>>>>>>>>
>>>>>>>>>  I am not using yarn. I am running CDH4.2 in pseudo distributed
>>>>>>>>> mode. I want to configure a mysql metastore (remote mode) in the same
>>>>>>>>> machine so that everything will be running in a single machine.
>>>>>>>>>
>>>>>>>>>  "Does hive CLI start successfully ? U can see debug messages by
>>>>>>>>> starting hive CLI this way
>>>>>>>>> $HIVE_HOME/bin/hive -hiveconf hive.root.logger=INFO,console"
>>>>>>>>>
>>>>>>>>>  I can start hive CLI successfully. When I call to show debug
>>>>>>>>> messages and execute "show tables", I am getting the following:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>>  hive> show tables;
>>>>>>>>> 13/04/01 18:20:40 INFO ql.Driver: <PERFLOG method=Driver.run>
>>>>>>>>> 13/04/01 18:20:40 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
>>>>>>>>> 13/04/01 18:20:40 INFO ql.Driver: <PERFLOG method=compile>
>>>>>>>>> 13/04/01 18:20:40 INFO parse.ParseDriver: Parsing command: show
>>>>>>>>> tables
>>>>>>>>> 13/04/01 18:20:40 INFO parse.ParseDriver: Parse Completed
>>>>>>>>> 13/04/01 18:20:40 INFO ql.Driver: Semantic Analysis Completed
>>>>>>>>> 13/04/01 18:20:40 INFO exec.ListSinkOperator: Initializing Self 0
>>>>>>>>> OP
>>>>>>>>> 13/04/01 18:20:40 INFO exec.ListSinkOperator: Operator 0 OP
>>>>>>>>> initialized
>>>>>>>>> 13/04/01 18:20:40 INFO exec.ListSinkOperator: Initialization Done
>>>>>>>>> 0 OP
>>>>>>>>> 13/04/01 18:20:40 INFO ql.Driver: Returning Hive schema:
>>>>>>>>> Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from
>>>>>>>>> deserializer)], properties:null)
>>>>>>>>> 13/04/01 18:20:40 INFO ql.Driver: </PERFLOG method=compile
>>>>>>>>> start=1364865640585 end=1364865640913 duration=328>
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client
>>>>>>>>> environment:zookeeper.version=3.4.5-cdh4.2.0--1, built on 02/15/2013 18:36
>>>>>>>>> GMT
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client environment:
>>>>>>>>> host.name=slc01euu.us.oracle.com
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client
>>>>>>>>> environment:java.version=1.6.0_37
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client
>>>>>>>>> environment:java.vendor=Sun Microsystems Inc.
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client
>>>>>>>>> environment:java.home=/ade_autofs/dd19_db/RDBMS/MAIN/LINUX.X64/130325/jdk6/jre
>>>>>>>>> ...
>>>>>>>>> ...
>>>>>>>>> ...
>>>>>>>>>  13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client
>>>>>>>>> environment:os.version=2.6.18-308.4.1.0.1.el5xen
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client environment:
>>>>>>>>> user.name=drosash
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client
>>>>>>>>> environment:user.home=/home/drosash
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Client
>>>>>>>>> environment:user.dir=/home/drosash/miscelaneous
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ZooKeeper: Initiating client
>>>>>>>>> connection, connectString=localhost:2181 sessionTimeout=600000
>>>>>>>>> watcher=org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockManager$DummyWatcher@f35f44e
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ClientCnxn: Opening socket
>>>>>>>>> connection to server localhost.localdomain/127.0.0.1:2181. Will
>>>>>>>>> not attempt to authenticate using SASL (Unable to locate a login
>>>>>>>>> configuration)
>>>>>>>>> 13/04/01 18:20:40 INFO zookeeper.ClientCnxn: Socket connection
>>>>>>>>> established to localhost.localdomain/127.0.0.1:2181, initiating
>>>>>>>>> session
>>>>>>>>> 13/04/01 18:20:41 INFO zookeeper.ClientCnxn: Session establishment
>>>>>>>>> complete on server localhost.localdomain/127.0.0.1:2181,
>>>>>>>>> sessionid = 0x13dc843aabf0000, negotiated timeout = 40000
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: <PERFLOG
>>>>>>>>> method=acquireReadWriteLocks>
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: </PERFLOG
>>>>>>>>> method=acquireReadWriteLocks start=1364865641054 end=1364865641055
>>>>>>>>> duration=1>
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: <PERFLOG method=Driver.execute>
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: Starting command: show tables
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: </PERFLOG method=TimeToSubmit
>>>>>>>>> start=1364865640585 end=1364865641070 duration=485>
>>>>>>>>> 13/04/01 18:20:41 INFO hive.metastore: Trying to connect to
>>>>>>>>> metastore with URI thrift://0.0.0.0.0:3306
>>>>>>>>> FAILED: Error in metadata: java.lang.RuntimeException: Unable to
>>>>>>>>> instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>>>>>>>>> 13/04/01 18:20:41 ERROR exec.Task: FAILED: Error in metadata:
>>>>>>>>> java.lang.RuntimeException: Unable to instantiate
>>>>>>>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>>>>>>>>> org.apache.hadoop.hive.ql.metadata.HiveException:
>>>>>>>>> java.lang.RuntimeException: Unable to instantiate
>>>>>>>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1118)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1103)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1352)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1138)
>>>>>>>>>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
>>>>>>>>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>>>>>>>> Method)
>>>>>>>>>         at
>>>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>>>>>>>         at
>>>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>>>>>>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>>>>>         at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
>>>>>>>>> Caused by: java.lang.RuntimeException: Unable to instantiate
>>>>>>>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1084)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:51)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:61)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2140)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2151)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1114)
>>>>>>>>>         ... 18 more
>>>>>>>>> Caused by: java.lang.reflect.InvocationTargetException
>>>>>>>>>         at
>>>>>>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>>>>>>>>         at
>>>>>>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>>>>>>>>         at
>>>>>>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>>>>>>>>         at
>>>>>>>>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1082)
>>>>>>>>>         ... 23 more
>>>>>>>>> Caused by: java.lang.NullPointerException
>>>>>>>>>         at
>>>>>>>>> org.apache.thrift.transport.TSocket.open(TSocket.java:168)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:277)
>>>>>>>>>         at
>>>>>>>>> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:163)
>>>>>>>>>         ... 28 more
>>>>>>>>>
>>>>>>>>>  FAILED: Execution Error, return code 1 from
>>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>>>>>>> 13/04/01 18:20:41 ERROR ql.Driver: FAILED: Execution Error, return
>>>>>>>>> code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: </PERFLOG method=Driver.execute
>>>>>>>>> start=1364865641055 end=1364865641098 duration=43>
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: <PERFLOG method=releaseLocks>
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: </PERFLOG method=releaseLocks
>>>>>>>>> start=1364865641098 end=1364865641098 duration=0>
>>>>>>>>> 13/04/01 18:20:41 INFO exec.ListSinkOperator: 0 finished.
>>>>>>>>> closing...
>>>>>>>>> 13/04/01 18:20:41 INFO exec.ListSinkOperator: 0 forwarded 0 rows
>>>>>>>>>  13/04/01 18:20:41 INFO ql.Driver: <PERFLOG method=releaseLocks>
>>>>>>>>> 13/04/01 18:20:41 INFO ql.Driver: </PERFLOG method=releaseLocks
>>>>>>>>> start=1364865641101 end=1364865641101 duration=0>
>>>>>>>>> 13/04/01 18:20:41 INFO zookeeper.ZooKeeper: Session:
>>>>>>>>> 0x13dc843aabf0000 closed
>>>>>>>>> hive> 13/04/01 18:20:41 INFO zookeeper.ClientCnxn: EventThread
>>>>>>>>> shut down
>>>>>>>>>
>>>>>>>>> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>>
>>>>>>>>>  and then nothing else happens.
>>>>>>>>>
>>>>>>>>>  When I try to connect from a java app (code shown below) using
>>>>>>>>> jdbc, I get the following:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>>  import java.sql.*;
>>>>>>>>>
>>>>>>>>>  class Conn {
>>>>>>>>>   public static void main (String[] args) throws Exception
>>>>>>>>>   {
>>>>>>>>>    Class.forName ("org.apache.hive.jdbc.HiveDriver");
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>  Connection conn = DriverManager.getConnection
>>>>>>>>>                    ("jdbc:hive2://0.0.0.0.0:10000/default", "",
>>>>>>>>> "");
>>>>>>>>>
>>>>>>>>>     try {
>>>>>>>>>      Statement stmt = conn.createStatement();
>>>>>>>>>      try {
>>>>>>>>>        ResultSet rset = stmt.executeQuery("show tables");
>>>>>>>>>         try {
>>>>>>>>>          while (rset.next())
>>>>>>>>>            System.out.println (rset.getString(1));   // Print col 1
>>>>>>>>>        }
>>>>>>>>>        finally {
>>>>>>>>>           try { rset.close(); } catch (Exception ignore) {}
>>>>>>>>>        }
>>>>>>>>>      }
>>>>>>>>>      finally {
>>>>>>>>>        try { stmt.close(); } catch (Exception ignore) {}
>>>>>>>>>      }
>>>>>>>>>    }
>>>>>>>>>    finally {
>>>>>>>>>      try { conn.close(); } catch (Exception ignore) {}
>>>>>>>>>    }
>>>>>>>>>   }
>>>>>>>>> }
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>>
>>>>>>>>>  log4j:ERROR Could not instantiate class
>>>>>>>>> [org.apache.hadoop.log.metrics.EventCounter].
>>>>>>>>> java.lang.ClassNotFoundException:
>>>>>>>>> org.apache.hadoop.log.metrics.EventCounter
>>>>>>>>>         at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>>>>>>>>>         at java.security.AccessController.doPrivileged(Native
>>>>>>>>> Method)
>>>>>>>>>         at
>>>>>>>>> java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>>>>>>>>>         at
>>>>>>>>> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
>>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>>>>>>>>>         at java.lang.Class.forName0(Native Method)
>>>>>>>>>         at java.lang.Class.forName(Class.java:169)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.helpers.Loader.loadClass(Loader.java:198)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.helpers.OptionConverter.instantiateByClassName(OptionConverter.java:326)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.helpers.OptionConverter.instantiateByKey(OptionConverter.java:123)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:752)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:735)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:615)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:502)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:547)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:483)
>>>>>>>>>         at
>>>>>>>>> org.apache.log4j.LogManager.<clinit>(LogManager.java:127)
>>>>>>>>>         at org.apache.log4j.Logger.getLogger(Logger.java:104)
>>>>>>>>>         at
>>>>>>>>> org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
>>>>>>>>>         at
>>>>>>>>> org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
>>>>>>>>>         at
>>>>>>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>>>>>>>>         at
>>>>>>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>>>>>>>>         at
>>>>>>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>>>>>>>>         at
>>>>>>>>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>>>>>>>>         at
>>>>>>>>> org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
>>>>>>>>>         at
>>>>>>>>> org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
>>>>>>>>>         at
>>>>>>>>> org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
>>>>>>>>>         at
>>>>>>>>> org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
>>>>>>>>>         at
>>>>>>>>> org.apache.hive.service.AbstractService.<clinit>(AbstractService.java:34)
>>>>>>>>>         at
>>>>>>>>> org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:86)
>>>>>>>>>         at
>>>>>>>>> org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>>>>>>>>>         at
>>>>>>>>> java.sql.DriverManager.getConnection(DriverManager.java:582)
>>>>>>>>>         at
>>>>>>>>> java.sql.DriverManager.getConnection(DriverManager.java:185)
>>>>>>>>>         at Conn.main(Conn.java:16)
>>>>>>>>> log4j:ERROR Could not instantiate appender named "EventCounter".
>>>>>>>>> Exception in thread "main" java.lang.NoClassDefFoundError:
>>>>>>>>> org/apache/hadoop/conf/Configuration
>>>>>>>>>         at
>>>>>>>>> org.apache.hive.service.cli.thrift.EmbeddedThriftCLIService.<init>(EmbeddedThriftCLIService.java:32)
>>>>>>>>>         at
>>>>>>>>> org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:86)
>>>>>>>>>         at
>>>>>>>>> org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
>>>>>>>>>         at
>>>>>>>>> java.sql.DriverManager.getConnection(DriverManager.java:582)
>>>>>>>>>         at
>>>>>>>>> java.sql.DriverManager.getConnection(DriverManager.java:185)
>>>>>>>>>         at Conn.main(Conn.java:16)
>>>>>>>>> Caused by: java.lang.ClassNotFoundException:
>>>>>>>>> org.apache.hadoop.conf.Configuration
>>>>>>>>>         at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>>>>>>>>>         at java.security.AccessController.doPrivileged(Native
>>>>>>>>> Method)
>>>>>>>>>         at
>>>>>>>>> java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>>>>>>>>>         at
>>>>>>>>> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
>>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>>>>>>>>>         ... 6 more
>>>>>>>>>
>>>>>>>>> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>>
>>>>>>>>>  do you have an idea about what I am missing?
>>>>>>>>>
>>>>>>>>>  Thanks a lot in advance,
>>>>>>>>> Demian
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On 1 April 2013 18:08, Sanjay Subramanian <
>>>>>>>>> Sanjay.Subramanian@wizecommerce.com> wrote:
>>>>>>>>>
>>>>>>>>>>  Hi
>>>>>>>>>>
>>>>>>>>>>  First of if u r planning to run YARN on 4.2.0 then stay with
>>>>>>>>>> 4.1.2.
>>>>>>>>>>
>>>>>>>>>>  I installed 4.2.0 but had to roll back :-( Hit upon this error
>>>>>>>>>> https://issues.cloudera.org/browse/DISTRO-461. If u r not using
>>>>>>>>>> yarn then it will not affect u.
>>>>>>>>>>
>>>>>>>>>>  When u install Cloudera Manager, it installs Hive. But
>>>>>>>>>> Hive-server and hive-metastore you have to install your self. I have
>>>>>>>>>> installed CM on Centos and Ubuntu. Never had to copy around any hive jars.
>>>>>>>>>> Only jar to be copied is mysql.
>>>>>>>>>>
>>>>>>>>>>  I am assuming u have setup (
>>>>>>>>>> https://ccp.cloudera.com/display/CDH4DOC/Hive+Installation#HiveInstallation-ConfiguringHiveServer2)
>>>>>>>>>> all MYSQL related stuff in the hive-site.xml specially
>>>>>>>>>> hive.metastore.uris
>>>>>>>>>> javax.jdo.option.ConnectionURL
>>>>>>>>>> javax.jdo.option.ConnectionDriverName
>>>>>>>>>> javax.jdo.option.ConnectionUserName
>>>>>>>>>> javax.jdo.option.ConnectionPassword
>>>>>>>>>> datanucleus.autoCreateSchema
>>>>>>>>>> datanucleus.fixedDatastore
>>>>>>>>>>
>>>>>>>>>>  Does hive CLI start successfully ? U can see debug messages by
>>>>>>>>>> starting hive CLI this way
>>>>>>>>>> $HIVE_HOME/bin/hive -hiveconf hive.root.logger=INFO,console
>>>>>>>>>>
>>>>>>>>>>  In CLI Execute command "Show Tables"
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>  Check Mysql server machine
>>>>>>>>>> ---------------------------------------
>>>>>>>>>> If MySQL is on another Server that what Hive is installed .Then
>>>>>>>>>> on the MySQL box check the /etc/hosts
>>>>>>>>>>  <Ipaddress_mysql_server>  FQDV_mysql_server  alias_11
>>>>>>>>>> <Ipaddress_hive_box>  FQDV_hive_box  alias_22
>>>>>>>>>>
>>>>>>>>>>  In my.cnf
>>>>>>>>>> bind-address            = 0.0.0.0
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>  Check if some old PATH and env variables are pointing to
>>>>>>>>>> improper location.
>>>>>>>>>>
>>>>>>>>>>  Try an older version of mysql jar..I use 5.1.22
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>  Thanks
>>>>>>>>>>
>>>>>>>>>>  sanjay
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>   From: demian rosas <demianrh@gmail.com>
>>>>>>>>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>>>>>> Date: Monday, April 1, 2013 1:43 PM
>>>>>>>>>> To: "user@hive.apache.org" <user@hive.apache.org>
>>>>>>>>>> Subject: Problem when trying to connect to hive server using jdbc
>>>>>>>>>>
>>>>>>>>>>   Hi,
>>>>>>>>>>
>>>>>>>>>>  I am using hive from CDH4.2 in a fresh installation. I want to
>>>>>>>>>> set a mysql metastore.
>>>>>>>>>>
>>>>>>>>>>  When trying to connect to hive server using jdbc I am getting
>>>>>>>>>> this error:
>>>>>>>>>>
>>>>>>>>>>  Exception in thread "main" java.lang.ClassNotFoundException:
>>>>>>>>>> org.apache.hive.jdbc.HiveDriver
>>>>>>>>>>         at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>>>>>>>>>>         at java.security.AccessController.doPrivileged(Native
>>>>>>>>>> Method)
>>>>>>>>>>         at
>>>>>>>>>> java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>>>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>>>>>>>>>>         at
>>>>>>>>>> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
>>>>>>>>>>         at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>>>>>>>>>>         at java.lang.Class.forName0(Native Method)
>>>>>>>>>>         at java.lang.Class.forName(Class.java:169)
>>>>>>>>>>         at Conn.main(Conn.java:8)
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>  I have copied the jdbc hive jar (hive-jdbc-0.10.0-cdh4.2.0.jar)
>>>>>>>>>> into my CLASSPATH, as well as my mysql connector jar
>>>>>>>>>> (mysql-connector-java-5.1.24-bin.jar).
>>>>>>>>>>
>>>>>>>>>>  I would appreciate a lot if you could tell me what I am missing
>>>>>>>>>> here.
>>>>>>>>>>
>>>>>>>>>>  Thanks a lot,
>>>>>>>>>> Demian
>>>>>>>>>>
>>>>>>>>>> CONFIDENTIALITY NOTICE
>>>>>>>>>> ======================
>>>>>>>>>> This email message and any attachments are for the exclusive use
>>>>>>>>>> of the intended recipient(s) and may contain confidential and privileged
>>>>>>>>>> information. Any unauthorized review, use, disclosure or distribution is
>>>>>>>>>> prohibited. If you are not the intended recipient, please contact the
>>>>>>>>>> sender by reply email and destroy all copies of the original message along
>>>>>>>>>> with any attachments, from your computer system. If you are the intended
>>>>>>>>>> recipient, please be advised that the content of this message is subject to
>>>>>>>>>> access, review and disclosure by the sender's Email System Administrator.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> CONFIDENTIALITY NOTICE
>>>>>>>>> ======================
>>>>>>>>> This email message and any attachments are for the exclusive use
>>>>>>>>> of the intended recipient(s) and may contain confidential and privileged
>>>>>>>>> information. Any unauthorized review, use, disclosure or distribution is
>>>>>>>>> prohibited. If you are not the intended recipient, please contact the
>>>>>>>>> sender by reply email and destroy all copies of the original message along
>>>>>>>>> with any attachments, from your computer system. If you are the intended
>>>>>>>>> recipient, please be advised that the content of this message is subject to
>>>>>>>>> access, review and disclosure by the sender's Email System Administrator.
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> CONFIDENTIALITY NOTICE
>>>>>>> ======================
>>>>>>> This email message and any attachments are for the exclusive use of
>>>>>>> the intended recipient(s) and may contain confidential and privileged
>>>>>>> information. Any unauthorized review, use, disclosure or distribution is
>>>>>>> prohibited. If you are not the intended recipient, please contact the
>>>>>>> sender by reply email and destroy all copies of the original message along
>>>>>>> with any attachments, from your computer system. If you are the intended
>>>>>>> recipient, please be advised that the content of this message is subject to
>>>>>>> access, review and disclosure by the sender's Email System Administrator.
>>>>>>>
>>>>>>
>>>>>>
>>>>>> CONFIDENTIALITY NOTICE
>>>>>> ======================
>>>>>> This email message and any attachments are for the exclusive use of
>>>>>> the intended recipient(s) and may contain confidential and privileged
>>>>>> information. Any unauthorized review, use, disclosure or distribution is
>>>>>> prohibited. If you are not the intended recipient, please contact the
>>>>>> sender by reply email and destroy all copies of the original message along
>>>>>> with any attachments, from your computer system. If you are the intended
>>>>>> recipient, please be advised that the content of this message is subject to
>>>>>> access, review and disclosure by the sender's Email System Administrator.
>>>>>>
>>>>>
>>>>>
>>>>> CONFIDENTIALITY NOTICE
>>>>> ======================
>>>>> This email message and any attachments are for the exclusive use of
>>>>> the intended recipient(s) and may contain confidential and privileged
>>>>> information. Any unauthorized review, use, disclosure or distribution is
>>>>> prohibited. If you are not the intended recipient, please contact the
>>>>> sender by reply email and destroy all copies of the original message along
>>>>> with any attachments, from your computer system. If you are the intended
>>>>> recipient, please be advised that the content of this message is subject to
>>>>> access, review and disclosure by the sender's Email System Administrator.
>>>>>
>>>>
>>>>
>>>> CONFIDENTIALITY NOTICE
>>>> ======================
>>>> This email message and any attachments are for the exclusive use of the
>>>> intended recipient(s) and may contain confidential and privileged
>>>> information. Any unauthorized review, use, disclosure or distribution is
>>>> prohibited. If you are not the intended recipient, please contact the
>>>> sender by reply email and destroy all copies of the original message along
>>>> with any attachments, from your computer system. If you are the intended
>>>> recipient, please be advised that the content of this message is subject to
>>>> access, review and disclosure by the sender's Email System Administrator.
>>>>
>>>
>>>
>>> CONFIDENTIALITY NOTICE
>>> ======================
>>> This email message and any attachments are for the exclusive use of the
>>> intended recipient(s) and may contain confidential and privileged
>>> information. Any unauthorized review, use, disclosure or distribution is
>>> prohibited. If you are not the intended recipient, please contact the
>>> sender by reply email and destroy all copies of the original message along
>>> with any attachments, from your computer system. If you are the intended
>>> recipient, please be advised that the content of this message is subject to
>>> access, review and disclosure by the sender's Email System Administrator.
>>>
>>
>>
>> CONFIDENTIALITY NOTICE
>> ======================
>> This email message and any attachments are for the exclusive use of the
>> intended recipient(s) and may contain confidential and privileged
>> information. Any unauthorized review, use, disclosure or distribution is
>> prohibited. If you are not the intended recipient, please contact the
>> sender by reply email and destroy all copies of the original message along
>> with any attachments, from your computer system. If you are the intended
>> recipient, please be advised that the content of this message is subject to
>> access, review and disclosure by the sender's Email System Administrator.
>>
>
>
> CONFIDENTIALITY NOTICE
> ======================
> This email message and any attachments are for the exclusive use of the
> intended recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
> sender by reply email and destroy all copies of the original message along
> with any attachments, from your computer system. If you are the intended
> recipient, please be advised that the content of this message is subject to
> access, review and disclosure by the sender's Email System Administrator.
>

Mime
View raw message