My Oracle Support Banner

Frequently Asked Questions for Controlling the Hive Query Results History in Hue / Beeswax (Doc ID 1539495.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Big Data Appliance Integrated Software - Version 2.0.1 and later
Linux x86-64

Purpose

This document provides answers to frequently asked questions regarding the control of the hive query results history in Hue / Beeswax on Oracle Big Data Appliance (BDA).

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Q1. Where are the Hue/Beeswax hive queries, session logs and result set stored?
 Q2. Why some of the files under /tmp/hive-beeswax-<HDFS_USERNAME>  folder on HDFS are so big?  For example, some files is 3.6G in size
 Q3. Can the sub-folders or files under /tmp/hive-beeswax-<HDFS_USERNAME> folders be deleted? Is it possible to automate this clean up process?
 Q4.  Where is the retention period for result set expiration defined and how can we change the default setting?
 Q5. How to link the queries in beeswax_queryhistory to the result set displayed in Hue's history tab in order to selectively remove files to release space?
 Q6. Why restarting the Hue/Beeswax server expires all existing queries irrespective of their age?
 Q7. How long does the queries show up in Hue's history in Hue GUI?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.