https://community.cloudera.com/t5/Archives-of-Support-Questions/I-am-trying-to-execute-the-query-from-hive-view-but-the/m-p/104260#M46323 <P>{"trace":"org.apache.ambari.view.hive.client.HiveClientException: H160 Unable to fetch results: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out\n\norg.apache.ambari.view.hive.client.HiveClientException: H160 Unable to fetch results: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out\n\tat org.apache.ambari.view.hive.client.Cursor$1.body(Cursor.java:77)\n\tat org.apache.ambari.view.hive.client.Cursor$1.body(Cursor.java:63)\n\tat org.apache.ambari.view.hive.client.HiveCall.call(HiveCall.java:101)\n\tat org.apache.ambari.view.hive.client.Cursor.fetchNextBlock(Cursor.java:63)\n\tat org.apache.ambari.view.hive.client.Cursor.fetchIfNeeded(Cursor.java:169)\n\tat org.apache.ambari.view.hive.client.Cursor.hasNext(Cursor.java:162)\n\tat org.apache.ambari.view.hive.client.Cursor.readRaw(Cursor.java:224)\n\tat org.apache.ambari.view.hive.resources.jobs.ResultsPaginationController.request(ResultsPaginationController.java:131)\n\tat org.apache.ambari.view.hive.resources.jobs.JobService.getResults(JobService.java:305)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:497)\n\tat com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)\n\tat com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)\n\tat com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)\n\tat com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)\n\tat com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)\n\tat com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)</P> Tue, 15 Nov 2016 23:35:55 GMT sanjeev_verma82 2016-11-15T23:35:55Z https://community.cloudera.com/t5/Archives-of-Support-Questions/I-am-trying-to-execute-the-query-from-hive-view-but-the/m-p/104260#M46323 <P>{"trace":"org.apache.ambari.view.hive.client.HiveClientException: H160 Unable to fetch results: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out\n\norg.apache.ambari.view.hive.client.HiveClientException: H160 Unable to fetch results: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out\n\tat org.apache.ambari.view.hive.client.Cursor$1.body(Cursor.java:77)\n\tat org.apache.ambari.view.hive.client.Cursor$1.body(Cursor.java:63)\n\tat org.apache.ambari.view.hive.client.HiveCall.call(HiveCall.java:101)\n\tat org.apache.ambari.view.hive.client.Cursor.fetchNextBlock(Cursor.java:63)\n\tat org.apache.ambari.view.hive.client.Cursor.fetchIfNeeded(Cursor.java:169)\n\tat org.apache.ambari.view.hive.client.Cursor.hasNext(Cursor.java:162)\n\tat org.apache.ambari.view.hive.client.Cursor.readRaw(Cursor.java:224)\n\tat org.apache.ambari.view.hive.resources.jobs.ResultsPaginationController.request(ResultsPaginationController.java:131)\n\tat org.apache.ambari.view.hive.resources.jobs.JobService.getResults(JobService.java:305)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:497)\n\tat com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)\n\tat com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)\n\tat com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)\n\tat com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)\n\tat com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)\n\tat com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)</P> Tue, 15 Nov 2016 23:35:55 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/I-am-trying-to-execute-the-query-from-hive-view-but-the/m-p/104260#M46323 sanjeev_verma82 2016-11-15T23:35:55Z https://community.cloudera.com/t5/Archives-of-Support-Questions/I-am-trying-to-execute-the-query-from-hive-view-but-the/m-p/104261#M46324 <P>can you try this query using http mode by setting hive.server2.transport.mode to http instead of binary. do not forget to restart HS2.</P> Tue, 15 Nov 2016 23:37:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/I-am-trying-to-execute-the-query-from-hive-view-but-the/m-p/104261#M46324 rajkumar_singh 2016-11-15T23:37:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/I-am-trying-to-execute-the-query-from-hive-view-but-the/m-p/104262#M46325 <P>You can try what @<A href="https://community.hortonworks.com/users/8919/rajkumarsingh.html">Rajkumar Singh</A> has recommended. At times, the error is also temporary in nature, so trying to login again to ambari might help, unless you have already tried that.</P><P></P> Tue, 15 Nov 2016 23:43:30 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/I-am-trying-to-execute-the-query-from-hive-view-but-the/m-p/104262#M46325 srai1 2016-11-15T23:43:30Z