My command is:
*select* * *from* dremiodemo.demo.weather;
there is no quotes, but for some reason, the error message returned with
quotes
Thanks for your help!
On Wed, Feb 12, 2020 at 1:32 PM Charles Givre <cgi...@gmail.com> 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
>
>
--
********************************************************
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
