Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

why "[Cloudera][Hardy] (22) Error from ThriftHiveClient: ETIMEDOUT" for hiveserver1?

why "[Cloudera][Hardy] (22) Error from ThriftHiveClient: ETIMEDOUT" for hiveserver1?

Explorer

hi,

 

for small data, everything seems OK,

but for big data, errors with MS cube building project below:

 

Error	12	OLE DB error: OLE DB or ODBC error: Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "CDH_DEV_BJ_DW_LS".; 42000; OLE DB provider "MSDASQL" for linked server "CDH_DEV_BJ_DW_LS" returned message "[Cloudera][Hardy] (22) Error from ThriftHiveClient: ETIMEDOUT".; 01000.		0	0	

 and maybe some relative exceptions in /tmp/hlhadoop/hive.log

2013-11-05 19:52:22,941 WARN  conf.HiveConf (HiveConf.java:initialize(1046)) - 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.
2013-11-05 19:52:24,045 WARN  conf.HiveConf (HiveConf.java:initialize(1046)) - 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.
2013-11-05 19:52:25,130 ERROR service.HiveServer (HiveServer.java:readResults(392)) - File /var/tmp/hive/hlhadoop/hlhadoop_201311051952843805228674194707.pipeout not found.
java.io.FileNotFoundException: /var/tmp/hive/hlhadoop/hlhadoop_201311051952843805228674194707.pipeout (No such file or directory)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:120)
        at java.io.FileReader.<init>(FileReader.java:55)
        at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.readResults(HiveServer.java:390)
        at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.fetchN(HiveServer.java:442)
        at org.apache.hadoop.hive.service.ThriftHive$Processor$fetchN.getResult(ThriftHive.java:692)
        at org.apache.hadoop.hive.service.ThriftHive$Processor$fetchN.getResult(ThriftHive.java:676)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
2013-11-05 20:01:50,203 WARN  conf.HiveConf (HiveConf.java:initialize(1046)) - 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.
2013-11-05 20:01:51,324 WARN  conf.HiveConf (HiveConf.java:initialize(1046)) - 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.
2013-11-05 20:01:52,381 ERROR service.HiveServer (HiveServer.java:readResults(392)) - File /var/tmp/hive/hlhadoop/hlhadoop_2013110520017186427358944534633.pipeout not found.
java.io.FileNotFoundException: /var/tmp/hive/hlhadoop/hlhadoop_2013110520017186427358944534633.pipeout (No such file or directory)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:120)
        at java.io.FileReader.<init>(FileReader.java:55)
        at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.readResults(HiveServer.java:390)
        at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.fetchN(HiveServer.java:442)
        at org.apache.hadoop.hive.service.ThriftHive$Processor$fetchN.getResult(ThriftHive.java:692)
        at org.apache.hadoop.hive.service.ThriftHive$Processor$fetchN.getResult(ThriftHive.java:676)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
2013-11-05 20:05:11,168 WARN  conf.HiveConf (HiveConf.java:initialize(1046)) - 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.
2013-11-05 20:05:12,294 WARN  conf.HiveConf (HiveConf.java:initialize(1046)) - 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.

 

any clues?

 

 

CDH4.2.1 on Red Hat Enterprise Linux Server release 6.4