Anybody has any ideas about this issue?

Thanks

On Thu, Feb 13, 2020 at 10:05 AM David Du <d...@bcmcgroup.com> wrote:

> I used this command:
>
> *select* * *from* dremiodemo.demo.weather;
>
>
> since dremiodemo.demo  is the schema name listed from show
> databases command.
>
>
> But why the drill generated a different query as?:
>
> sql SELECT *
>
> FROM "DREMIO"."Demo"."weather"
>
> plugin dremiodemo
>
>
> Why "DREMIO" is added instead of "dremiodemo"?
>
>
> Thanks
>
>
>
>
>
>
> On Thu, Feb 13, 2020 at 9:30 AM David Du <d...@bcmcgroup.com> wrote:
>
>> Thanks for your help, my command is:
>>
>> apache drill> *select* * *from* dremiodemo.demo.weather;
>>
>>
>> this gave me error from console:
>>
>> 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
>>
>>
>> [Error Id: dd01f1ff-c7c8-4f36-996f-5f4ed3839c43 on 172.24.30.68:31010]
>> (state=,code=0)
>>
>>
>>
>>
>> But the log file is:
>>
>>
>>
>> tail -f sqlline.log
>>
>> 2020-02-13 09:23:48,780 [main] WARN  o.a.drill.exec.metrics.DrillMetrics
>> - Removing old metric since name matched newly registered metric. Metric
>> name: drill.allocator.root.used
>>
>> 2020-02-13 09:23:48,780 [main] WARN  o.a.drill.exec.metrics.DrillMetrics
>> - Removing old metric since name matched newly registered metric. Metric
>> name: drill.allocator.root.peak
>>
>> 2020-02-13 09:23:48,913 [main] INFO  o.a.drill.exec.client.DrillClient -
>> Foreman drillbit is 172.24.30.68
>>
>> 2020-02-13 09:23:48,913 [main] INFO  o.a.drill.exec.client.DrillClient -
>> Successfully connected to server 172.24.30.68:31010
>>
>> 2020-02-13 09:24:02,371 [21baa3fc-c178-4227-5d3d-00bf55c59097:foreman]
>> INFO  o.a.drill.exec.work.foreman.Foreman - Query text for query with id
>> 21baa3fc-c178-4227-5d3d-00bf55c59097 issued by anonymous: show databases
>>
>> 2020-02-13 09:24:04,145 [21baa3fc-c178-4227-5d3d-00bf55c59097:frag:0:0]
>> INFO  o.a.d.e.w.fragment.FragmentExecutor -
>> 21baa3fc-c178-4227-5d3d-00bf55c59097:0:0: State change requested
>> AWAITING_ALLOCATION --> RUNNING
>>
>> 2020-02-13 09:24:04,156 [21baa3fc-c178-4227-5d3d-00bf55c59097:frag:0:0]
>> INFO  o.a.d.e.w.f.FragmentStatusReporter -
>> 21baa3fc-c178-4227-5d3d-00bf55c59097:0:0: State to report: RUNNING
>>
>> 2020-02-13 09:24:04,401 [21baa3fc-c178-4227-5d3d-00bf55c59097:frag:0:0]
>> INFO  o.a.d.e.c.ClassCompilerSelector - Java compiler policy: DEFAULT,
>> Debug option: true
>>
>> 2020-02-13 09:24:04,571 [21baa3fc-c178-4227-5d3d-00bf55c59097:frag:0:0]
>> INFO  o.a.d.e.w.fragment.FragmentExecutor -
>> 21baa3fc-c178-4227-5d3d-00bf55c59097:0:0: State change requested RUNNING
>> --> FINISHED
>>
>> 2020-02-13 09:24:04,573 [21baa3fc-c178-4227-5d3d-00bf55c59097:frag:0:0]
>> INFO  o.a.d.e.w.f.FragmentStatusReporter -
>> 21baa3fc-c178-4227-5d3d-00bf55c59097:0:0: State to report: FINISHED
>>
>> 2020-02-13 09:26:39,805 [21baa35f-ef83-15fe-f40b-8ff0415620f2:foreman]
>> INFO  o.a.drill.exec.work.foreman.Foreman - Query text for query with id
>> 21baa35f-ef83-15fe-f40b-8ff0415620f2 issued by anonymous: select * from
>> dremiodemo.demo.weather
>>
>> 2020-02-13 09:26:40,308 [21baa35f-ef83-15fe-f40b-8ff0415620f2:frag:0:0]
>> INFO  o.a.d.e.w.fragment.FragmentExecutor -
>> 21baa35f-ef83-15fe-f40b-8ff0415620f2:0:0: State change requested
>> AWAITING_ALLOCATION --> RUNNING
>>
>> 2020-02-13 09:26:40,308 [21baa35f-ef83-15fe-f40b-8ff0415620f2:frag:0:0]
>> INFO  o.a.d.e.w.f.FragmentStatusReporter -
>> 21baa35f-ef83-15fe-f40b-8ff0415620f2:0:0: State to report: RUNNING
>>
>> 2020-02-13 09:26:40,472 [21baa35f-ef83-15fe-f40b-8ff0415620f2:frag:0:0]
>> INFO  o.a.d.e.store.jdbc.JdbcRecordReader - User Error Occurred: The JDBC
>> storage plugin failed while trying setup the SQL query.  (VALIDATION ERROR:
>> Table 'DREMIO.Demo.weather' not found
>>
>>
>> SQL Query SELECT *
>>
>> FROM "DREMIO"."Demo"."weather"
>>
>> startLine 2
>>
>> startColumn 6
>>
>> endLine 2
>>
>> endColumn 13
>>
>>
>> [Error Id: b7ae16cc-80dc-4950-b7e1-7ccbd9cad7e8 on
>> 1672851h-t2349.noblis.org:41010]
>>
>>
>>   (org.apache.calcite.runtime.CalciteContextException) From line 2,
>> column 6 to line 2, column 13: Table 'DREMIO.Demo.weather' not found
>>
>>     sun.reflect.GeneratedConstructorAccessor149.newInstance():-1
>>
>>     sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
>>
>>     java.lang.reflect.Constructor.newInstance():423
>>
>>     org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
>>
>>     org.apache.calcite.sql.SqlUtil.newContextException():803
>>
>>     org.apache.calcite.sql.SqlUtil.newContextException():788
>>
>>
>> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470
>>
>>     org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104
>>
>>     org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
>>
>>     org.apache.calcite.sql.validate.AbstractNamespace.validate():84
>>
>>
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
>>
>>     org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
>>
>>     org.apache.calcite.sql.validate.AbstractNamespace.validate():84
>>
>>
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
>>
>>     org.apache.calcite.sql.SqlSelect.validate():226
>>
>>
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
>>
>>     com.dremio.exec.planner.sql.SqlConverter.validate():229
>>
>>
>> com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():184
>>
>>
>> com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():173
>>
>>
>> com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():169
>>
>>     com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
>>
>>     com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():70
>>
>>     com.dremio.exec.work.foreman.AttemptManager.plan():415
>>
>>     com.dremio.exec.work.foreman.AttemptManager.lambda$run$0():324
>>
>>     com.dremio.service.commandpool.CommandWrapper.run():62
>>
>>     java.util.concurrent.ThreadPoolExecutor.runWorker():1149
>>
>>     java.util.concurrent.ThreadPoolExecutor$Worker.run():624
>>
>>     java.lang.Thread.run():748
>>
>>   Caused By (org.apache.calcite.sql.validate.SqlValidatorException) Table
>> 'DREMIO.Demo.weather' not found
>>
>>     sun.reflect.GeneratedConstructorAccessor148.newInstance():-1
>>
>>     sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45
>>
>>     java.lang.reflect.Constructor.newInstance():423
>>
>>     org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463
>>
>>     org.apache.calcite.runtime.Resources$ExInst.ex():572
>>
>>     org.apache.calcite.sql.SqlUtil.newContextException():803
>>
>>     org.apache.calcite.sql.SqlUtil.newContextException():788
>>
>>
>> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470
>>
>>     org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104
>>
>>     org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
>>
>>     org.apache.calcite.sql.validate.AbstractNamespace.validate():84
>>
>>
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
>>
>>     org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
>>
>>     org.apache.calcite.sql.validate.AbstractNamespace.validate():84
>>
>>
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
>>
>>     org.apache.calcite.sql.SqlSelect.validate():226
>>
>>
>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
>>
>>     org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
>>
>>     com.dremio.exec.planner.sql.SqlConverter.validate():229
>>
>>
>> com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():184
>>
>>
>> com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():173
>>
>>
>> com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():169
>>
>>     com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
>>
>>     com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():70
>>
>>     com.dremio.exec.work.foreman.AttemptManager.plan():415
>>
>>     com.dremio.exec.work.foreman.AttemptManager.lambda$run$0():324
>>
>>     com.dremio.service.commandpool.CommandWrapper.run():62
>>
>>     java.util.concurrent.ThreadPoolExecutor.runWorker():1149
>>
>>     java.util.concurrent.ThreadPoolExecutor$Worker.run():624
>>
>>     java.lang.Thread.run():748
>>
>> On Thu, Feb 13, 2020 at 12:16 AM Paul Rogers <par0...@yahoo.com.invalid>
>> wrote:
>>
>>> The next step would be to take a look at the log file. Anything
>>> interesting there? Maybe an error or a stack trace?
>>>
>>> Thanks,
>>> - Paul
>>>
>>>
>>>
>>>     On Wednesday, February 12, 2020, 8:12:19 PM PST, Paul Rogers
>>> <par0...@yahoo.com.invalid> wrote:
>>>
>>>  Going to take a wild guess. Since you configured the "Demo" schema in
>>> the JDBC driver, you may not need it in the Drill query. Maybe try:
>>>
>>> SELECT * FROM dremiodemo.weather;
>>>
>>> Thanks,
>>> - Paul
>>>
>>>
>>>
>>>     On Wednesday, February 12, 2020, 10:34:35 AM PST, David Du <
>>> d...@bcmcgroup.com> wrote:
>>>
>>>  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!
>>>
>>>
>>>
>>
>>

-- 
********************************************************
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

Reply via email to