Support Questions

Find answers, ask questions, and share your expertise

Hue 3.11 Hive Query editor - Not retrying thrift call GetSchemas due to socket timeout

avatar
Contributor

Hue 3.11 Hive Tez query editor database view refreshing manually times out (after 2 mins) while query is running. Also metastore manager does the same when Hive Tez session is running as well. The following warning were found right after the timeout of database view refresh. Once the query completes though refreshing the hive database/ metastore manager works just fine.

 

warning:

[Mon Nov 14 15:16:01 2016]  [14/Nov/2016 15:16:01 +0000] thrift_util  WARNING  Not retrying thrift call GetSchemas due to socket timeout
[Mon Nov 14 15:16:01 2016]  [14/Nov/2016 15:16:01 +0000] thrift_util  INFO     Thrift saw a socket error: timed out
[Mon Nov 14 15:16:01 2016]  [14/Nov/2016 15:16:01 +0000] api          WARNING  Autocomplete data fetching error: timed out (code THRIFTSOCKET): None

1 ACCEPTED SOLUTION

avatar
Rising Star

Have u tried this: hive.server2.parallel.ops.in.session=true

 

 

https://github.com/cloudera/hue/issues/515

 

Regards,

Andrey

View solution in original post

11 REPLIES 11

avatar
Contributor

Thank you @Markovich. I have been looking for this fix for months. I even opened multiple tickets with Hortonworks but they were not very helpful. Finally, I can put this to rest.

 

Just to add more clarity, for HDP clusters the hive.server2.parallel.ops.in.session=true propery has to be added to hive-site.xml (if done manually) or at Hive > Config > Advanced > "Custom hive-site" section if done via Ambari. 

 

 

avatar
Contributor

Hi Jay,

 

It will be on Hive > Config > Advanced > "Custom hive-site" , i have confrimed it works on my cluster.

 

I was in the same boat, thanks to @Markovich , it's fixed now.