yaozhu commented on issue #2623: URL: https://github.com/apache/drill/issues/2623#issuecomment-1221665356
> This looks like an invalid query. Unless you ran this and selected a default schema first, it is necessary to specify what storage plugin you are creating a table in. IE: > > ``` > CREATE TABLE mysql.ORDERS ( O_ORDERKEY INTEGER NOT NULL, > O_CUSTKEY INTEGER NOT NULL, > O_ORDERSTATUS CHAR(1) NOT NULL, > .... > ``` > > Note that this query spells out `mysql.ORDERS` rather than just `ORDERS`. > > Lastly, what version of Drill are you using? I have create table xxx in mysql client terminal directly and just run sql on drill client。 The same sql run in mysql client and got a correct result set ，but drill not。 It bother me long time, i was try to read source code to find out way to fix it, but i was failure, and you can use newest version to reproduct issue. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
