Like Charles recommended, try backticks. Also:
From the Drill shell what is the output of 'show schemas;' ? After 'use <schema>', what is the output of 'show tables;' ? On 2/12/20 1:32 PM, Charles Givre wrote:
Did you try removing the double quotes? IE: SELECT * FROM dremio.`demo`.`weather`On Feb 12, 2020, at 1:27 PM, David Du <d...@bcmcgroup.com> 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
smime.p7s
Description: S/MIME Cryptographic Signature