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.
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”}