If you are using sqlline to connect to Drill, you could also include the workspace in the launch script.
Example: bin/sqlline -u jdbc:drill:schema="dfs.tmp";zk=<IP address>:5181 (distributed mode) bin/sqlline -u jdbc:drill:schema="dfs.tmp";zk=local (embedded mode) -Abhishek On Fri, Aug 28, 2015 at 2:43 PM, Jacques Nadeau <[email protected]> wrote: > use dfs.myworkspace; > > or similar should work for you > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Fri, Aug 28, 2015 at 2:38 PM, Edmon Begoli <[email protected]> wrote: > > > Is it possible to set the default workspace and format, so when I am > > running queries in drill > > I can just say: > > > > select columns[1], ..n from `<file>`; > > > > or if there is a sub-dir: > > > > select columns[1], ..n from `\<subdir>\<file>`; > > > > without having to specify workspace? > > >
