Created on 11-14-2016 12:33 PM - edited 09-16-2022 03:47 AM
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
Created 05-11-2017 03:07 PM
Have u tried this: hive.server2.parallel.ops.in.session=true
https://github.com/cloudera/hue/issues/515
Regards,
Andrey
Created on 05-31-2017 06:09 PM - edited 05-31-2017 06:13 PM
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.
Created 06-01-2017 02:23 AM
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.