Step 6: Configure Workspaces
You must configure a workspace on one Drill node in each Drill cluster that points to the volume directory where data is stored. When you create a workspace, you must include the volume mount point.
For example, if you created a volume with the mount point
/operational
for
the OJAI Distributed Query Service cluster and stored your data in
/data/here/
within that volume, you would configure the workspace, as
shown: {
"type": "file",
"enabled": true,
"connection": "file:///",
"workspaces": {
"root": {
"location": "/",
"writable": false,
"defaultInputFormat": null
},
"tmp": {
"location": "/tmp",
"writable": true,
"defaultInputFormat": null
},
"operational": {
"location": "/operational/data/here",
"writable": true,
"defaultInputFormat": null
}
}
Likewise, if you also created a volume with a mount point
/analytical
for
the other Drill cluster that runs analytical queries and stored your data in
/data/here/
within that volume, you would configure the workspace, as
shown:{
"type": "file",
"enabled": true,
"connection": "file:///",
"workspaces": {
"root": {
"location": "/",
"writable": false,
"defaultInputFormat": null
},
"tmp": {
"location": "/tmp",
"writable": true,
"defaultInputFormat": null
},
"analytical": {
"location": "/analytical/data/here",
"writable": true,
"defaultInputFormat": null
}
}
You can define a workspace in the Drill dfs storage plugin configuration on the Storage page
in the Drill Web UI at https://<drill-node-ip-address>:8047
. You only need
to configure the workspace on one Drill node in each Drill cluster.
See Plugin Configuration Basics and Workspaces for more information.