CODEWITHSUNDEEP
hadoophivehue
user3887215
user3887215

Reputation: 31

HUE Query Results - Expired

Team,

I am using HUE-BEEWAX (Hive UI) to execute hive queries. So far, I have been always able to access the query results of queries execute on the same day, but today I see lot of the queries results shown as expired despite running them just an hour back.

my question is?

  1. When does query result set become expired?
  2. What settings control this?
  3. Is it possible to retain this result-set somewhere in HDFS? (how?)

Regards

Upvotes: 2

Views: 5920

Answers (1)

brandon.bell
brandon.bell

Reputation: 1411

  1. My understanding is that it's controlled by Hive, not Hue (Beeswax). When HiveServer is restarted it cleans up the scratch directories.
  2. This is controlled by this setting : hive.start.cleanup.scratchdir.

Are you restarting your HiveServers?

Looking through some code, I found that Beeswax sets the scratch directory to "/tmp/hive-beeswax-" + Hadoop Username.

Upvotes: 2

Related Questions