cgivre commented on issue #2623:
URL: https://github.com/apache/drill/issues/2623#issuecomment-1214558608

   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?
   
   


-- 
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

Reply via email to