Default workspace and plug in

[Edmon Begoli <eb...@gmail.com>]

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?

Re: Default workspace and plug in

[Kristine Hahn <kh...@maprtech.com>]

Here's an example, Edmon, of what Jacques suggested. Create myplugin
<http://drill.apache.org/docs/storage-plugin-registration/>:

    {
>   "type": "file",
>   "enabled": true,
>   "connection": "file:///",
>   "workspaces": {
>     "ngram": {
>       "location": "/Users/khahn/ngrams",
>       "writable": false,
>       "defaultInputFormat": null
>     }
>   },
>   "formats": {
>     "tsv": {
>       "type": "text",
>       "extensions": [
>         "tsv"
>       ],
>       "delimiter": "\t"
>     }
>   }
>

Then, use this query specifying only the file name.


> USE myplugin.ngram;

SELECT COLUMNS[0],
>                 COLUMNS[1],
>                 COLUMNS[2]
>          FROM `/googlebooks-eng-all-5gram-20120701-zo.tsv`
>          WHERE ((columns[0] = 'Zoological Journal of the Linnean')
>           AND (columns[2] > 250))
>          LIMIT 10;


Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn skype:krishahn


On Fri, Aug 28, 2015 at 2:38 PM, Edmon Begoli <eb...@gmail.com> 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?
>

Re: Default workspace and plug in

[Jacques Nadeau <ja...@dremio.com>]

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 <eb...@gmail.com> 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?
>