Did you try removing the double quotes? IE: SELECT * FROM dremio.`demo`.`weather`
> On Feb 12, 2020, at 1:27 PM, David Du <[email protected]> wrote: > > Hi > 1. 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. > 2. 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. > 3. Started apache drill with ./drill-embedded command, then went to drill > web UI, created storage plugin: dremiodemo: > { > "type": "jdbc", > "driver": "com.dremio.jdbc.Driver", > "url": "jdbc:dremio:direct=localhost:41010;schema=Demo", > "username": "admin", > "password": "", > "caseInsensitiveTableNames": true, > "enabled": true > } > since apache drill is also using 31010, I changed the dremio jdbc port to > 41010 in the conf file. > 4. from drill started session, type show databases; > dremiodemo.demo is listed as one of the schema names, > then: > 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 * > > FROM "DREMIO"."Demo"."weather" > > plugin dremiodemo > > Fragment 0:0 > > 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. > > -- > ******************************************************** > DISCLAIMER: This > e-mail, including any attached files, > is confidential, may be legally > privileged, and is > solely for the intended recipient(s). If you received > > this e-mail in error, please destroy it and notify us > immediately by reply > e-mail. Any unauthorized > use, dissemination, disclosure, copying or > printing is > strictly prohibited. - BCMC, LLC
