yaozhu commented on issue #2623:
URL: https://github.com/apache/drill/issues/2623#issuecomment-1274179042
Hi Charles :
I have create table xxx in mysql client terminal directly and
just run sql on drill client。
The same sql run in mysql client 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.
thanks for reply
At 2022-08-15 10:54:52, "Charles S. Givre" ***@***.***> wrote:
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?
—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
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
