- I installed the 4.1.4 community version of dremio, and from its web UI, created Demo workspace, then used the samples csv file Samples.“samples.dremio.com”.“SF weather 2018-2019.csv” and saved as weather into the Demo workspace, so when clicked on Demo workspace, on the right side panel the weather name showed up, the copied path is Demo.weather.
- I installed the apache-drill-1.17.0 and dropped the jdbc file: dremio-jdbc-driver-4.1.4-202001240912140359-a90eb503.jar into the jars/3rdparty folder and jdbc-driver folder.
- Started apache drill with ./drill-embedded command, then went to drill web UI, created storage plugin: dremiodemo:
since apache drill is also using 31010, I changed the dremio jdbc port to 41010 in the conf file.
- from drill started session, type show databases;
dremiodemo.demo is listed as one of the schema names,
type select * from dremiodemo.demo.weather;
I got error: Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.
sql SELECT *
in the Dremio server.log file, it showed erro:
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Table ‘DREMIO.Demo.weather’ not found
Any clues? thanks for help.