Configuring Workspace for Different Directory in Apache Drill

blogger.com

Configuring Workspace for Different Directory in Apache Drill





If you want to set different directory (e.g:- D:/) for Files (eg:- csv, json, tsv, psv, etc) in apache drill, we need to just configure inside dfs storage plugin.

EXAMPLE:-
  


 "tmp": {
      "location": "F:/DrillFiles",
      "writable": true,
      "defaultInputFormat": null
    }

Here
 In Given example just specify directory name inside location
And
While writing query just mention the tmp name in query.

EXAMPLE:-    select * from dfs.tmp.`demo.csv`; 

And After that no need to specify path in query again and again.


Visitor