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 in Data Explorer to
create tables from files, Data Explorer
creates a Hive table by default (if Hive is available) and uses the first available
Hive Virtual Warehouse. You cannot select a specific Virtual Warehouse during file
import. To create an Impala table using the Importer, you must first select the
editor type as Impala, and then click + on the
Table Browser.
