Enable Data Explorer UI caching by setting a timeout value in
milliseconds. The default is 10 days or 864000000 milliseconds. Set the timeout to 0 to disable
caching.
When you browse tables using the left assist panel or run queries, Data Explorer caches this information for fetching information faster and
query autocompletion. You can configure the time for which
you want to Data Explorer to cache this information by setting the
value of the cacheable_ttl property under the
[desktop][[custom]] section in the
hue_safety_valve configuration property in Cloudera Data Warehouse.
-
-
Log in to the Cloudera Data Warehouse service as an administrator.
-
Go to the and select hue-safety-valve from the
Configuration files dropdown menu.
-
Add the following parameters with the cache timeout value to the
hue_safety_valve configuration parameter:
[desktop]
[[custom]]
cacheable_ttl=[***VALUE-IN-MILLISECONDS***]
For example, the following configuration sets the cache timeout to the default value of
86400000 milliseconds:
[desktop]
[[custom]]
cacheable_ttl=86400000
-
Click APPLY.
-
Restart the Virtual Warehouse.
> Edit > CONFIGURATIONS > Data Explorer (Hue) and select hue-safety-valve from the
Configuration files dropdown menu.
