Step 7: Register a Drill Cluster as an OJAI Distributed Query Service
You can select any of the configured Drill clusters to act as the OJAI Distributed
Query Service provider for operational queries, by running the queryservice
setconfig
command.
When you register the Drill cluster as the OJAI Distributed Query Service, adjust the memory setting on each node. The default Drill memory setting of 13 GB is unnecessarily high for the OJAI Distributed Query Service, which only requires ~ 5 GB. You must restart the Drillbits after you update the memory settings.
Registering a Drill Cluster as the OJAI Distributed Query Service
maprcli cluster queryservice setconfig -enabled true -clusterid <name_of_cluster> -storageplugin dfs -znode <zk_setting>
maprcli cluster queryservice setconfig -enabled true -clusterid drillbits2 -storageplugin dfs -znode drill2
See queryservice setconfig for more information about the command.
Configuring Memory for the OJAI Distributed Query Service
Modify the memory settings on each node in the OJAI Distributed Query Service cluster and then restart Drill. See Configuring Drill Memory for instructions.