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 <pomperma...@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
