It worked, thanks! On Mon, Feb 5, 2018 at 10:40 AM, Vova Vysotskyi <[email protected]> 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 <[email protected]>: > > > 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 >
