Thanks for your help!
I tested from DBeaver, it works, also my question is my query is:
select * from dremiodemo.demo.weather;
and the error message is:
SqlValidatorException: Table ‘DREMIO.Demo.weather’ not found,
Why Dremio looks for table “DREMIO.Demo.weather”?
I tried to configure the jdbc driver plugin:
“url”: “jdbc:dremio:direct=localhost:41010" without schema=Demo
but the error is the same. Dremio always added the “DREMIO” keyword into the query.