I am trying to execute the query from hive view but the query is failing with following Exception

[#1]

{"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)

[#2 · Accepted solution]

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.

[#3]

You can try what @Rajkumar Singh 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.