You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Flavio Pompermaier <po...@okkam.it> on 2018/02/05 09:11:23 UTC
Invalid storage plugin name
Hi to all,
I'm trying to play around with storage plugins (on Drill 1.12) and I
discovered that while I can successfully create a storage plugin containing
a minusc character ('-') then I can't query against it (Error: PARSE ERROR:
Encountered "-" at line 1, column XX).
For example, I can create a MYSQL storage plugin mysql-test, but then I
can't do
SELECT * from mysql-test.mydb.mytable (because if the aforementioned parse
error).
I've tried the following queries as well but none of them works:
SELECT * from 'mysql-test'.mydb.mytable
SELECT * from "mysql-test".mydb.mytable
Best,
Flavio
Re: Invalid storage plugin name
Posted by Flavio Pompermaier <po...@okkam.it>.
It worked, thanks!
On Mon, Feb 5, 2018 at 10:40 AM, Vova Vysotskyi <vv...@gmail.com> wrote:
> Hi Flavio,
>
> Default identifier quotes[1] should be used to avoid this error:
> SELECT * from `mysql-test`.mydb.mytable
>
> Also, you may configure the type of identifier quotes as described in[1].
>
> [1] https://drill.apache.org/docs/lexical-structure/#identifier-quotes
>
> 2018-02-05 11:11 GMT+02:00 Flavio Pompermaier <po...@okkam.it>:
>
> > Hi to all,
> > I'm trying to play around with storage plugins (on Drill 1.12) and I
> > discovered that while I can successfully create a storage plugin
> containing
> > a minusc character ('-') then I can't query against it (Error: PARSE
> ERROR:
> > Encountered "-" at line 1, column XX).
> >
> > For example, I can create a MYSQL storage plugin mysql-test, but then I
> > can't do
> > SELECT * from mysql-test.mydb.mytable (because if the aforementioned
> parse
> > error).
> >
> > I've tried the following queries as well but none of them works:
> > SELECT * from 'mysql-test'.mydb.mytable
> > SELECT * from "mysql-test".mydb.mytable
> >
> > Best,
> > Flavio
> >
>
>
>
> --
> Kind regards,
> Volodymyr Vysotskyi
>
Re: Invalid storage plugin name
Posted by Vova Vysotskyi <vv...@gmail.com>.
Hi Flavio,
Default identifier quotes[1] should be used to avoid this error:
SELECT * from `mysql-test`.mydb.mytable
Also, you may configure the type of identifier quotes as described in[1].
[1] https://drill.apache.org/docs/lexical-structure/#identifier-quotes
2018-02-05 11:11 GMT+02:00 Flavio Pompermaier <po...@okkam.it>:
> Hi to all,
> I'm trying to play around with storage plugins (on Drill 1.12) and I
> discovered that while I can successfully create a storage plugin containing
> a minusc character ('-') then I can't query against it (Error: PARSE ERROR:
> Encountered "-" at line 1, column XX).
>
> For example, I can create a MYSQL storage plugin mysql-test, but then I
> can't do
> SELECT * from mysql-test.mydb.mytable (because if the aforementioned parse
> error).
>
> I've tried the following queries as well but none of them works:
> SELECT * from 'mysql-test'.mydb.mytable
> SELECT * from "mysql-test".mydb.mytable
>
> Best,
> Flavio
>
--
Kind regards,
Volodymyr Vysotskyi