Cloudera Data Warehouse allows you to deploy a
shared Data Explorer service at an environment level. Learn
about the advantages and limitations of deploying a shared Data Explorer service and some FAQs that can help you understand more about the
feature.
Advantages of deploying a shared Data Explorer
service
By deploying a shared Data Explorer service,
you can manage costs by keeping only those Virtual Warehouses running that your
users need at that time. Data analysts only need to know or bookmark one Data Explorer instance URL and can run queries on any
Virtual Warehouses available to them.
Each shared Data Explorer service instance has
its own database where queries and query history are saved. Moreover, the shared Hue
service remains active as long as the environment is active.
Limitations
When you use the Importer to create tables from files in Data Explorer, by default, Data Explorer creates a Hive table if Hive is available
and uses the first Hive Virtual Warehouse that was created. You cannot select a
Virtual Warehouse using which you want to create a table by importing a file. To
create an Impala table using the Importer, you must first select the editor type as
Impala and then click + on the Table
Browser.
