Results have expired, rerun the query if needed

#1

When I use hue to connect to hiveserver2 for query, I often have: Results have expired, rerun the query if needed, how do I solve this problem?

Unable to see Hive/Mysql query results in Hue after page refresh
#2

https://docs.gethue.com/administrator/administration/reference/#hive-and-impala-queries-life-cycle is about this

#3

how do I solve this problem?
This problem does not occur every time, what parameters should I set to make this problem no longer appear?

#4

Only one result is kept at the time, for just a few minutes. After https://issues.cloudera.org/browse/HUE-8787, all the results will be available for a configurable time.

Currently, you will need to rerun the query.

Note: if you use a load balancer for multiple HivesServer, you also need sticky sessions https://gethue.com/how-to-optimally-configure-your-analytic-database-for-high-availability-with-hue-and-other-sql-clients/

#5

Thanks for your reply, it is my own problem. I randomly generate connections in dbms.py. When the django cache expires, the next connection is inconsistent with the last connection, causing the get_status () method to time out.

1 Like
#6

I got the same problem. How did you solve the problem ?