show *schemas*; +-------------------------------------------+
| * SCHEMA_NAME * | +-------------------------------------------+ | cp.default | | dfs.default | | dfs.root | | dfs.tmp | | dremiodemo.$scratch | | dremiodemo.@admin | | dremiodemo.demo | | dremiodemo.dremio dremiodemo.information_schema | | dremiodemo.samples | | dremiodemo.samples.samples.dremio.com | | dremiodemo.sys | | dremiodemo.sys.cache | | dremiodemo.testspace | | dremiodemo | | information_schema | | sys *use* dremiodemo.demo; +------+---------------------------------------------+ | * ok * | * summary * | +------+---------------------------------------------+ | true | Default schema changed to [dremiodemo.demo] | +------+---------------------------------------------+ 1 row selected (0.109 seconds) apache drill (dremiodemo.demo)> show *tables*; +-----------------+------------+ | * TABLE_SCHEMA * | *TABLE_NAME* | +-----------------+------------+ | dremiodemo.demo | topips | | dremiodemo.demo | weather | +-----------------+------------+ 2 rows selected (0.229 seconds) apache drill (dremiodemo.demo)> *describe* weather; +-------------+-------------------+-------------+ | *COLUMN_NAME* | * DATA_TYPE * | *IS_NULLABLE* | +-------------+-------------------+-------------+ | A | CHARACTER VARYING | YES | | B | CHARACTER VARYING | YES | | C | CHARACTER VARYING | YES | | D | CHARACTER VARYING | YES | | E | CHARACTER VARYING | YES | | F | CHARACTER VARYING | YES | | G | CHARACTER VARYING | YES | | H | CHARACTER VARYING | YES | | I | CHARACTER VARYING | YES | | J | CHARACTER VARYING | YES | | K | CHARACTER VARYING | YES | | L | CHARACTER VARYING | YES | +-------------+-------------------+-------------+ 12 rows selected (0.601 seconds) apache drill (dremiodemo.demo)> *select* * *from* weather; 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 On Wed, Feb 12, 2020 at 1:35 PM Jaimes, Rafael <[email protected]> wrote: > 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 <[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 > > -- ******************************************************** 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
