# Druid JDBC - The JDBC storage plugin failed while trying setup the SQL query

**URL:** <https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830>\
**Category:** Dremio University\
**Created:** [December 26, 2019, 1:42pm UTC](https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830 "2019-12-26T13:42:12Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![srimukunthan](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@srimukunthan](https://community.dremio.com/u/srimukunthan)\
**Post date:** [December 26, 2019, 1:42pm UTC](https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830/1 "2019-12-26T13:42:12Z")

</div>

Druid tables are getting listed in dremio. while querying table it gives following error. “The JDBC storage plugin failed while trying setup the SQL query”

Arp file mappings.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/d/d00f0ae1c8c8c96ca98086a971d63029974cc5eb.png)

Error message:  
2019-12-26 19:11:56,419 [FABRIC-rpc-event-queue] INFO c.d.sabot.exec.FragmentExecutors - Received remote fragment start instruction for 21fb475a-ad03-c1f1-155e-57beb6a22b00:0:0  
2019-12-26 19:11:56,428 [out-of-band-observer] ERROR c.d.service.jobs.QueryProfileParser - Failed to parse physical plan for query 21fb475a-ad03-c1f1-155e-57beb6a22b00, plan {  
"“00-00"”: {  
““op””: “com.dremio.exec.planner.physical.ScreenPrel”,  
““values””: {},  
““inputs””: [  
“00-01”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{6.100000001E9 rows, 3.2100120001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-01"”: {  
““op””: “com.dremio.exec.planner.physical.ProjectPrel”,  
““values””: {  
““fields””: “[Fragment, Records, Path, Metadata, Partition, FileSize]”,  
““exprs””: “[$0, $1, $2, $3, $4, $5]”  
},  
““inputs””: [  
“00-02”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{6.000000001E9 rows, 3.2000120001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-02"”: {  
““op””: “com.dremio.exec.planner.physical.WriterCommitterPrel”,  
““values””: {  
““final””: “C:/Users/H241787/AppData/Local/Dremio/pdfs/results/21fb475a-ad03-c1f1-155e-57beb6a22b00”  
},  
““inputs””: [  
“00-03”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{5.000000001E9 rows, 3.2000060001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-03"”: {  
““op””: “com.dremio.exec.planner.physical.WriterPrel”,  
““values””: {},  
““inputs””: [  
“00-04”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{4.000000001E9 rows, 3.1000060001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-04"”: {  
““op””: “com.dremio.exec.planner.physical.ProjectPrel”,  
““values””: {  
““fields””: “[\_\_time, latitude, longitude]”,  
““exprs””: “[$0, $1, $2]”  
},  
““inputs””: [  
“00-05”  
],  
““rowType””: “RecordType(TIMESTAMP(3) \_\_time, FLOAT latitude, FLOAT longitude)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{3.000000001E9 rows, 3.0000060001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-05"”: {  
““op””: “com.dremio.exec.planner.physical.ProjectPrel”,  
““values””: {  
““fields””: “[\_\_time, latitude, longitude]”,  
““exprs””: “[$0, $1, $2]”  
},  
““inputs””: [  
“00-06”  
],  
““rowType””: “RecordType(TIMESTAMP(3) \_\_time, FLOAT latitude, FLOAT longitude)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{2.000000001E9 rows, 3.0000030001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
““00-06"”: {  
““op””: “com.dremio.exec.store.jdbc.rel.JdbcPrel”,  
““values””: {  
““sql””: “SELECT \*  
\nFROM “druid”.“druid”.“23\_Dec\_Traffic””  
},  
““inputs””: [],  
““rowType””: “RecordType(TIMESTAMP(3) \_\_time, FLOAT latitude, FLOAT longitude)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{1.000000001E9 rows, 3.0000000001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
}  
}  
com.fasterxml.jackson.core.JsonParseException: Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value  
at [Source: (String)”{  
"“00-00"”: {  
““op””: “com.dremio.exec.planner.physical.ScreenPrel”,  
““values””: {},  
““inputs””: [  
“00-01”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{6.100000001E9 rows, 3.2100120001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-01"”: {  
““op””: “com.dremio.exec.planner.ph”[truncated 2866 chars]; line: 76, column: 28]  
at com.fasterxml.jackson.core.JsonParser.\_constructError(JsonParser.java:1804) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.base.ParserMinimalBase.\_reportError(ParserMinimalBase.java:693) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.base.ParserMinimalBase.\_throwUnquotedSpace(ParserMinimalBase.java:657) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.\_finishString2(ReaderBasedJsonParser.java:2053) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.\_finishString(ReaderBasedJsonParser.java:2024) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.getText(ReaderBasedJsonParser.java:278) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:672) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.mapObject(UntypedObjectDeserializer.java:871) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:654) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.mapObject(UntypedObjectDeserializer.java:880) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:654) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.MapDeserializer.\_readAndBindStringKeyMap(MapDeserializer.java:527) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:364) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:29) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.ObjectMapper.\_readMapAndClose(ObjectMapper.java:4013) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3004) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.dremio.service.jobs.QueryProfileParser.parsePhysicalPlan(QueryProfileParser.java:312) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.service.jobs.QueryProfileParser.parse(QueryProfileParser.java:343) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.service.jobs.QueryProfileParser.(QueryProfileParser.java:98) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.service.jobs.LocalJobsService$JobResultListener.execStarted(LocalJobsService.java:1388) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.exec.planner.observer.OutOfBandAttemptObserver.lambda$execStarted$13(OutOfBandAttemptObserver.java:140) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.exec.planner.observer.OutOfBandAttemptObserver.lambda$execute$31(OutOfBandAttemptObserver.java:253) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.common.SerializedExecutor$RunnableProcessor.run(SerializedExecutor.java:96) ~[dremio-services-base-rpc-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0\_211]  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0\_211]  
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0\_211]  
2019-12-26 19:11:58,171 [e0 - 21fb475a-ad03-c1f1-155e-57beb6a22b00:frag:0:0] INFO c.d.exec.store.jdbc.JdbcRecordReader - User Error Occurred [ErrorId: 069bf263-b1ab-4124-a5a8-f09e3bed0830]  
com.dremio.common.exceptions.UserException: The JDBC storage plugin failed while trying setup the SQL query.  
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:773) ~[dremio-common-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:226) [dremio-ce-jdbc-plugin-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.exec.store.CoercionReader.setup(CoercionReader.java:109) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.op.scan.ScanOperator$1.run(ScanOperator.java:220) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.op.scan.ScanOperator$1.run(ScanOperator.java:216) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0\_211]  
at javax.security.auth.Subject.doAs(Subject.java:422) [na:1.8.0\_211]  
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1836) [hadoop-common-2.8.3.jar:na]  
at com.dremio.sabot.op.scan.ScanOperator.setupReaderAsCorrectUser(ScanOperator.java:216) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.op.scan.ScanOperator.setupReader(ScanOperator.java:189) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.op.scan.ScanOperator.setup(ScanOperator.java:175) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.SmartOp$SmartProducer.setup(SmartOp.java:558) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.Pipe$SetupVisitor.visitProducer(Pipe.java:79) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.Pipe$SetupVisitor.visitProducer(Pipe.java:63) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.SmartOp$SmartProducer.accept(SmartOp.java:528) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.StraightPipe.setup(StraightPipe.java:102) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.StraightPipe.setup(StraightPipe.java:102) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.StraightPipe.setup(StraightPipe.java:102) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.StraightPipe.setup(StraightPipe.java:102) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.StraightPipe.setup(StraightPipe.java:102) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.StraightPipe.setup(StraightPipe.java:102) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.driver.Pipeline.setup(Pipeline.java:68) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.exec.fragment.FragmentExecutor.setupExecution(FragmentExecutor.java:360) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.exec.fragment.FragmentExecutor.run(FragmentExecutor.java:244) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.exec.fragment.FragmentExecutor.access$1200(FragmentExecutor.java:92) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run(FragmentExecutor.java:632) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.task.AsyncTaskWrapper.run(AsyncTaskWrapper.java:104) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop(SlicingThread.java:226) [dremio-ce-sabot-scheduler-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.sabot.task.slicing.SlicingThread.run(SlicingThread.java:156) [dremio-ce-sabot-scheduler-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
Caused by: org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : Error while executing SQL “SELECT \*  
FROM “druid”.“druid”.“23\_Dec\_Traffic””: Remote driver error: RuntimeException: org.apache.calcite.tools.ValidationException: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 37: Object ‘druid’ not found within ‘druid’ -\> ValidationException: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 37: Object ‘druid’ not found within ‘druid’ -\> CalciteContextException: From line 2, column 6 to line 2, column 37: Object ‘druid’ not found within ‘druid’ -\> SqlValidatorException: Object ‘druid’ not found within ‘druid’  
at org.apache.calcite.avatica.Helper.createException(Helper.java:54) ~[avatica-1.12.0.jar:1.12.0]  
at org.apache.calcite.avatica.Helper.createException(Helper.java:41) ~[avatica-1.12.0.jar:1.12.0]  
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) ~[avatica-1.12.0.jar:1.12.0]  
at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227) ~[avatica-1.12.0.jar:1.12.0]  
at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:206) ~[commons-dbcp2-2.2.0.jar:2.2.0]  
at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:206) ~[commons-dbcp2-2.2.0.jar:2.2.0]  
at com.dremio.exec.store.jdbc.JdbcRecordReader.setup(JdbcRecordReader.java:197) [dremio-ce-jdbc-plugin-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
… 27 common frames omitted  
2019-12-26 19:11:58,604 [out-of-band-observer] ERROR c.d.service.jobs.QueryProfileParser - Failed to parse physical plan for query 21fb475a-ad03-c1f1-155e-57beb6a22b00, plan {  
"“00-00"”: {  
““op””: “com.dremio.exec.planner.physical.ScreenPrel”,  
““values””: {},  
““inputs””: [  
“00-01”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{6.100000001E9 rows, 3.2100120001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-01"”: {  
““op””: “com.dremio.exec.planner.physical.ProjectPrel”,  
““values””: {  
““fields””: “[Fragment, Records, Path, Metadata, Partition, FileSize]”,  
““exprs””: “[$0, $1, $2, $3, $4, $5]”  
},  
““inputs””: [  
“00-02”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{6.000000001E9 rows, 3.2000120001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-02"”: {  
““op””: “com.dremio.exec.planner.physical.WriterCommitterPrel”,  
““values””: {  
““final””: “C:/Users/H241787/AppData/Local/Dremio/pdfs/results/21fb475a-ad03-c1f1-155e-57beb6a22b00”  
},  
““inputs””: [  
“00-03”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{5.000000001E9 rows, 3.2000060001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-03"”: {  
““op””: “com.dremio.exec.planner.physical.WriterPrel”,  
““values””: {},  
““inputs””: [  
“00-04”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{4.000000001E9 rows, 3.1000060001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-04"”: {  
““op””: “com.dremio.exec.planner.physical.ProjectPrel”,  
““values””: {  
““fields””: “[\_\_time, latitude, longitude]”,  
““exprs””: “[$0, $1, $2]”  
},  
““inputs””: [  
“00-05”  
],  
““rowType””: “RecordType(TIMESTAMP(3) \_\_time, FLOAT latitude, FLOAT longitude)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{3.000000001E9 rows, 3.0000060001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
"“00-05"”: {  
““op””: “com.dremio.exec.planner.physical.ProjectPrel”,  
““values””: {  
““fields””: “[\_\_time, latitude, longitude]”,  
““exprs””: “[$0, $1, $2]”  
},  
““inputs””: [  
“00-06”  
],  
““rowType””: “RecordType(TIMESTAMP(3) \_\_time, FLOAT latitude, FLOAT longitude)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{2.000000001E9 rows, 3.0000030001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
““00-06"”: {  
““op””: “com.dremio.exec.store.jdbc.rel.JdbcPrel”,  
““values””: {  
““sql””: “SELECT \*  
\nFROM “druid”.“druid”.“23\_Dec\_Traffic””  
},  
““inputs””: [],  
““rowType””: “RecordType(TIMESTAMP(3) \_\_time, FLOAT latitude, FLOAT longitude)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{1.000000001E9 rows, 3.0000000001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
}  
}  
com.fasterxml.jackson.core.JsonParseException: Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value  
at [Source: (String)”{  
““00-00"”: {  
““op””: “com.dremio.exec.planner.physical.ScreenPrel”,  
““values””: {},  
““inputs””: [  
“00-01”  
],  
““rowType””: “RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize)”,  
““rowCount””: 1.0E9,  
““cumulativeCost””: “{6.100000001E9 rows, 3.2100120001E10 cpu, 3.0E10 io, 3.0E10 network, 0.0 memory}”  
},  
““00-01"”: {  
““op””: “com.dremio.exec.planner.ph”[truncated 2866 chars]; line: 76, column: 28]  
at com.fasterxml.jackson.core.JsonParser.\_constructError(JsonParser.java:1804) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.base.ParserMinimalBase.\_reportError(ParserMinimalBase.java:693) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.base.ParserMinimalBase.\_throwUnquotedSpace(ParserMinimalBase.java:657) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.\_finishString2(ReaderBasedJsonParser.java:2053) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.\_finishString(ReaderBasedJsonParser.java:2024) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.getText(ReaderBasedJsonParser.java:278) ~[jackson-core-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:672) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.mapObject(UntypedObjectDeserializer.java:871) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:654) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.mapObject(UntypedObjectDeserializer.java:880) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:654) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.MapDeserializer.\_readAndBindStringKeyMap(MapDeserializer.java:527) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:364) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:29) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.ObjectMapper.\_readMapAndClose(ObjectMapper.java:4013) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3004) ~[jackson-databind-2.9.8.jar:2.9.8]  
at com.dremio.service.jobs.QueryProfileParser.parsePhysicalPlan(QueryProfileParser.java:312) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.service.jobs.QueryProfileParser.parse(QueryProfileParser.java:343) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.service.jobs.QueryProfileParser.(QueryProfileParser.java:98) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.service.jobs.LocalJobsService.addAttemptToJob(LocalJobsService.java:1555) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.service.jobs.LocalJobsService.access$1200(LocalJobsService.java:199) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.service.jobs.LocalJobsService$QueryListener.execCompletion(LocalJobsService.java:1044) [dremio-services-jobs-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.exec.planner.observer.OutOfBandQueryObserver$1.run(OutOfBandQueryObserver.java:49) [dremio-sabot-kernel-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at com.dremio.common.SerializedExecutor$RunnableProcessor.run(SerializedExecutor.java:96) [dremio-services-base-rpc-3.2.4-201906051751050278-1bcce62.jar:3.2.4-201906051751050278-1bcce62]  
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0\_211]  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0\_211]  
at java.lang.Thread.run(Thread.java:748) [na:1.8.0\_211]  
2019-12-26 19:11:58,610 [FABRIC-rpc-event-queue] WARN c.d.exec.work.foreman.AttemptManager - Dropping request to move to COMPLETED state as query is already at FAILED state (which is terminal).  
2019-12-26 19:11:58,614 [out-of-band-observer] INFO query.logger - {“queryId”:“21fb475a-ad03-c1f1-155e-57beb6a22b00”,“schema”:”[Dri, druid, druid]”,“queryText”:“SELECT \* FROM “23\_Dec\_Traffic””,“start”:1577367716261,“finish”:1577367718600,“outcome”:“FAILED”,“username”:“testuser”}

---

<div class="post-metadata">

**Author:** ![srimukunthan](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@srimukunthan](https://community.dremio.com/u/srimukunthan)\
**Post date:** [December 26, 2019, 1:44pm UTC](https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830/2 "2019-12-26T13:44:22Z")

</div>

Using dremio community edition version 3.2.4-201906051751050278-1bcce62

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [December 26, 2019, 8:45pm UTC](https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830/3 "2019-12-26T20:45:31Z")

</div>

@srimukunthan

Kindly send us the job profile of the failed query

[How To Share A Dremio Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)

---

<div class="post-metadata">

**Author:** ![srimukunthan](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@srimukunthan](https://community.dremio.com/u/srimukunthan)\
**Post date:** [December 30, 2019, 7:03am UTC](https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830/4 "2019-12-30T07:03:15Z")

</div>

[ba13fbc8-974f-468a-9358-f6dc09a53c97.zip](https://community.dremio.com/uploads/short-url/iC1oqe12gNqG5jUsB6PQizVUxfL.zip) (7.6 KB)

@balaji.ramaswamy attached job profile

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [December 30, 2019, 5:42pm UTC](https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830/5 "2019-12-30T17:42:44Z")

</div>

@srimukunthan

What happens if you run the below query directly on Druid?

> SELECT \* FROM “druid”.“druid”.“23\_Dec\_Traffic”

---

<div class="post-metadata">

**Author:** ![srimukunthan](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@srimukunthan](https://community.dremio.com/u/srimukunthan)\
**Post date:** [December 31, 2019, 7:55am UTC](https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830/6 "2019-12-31T07:55:28Z")

</div>

@balaji.ramaswamy In druid i am getting below error. if i run query (SELECT \* FROM “druid”.“druid”.“23\_Dec\_Traffic”)

Unknown exception / org.apache.calcite.runtime.CalciteContextException: From line 1, column 30 to line 1, column 61: Object ‘druid’ not found within ‘druid’ / org.apache.calcite.tools.ValidationException

Table metadata(column names) getting retried from database. but not the data

Normal query(SELECT \* FROM “23\_Dec\_Traffic”) works fine.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [January 1, 2020, 12:55am UTC](https://community.dremio.com/t/druid-jdbc-the-jdbc-storage-plugin-failed-while-trying-setup-the-sql-query/4830/7 "2020-01-01T00:55:59Z")

</div>

@srimukunthan

it looks like the push down is incorrect. We currently do not support Druid as a source. Will check here internally if there is anything we can do

Thanks  
@balaji.ramaswamy