Hi James, Please see the attached.
On Wed, Feb 2, 2022 at 2:35 AM Daniel Clark <[email protected]> wrote: > Hi James, > > There initially weren’t any differences between the 1.19 environment and > the 1.20.0-SNAPSHOT environment. The config options that worked in the 1.19 > environment were carried over when I installed the snapshot build. The > recent change made to the snapshot build was setting > store.mongo.bson.record.reader to true. The original query worked in the > 1.19 environment, with the parameter set to false. > > Yes, I’m running the exact same query against the exact same data sources. > I’ll attach a copy of the stack trace and profile, later this morning. I’ll > also see about reducing the dataset. Thanks for following up. > > Sent from my iPhone > > > On Feb 2, 2022, at 2:03 AM, James Turton <[email protected]> wrote: > > > > Okay. It's always a good idea to attach a stack trace and a query > profile when you have an error to send in, so maybe you can add those? > > > > Next, we're left with a reproducibility challenge. Are there other > config option differences between your two Drill environments, beyond the > one we've uncovered? Are you running exactly the same query against > exactly the same data source in both environments? Can you reduce the > collections involved in the query to minimal (and obfuscated if need be) > datasets that we can use to reproduce the problem? > > > >> On 2022/02/01 18:15, Daniel Clark wrote: > >> No, exec.enable_union_type is set tofalse. > >> On Tue, Feb 1, 2022 at 10:59 AM James Turton <[email protected] <mailto: > [email protected]>> wrote: > >> Do you have exec.enable_union_type = true in your 1.19 environment? > >> On 2022/02/01 17:30, Daniel Clark wrote: > >> > Hi James, > >> > > >> > Yes, the store.mongo.bson.record.reader was set to false. I set > >> it to true > >> > and re-ran the original query. It returned an error: > >> > UNSUPPORTED_OPERATION ERROR: Schema changes not supported in > >> External Sort. > >> > Please enable Union type. > >> > > >> > > >> > > >> > On Tue, Feb 1, 2022 at 9:19 AM James Turton <[email protected] > >> <mailto:[email protected]>> wrote: > >> > > >> >> Hi Daniel > >> >> > >> >> Please let us know if you have set the config option > >> store.mongo.bson.record.reader > >> >> = false and, if so, please set it to true. > >> >> > >> >> Thanks > >> >> James > >> >> > >> >> On 2022/01/31 17:45, Daniel Clark wrote: > >> >> > >> >> Here it is. Please see the attached file. > >> >> > >> >> On Mon, Jan 31, 2022 at 4:22 AM James Turton <[email protected] > >> <mailto:[email protected]>> wrote: > >> >> > >> >>> Please also attach the query profile if you can. > >> >>> > >> >>> Thanks > >> >>> James > >> >>> > >> >>> On 2022/01/31 08:09, luoc wrote: > >> >>>> Hi Daniel, > >> >>>> What is the data type of the `_id` field? The default > >> ObjectId, or > >> >>> String or key-value pair (Struct)? > >> >>>> > >> >>>>> On Jan 31, 2022, at 11:12, Daniel Clark <[email protected] > >> <mailto:[email protected]>> wrote: > >> >>>>> > >> >>>>> > >> >>>>> Hello, > >> >>>>> > >> >>>>> I'm running this mongo query on the 1.20.0-SNAPSHOT build. It > >> runs > >> >>> without error on the 1.19 release. > >> >>>>> > >> >>>>> SELECT `Elements_Efforts`.`EffortTypeName` AS > `EffortTypeName`, > >> >>>>> `Elements`.`ElementSubTypeName` AS `ElementSubTypeName`, > >> >>>>> `Elements`.`ElementTypeName` AS `ElementTypeName`, > >> >>>>> `Elements`.`PlanID` AS `PlanID` > >> >>>>> FROM `mongo.grounds`.`Elements` `Elements` > >> >>>>> INNER JOIN `mongo.grounds`.`Elements_Efforts` > >> `Elements_Efforts` ON > >> >>> (`Elements`.`_id` = `Elements_Efforts`.`_id`) > >> >>>>> WHERE (`Elements`.`PlanID` = '1623263140') > >> >>>>> GROUP BY `Elements_Efforts`.`EffortTypeName`, > >> >>>>> `Elements`.`ElementSubTypeName`, > >> >>>>> `Elements`.`ElementTypeName`, > >> >>>>> `Elements`.`PlanID` > >> >>>>> > >> >>>>> The error message returned is: > >> >>>>> > >> >>>>> org.apache.drill.common.exceptions.UserRemoteException: > >> SYSTEM ERROR: > >> >>> UnsupportedOperationException: Map, Array, Union or repeated > >> scalar type > >> >>> should not be used in group by, order by or in a comparison > >> operator. Drill > >> >>> does not support compare between MAP:REQUIRED and MAP:REQUIRED. > >> >>>>> > >> >>>>> Fragment: 0:0 > >> >>>>> > >> >>>>> Please, refer to logs for more information. > >> >>>>> > >> >>>>> [Error Id: 21b3260d-9ebf-4156-a5fa-4748453b5465 on > >> localhost:31010] > >> >>>>> > >> >>>>> I've tried searching the mailing list archives, as well as > >> googling > >> >>> the error. The stack trace mentions that memory was leaked by > >> the query. > >> >>> Any ideas? Full stack trace attached. > >> >>>>> <stacktrace.txt> > >> >>> > >> >>> > >> >> > >> > >
2022-02-02 16:00:50,791 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - Query text for query with id
1e050efc-fbe8-5bc0-8ee5-0e7240a05b42 issued by clarkddc: SELECT
`Elements_Efforts`.`EffortTypeName` AS `EffortTypeName`,
`Elements`.`ElementSubTypeName` AS `ElementSubTypeName`,
`Elements`.`ElementTypeName` AS `ElementTypeName`,
`Elements`.`PlanID` AS `PlanID`
FROM `mongo.grounds`.`Elements` `Elements`
INNER JOIN `mongo.grounds`.`Elements_Efforts` `Elements_Efforts` ON
(`Elements`.`_id` = `Elements_Efforts`.`_id`)
WHERE (`Elements`.`PlanID` = '1623263140')
GROUP BY `Elements_Efforts`.`EffortTypeName`,
`Elements`.`ElementSubTypeName`,
`Elements`.`ElementTypeName`,
`Elements`.`PlanID`
2022-02-02 16:00:50,799 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:foreman] INFO
o.a.d.e.s.mongo.MongoStoragePlugin - Created connection to
[address=localhost:27017, user=web-user].
2022-02-02 16:00:50,799 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:foreman] INFO
o.a.d.e.s.mongo.MongoStoragePlugin - Number of open connections 1.
2022-02-02 16:00:50,827 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:foreman] WARN
o.a.d.e.s.m.s.MongoSchemaFactory - Failure while getting collection names from
'admin'. Command failed with error 13 (Unauthorized): 'not authorized on admin
to execute command { listCollections: 1, cursor: {}, nameOnly: true, $db:
"admin", $clusterTime: { clusterTime: Timestamp(1643835650, 1), signature: {
hash: BinData(0, 703C6EA97E7FE4E60B7FAAE9AB9FCDC8083EDA0C), keyId:
7034735910600048641 } }, lsid: { id:
UUID("7abb3c81-785b-4f28-b534-a28e545db0ce") } }' on server localhost:27017.
The full response is {"operationTime": {"$timestamp": {"t": 1643835650, "i":
1}}, "ok": 0.0, "errmsg": "not authorized on admin to execute command {
listCollections: 1, cursor: {}, nameOnly: true, $db: \"admin\", $clusterTime: {
clusterTime: Timestamp(1643835650, 1), signature: { hash: BinData(0,
703C6EA97E7FE4E60B7FAAE9AB9FCDC8083EDA0C), keyId: 7034735910600048641 } },
lsid: { id: UUID(\"7abb3c81-785b-4f28-b534-a28e545db0ce\") } }", "code": 13,
"codeName": "Unauthorized", "$clusterTime": {"clusterTime": {"$timestamp":
{"t": 1643835650, "i": 1}}, "signature": {"hash": {"$binary": {"base64":
"cDxuqX5/5OYLf6rpq5/NyAg+2gw=", "subType": "00"}}, "keyId":
7034735910600048641}}}
2022-02-02 16:24:34,829 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.s.m.MongoScanBatchCreator - Number of record readers initialized : 1
2022-02-02 16:24:34,844 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.s.m.MongoScanBatchCreator - Number of record readers initialized : 1
2022-02-02 16:24:34,869 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:0:0:
State change requested AWAITING_ALLOCATION --> RUNNING
2022-02-02 16:24:34,869 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.w.f.FragmentStatusReporter - 1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:0:0:
State to report: RUNNING
2022-02-02 16:24:57,680 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.p.i.xsort.ExternalSortBatch - User Error Occurred: Schema changes not
supported in External Sort. Please enable Union type.
org.apache.drill.common.exceptions.UserException: UNSUPPORTED_OPERATION ERROR:
Schema changes not supported in External Sort. Please enable Union type.
Previous schema: BatchSchema [fields=[[`EffortTypeID` (INT:OPTIONAL)],
[`EffortTypeName` (VARCHAR:OPTIONAL)], [`EffortSubTypeID` (INT:OPTIONAL)],
[`EffortSubTypeName` (VARCHAR:OPTIONAL)], [`CrewTypeID` (INT:OPTIONAL)],
[`CrewType` (VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)], [`MaterialID`
(INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)]], selectionVector=NONE]
Incoming schema: BatchSchema [fields=[[`EffortTypeID` (INT:OPTIONAL)],
[`EffortTypeName` (VARCHAR:OPTIONAL)], [`EffortSubTypeID` (INT:OPTIONAL)],
[`EffortSubTypeName` (VARCHAR:OPTIONAL)], [`CrewTypeID` (INT:OPTIONAL)],
[`CrewType` (VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)], [`MaterialID`
(INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)], [`MinutesTotal` (FLOAT8:OPTIONAL)]], selectionVector=NONE]
[Error Id: 57acfa4a-a8a8-4835-9df6-dc78007d7393 ]
at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:657)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.setupSchema(ExternalSortBatch.java:482)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.loadBatch(ExternalSortBatch.java:449)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.load(ExternalSortBatch.java:400)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.innerNext(ExternalSortBatch.java:355)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.RecordIterator.nextBatch(RecordIterator.java:102)
at
org.apache.drill.exec.record.RecordIterator.next(RecordIterator.java:191)
at
org.apache.drill.exec.record.RecordIterator.prepare(RecordIterator.java:175)
at
org.apache.drill.exec.physical.impl.join.JoinStatus.prepare(JoinStatus.java:86)
at
org.apache.drill.exec.physical.impl.join.MergeJoinBatch.innerNext(MergeJoinBatch.java:184)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:85)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:85)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.loadBatch(ExternalSortBatch.java:441)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.load(ExternalSortBatch.java:400)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.innerNext(ExternalSortBatch.java:355)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.physical.impl.aggregate.StreamingAggBatch.innerNext(StreamingAggBatch.java:214)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:85)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:103)
at
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:81)
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:93)
at
org.apache.drill.exec.work.fragment.FragmentExecutor.lambda$run$0(FragmentExecutor.java:321)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1762)
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:310)
at
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2022-02-02 16:24:57,681 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] ERROR
o.a.d.e.physical.impl.BaseRootExec - Batch dump started: dumping last 2 failed
batches
2022-02-02 16:24:57,681 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] ERROR
o.a.d.e.p.i.xsort.ExternalSortBatch - ExternalSortBatch[schema=BatchSchema
[fields=[[`EffortTypeID` (INT:OPTIONAL)], [`EffortTypeName`
(VARCHAR:OPTIONAL)], [`EffortSubTypeID` (INT:OPTIONAL)], [`EffortSubTypeName`
(VARCHAR:OPTIONAL)], [`CrewTypeID` (INT:OPTIONAL)], [`CrewType`
(VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)], [`MaterialID`
(INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)]], selectionVector=NONE], sortState=LOAD,
sortConfig=SortConfig[spillFileSize=268435456, spillBatchSize=1048576,
mergeBatchSize=16777216, mSortBatchSize=65535],
outputWrapperContainer=org.apache.drill.exec.record.VectorContainer@20bc1881[recordCount
= 0, schemaChanged = false, schema = BatchSchema [fields=[],
selectionVector=NONE], wrappers = [], ...],
outputSV4=SelectionVector4[data=DrillBuf[1], udle: [1 0..0], recordCount=0,
start=0, length=0],
container=org.apache.drill.exec.record.VectorContainer@5a576e3e[recordCount =
0, schemaChanged = false, schema = BatchSchema [fields=[[`EffortTypeID`
(INT:OPTIONAL)], [`EffortTypeName` (VARCHAR:OPTIONAL)], [`EffortSubTypeID`
(INT:OPTIONAL)], [`EffortSubTypeName` (VARCHAR:OPTIONAL)], [`CrewTypeID`
(INT:OPTIONAL)], [`CrewType` (VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)],
[`MaterialID` (INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)]], selectionVector=NONE], wrappers =
[org.apache.drill.exec.vector.NullableIntVector@1c1b947[field = [`EffortTypeID`
(INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@4a095f3e[field =
[`EffortTypeName` (VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableIntVector@a313eee[field =
[`EffortSubTypeID` (INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@6b768708[field =
[`EffortSubTypeName` (VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableIntVector@677100a0[field = [`CrewTypeID`
(INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@678153df[field = [`CrewType`
(VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@64c4d78f[field = [`Unit`
(VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableIntVector@3b5542d8[field = [`MaterialID`
(INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableIntVector@54ce3112[field = [`EquipmentID`
(INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@39bc9fff[field =
[`Equipment` (VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableFloat8Vector@7b065fe8[field =
[`MinutesPerUnit` (FLOAT8:OPTIONAL)], ...],
org.apache.drill.exec.vector.complex.MapVector@6ad491d2,
org.apache.drill.exec.vector.NullableVarBinaryVector@4f376b3b[field = [`_id`
(VARBINARY:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@12294645[field = [`Material`
(VARCHAR:OPTIONAL)], ...]], ...]]
2022-02-02 16:24:57,682 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] ERROR
o.a.d.e.p.i.s.RemovingRecordBatch -
RemovingRecordBatch[container=org.apache.drill.exec.record.VectorContainer@5b99a2f7[recordCount
= 0, schemaChanged = false, schema = BatchSchema [fields=[[`EffortTypeID`
(INT:OPTIONAL)], [`EffortTypeName` (VARCHAR:OPTIONAL)], [`EffortSubTypeID`
(INT:OPTIONAL)], [`EffortSubTypeName` (VARCHAR:OPTIONAL)], [`CrewTypeID`
(INT:OPTIONAL)], [`CrewType` (VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)],
[`MaterialID` (INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)]], selectionVector=NONE], wrappers =
[org.apache.drill.exec.vector.NullableIntVector@158df257[field =
[`EffortTypeID` (INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@61172d6e[field =
[`EffortTypeName` (VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableIntVector@39544467[field =
[`EffortSubTypeID` (INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@2f4cc7a0[field =
[`EffortSubTypeName` (VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableIntVector@55299754[field = [`CrewTypeID`
(INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@d0dbcc2[field = [`CrewType`
(VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@1661b678[field = [`Unit`
(VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableIntVector@5f5902d3[field = [`MaterialID`
(INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableIntVector@46d3ad5b[field = [`EquipmentID`
(INT:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@2658e2ef[field =
[`Equipment` (VARCHAR:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableFloat8Vector@3d91422a[field =
[`MinutesPerUnit` (FLOAT8:OPTIONAL)], ...],
org.apache.drill.exec.vector.complex.MapVector@2a4990d1,
org.apache.drill.exec.vector.NullableVarBinaryVector@712b49b6[field = [`_id`
(VARBINARY:OPTIONAL)], ...],
org.apache.drill.exec.vector.NullableVarCharVector@108592e6[field = [`Material`
(VARCHAR:OPTIONAL)], ...]], ...], state=NOT_FIRST,
copier=org.apache.drill.exec.physical.impl.svremover.StraightCopier@27b212ce]
2022-02-02 16:24:57,682 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] ERROR
o.a.d.e.physical.impl.BaseRootExec - Batch dump completed.
2022-02-02 16:24:57,682 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:0:0:
State change requested RUNNING --> FAILED
2022-02-02 16:24:57,702 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:0:0:
State change requested FAILED --> FAILED
2022-02-02 16:24:57,703 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:0:0:
State change requested FAILED --> FAILED
2022-02-02 16:24:57,703 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:0:0:
State change requested FAILED --> FAILED
2022-02-02 16:24:57,703 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:0:0:
State change requested FAILED --> FINISHED
2022-02-02 16:24:57,710 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] WARN
o.a.d.exec.rpc.control.WorkEventBus - Fragment
1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:0:0 manager is not found in the work bus.
2022-02-02 16:24:57,713 [qtp1799477491-100] ERROR
o.a.d.e.server.rest.QueryResources - Query from Web UI Failed: {}
org.apache.drill.common.exceptions.UserRemoteException: UNSUPPORTED_OPERATION
ERROR: Schema changes not supported in External Sort. Please enable Union type.
Previous schema: BatchSchema [fields=[[`EffortTypeID` (INT:OPTIONAL)],
[`EffortTypeName` (VARCHAR:OPTIONAL)], [`EffortSubTypeID` (INT:OPTIONAL)],
[`EffortSubTypeName` (VARCHAR:OPTIONAL)], [`CrewTypeID` (INT:OPTIONAL)],
[`CrewType` (VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)], [`MaterialID`
(INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)]], selectionVector=NONE]
Incoming schema: BatchSchema [fields=[[`EffortTypeID` (INT:OPTIONAL)],
[`EffortTypeName` (VARCHAR:OPTIONAL)], [`EffortSubTypeID` (INT:OPTIONAL)],
[`EffortSubTypeName` (VARCHAR:OPTIONAL)], [`CrewTypeID` (INT:OPTIONAL)],
[`CrewType` (VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)], [`MaterialID`
(INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)], [`MinutesTotal` (FLOAT8:OPTIONAL)]], selectionVector=NONE]
Fragment: 0:0
[Error Id: 57acfa4a-a8a8-4835-9df6-dc78007d7393 on localhost:31010]
at
org.apache.drill.exec.server.rest.RestQueryRunner.submitQuery(RestQueryRunner.java:99)
at
org.apache.drill.exec.server.rest.RestQueryRunner.run(RestQueryRunner.java:54)
at
org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryResources.java:158)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
at
org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
at
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
at
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)
at
org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
at
org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
at
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)
at
org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1631)
at
org.apache.drill.exec.server.rest.header.ResponseHeadersSettingFilter.doFilter(ResponseHeadersSettingFilter.java:71)
at
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
at
org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFilter(CsrfTokenValidateFilter.java:55)
at
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
at
org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilter(CsrfTokenInjectFilter.java:54)
at
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:571)
at
org.apache.drill.exec.server.rest.auth.DrillHttpSecurityHandlerProvider.handle(DrillHttpSecurityHandlerProvider.java:163)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:400)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:645)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:392)
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.Exception: UNSUPPORTED_OPERATION ERROR: Schema changes not
supported in External Sort. Please enable Union type.
Previous schema: BatchSchema [fields=[[`EffortTypeID` (INT:OPTIONAL)],
[`EffortTypeName` (VARCHAR:OPTIONAL)], [`EffortSubTypeID` (INT:OPTIONAL)],
[`EffortSubTypeName` (VARCHAR:OPTIONAL)], [`CrewTypeID` (INT:OPTIONAL)],
[`CrewType` (VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)], [`MaterialID`
(INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)]], selectionVector=NONE]
Incoming schema: BatchSchema [fields=[[`EffortTypeID` (INT:OPTIONAL)],
[`EffortTypeName` (VARCHAR:OPTIONAL)], [`EffortSubTypeID` (INT:OPTIONAL)],
[`EffortSubTypeName` (VARCHAR:OPTIONAL)], [`CrewTypeID` (INT:OPTIONAL)],
[`CrewType` (VARCHAR:OPTIONAL)], [`Unit` (VARCHAR:OPTIONAL)], [`MaterialID`
(INT:OPTIONAL)], [`EquipmentID` (INT:OPTIONAL)], [`Equipment`
(VARCHAR:OPTIONAL)], [`MinutesPerUnit` (FLOAT8:OPTIONAL)], [`Frequency`
(MAP:REQUIRED), children=([`Jan` (FLOAT8:OPTIONAL)], [`Feb` (FLOAT8:OPTIONAL)],
[`Mar` (FLOAT8:OPTIONAL)], [`Apr` (FLOAT8:OPTIONAL)], [`May`
(FLOAT8:OPTIONAL)], [`Jun` (FLOAT8:OPTIONAL)], [`Jul` (FLOAT8:OPTIONAL)],
[`Aug` (FLOAT8:OPTIONAL)], [`Sep` (FLOAT8:OPTIONAL)], [`Oct`
(FLOAT8:OPTIONAL)])], [`_id` (VARBINARY:OPTIONAL)], [`Material`
(VARCHAR:OPTIONAL)], [`MinutesTotal` (FLOAT8:OPTIONAL)]], selectionVector=NONE]
Fragment: 0:0
[Error Id: 57acfa4a-a8a8-4835-9df6-dc78007d7393 on localhost:31010]
at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:657)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.setupSchema(ExternalSortBatch.java:482)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.loadBatch(ExternalSortBatch.java:449)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.load(ExternalSortBatch.java:400)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.innerNext(ExternalSortBatch.java:355)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.RecordIterator.nextBatch(RecordIterator.java:102)
at
org.apache.drill.exec.record.RecordIterator.next(RecordIterator.java:191)
at
org.apache.drill.exec.record.RecordIterator.prepare(RecordIterator.java:175)
at
org.apache.drill.exec.physical.impl.join.JoinStatus.prepare(JoinStatus.java:86)
at
org.apache.drill.exec.physical.impl.join.MergeJoinBatch.innerNext(MergeJoinBatch.java:184)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:85)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:85)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.loadBatch(ExternalSortBatch.java:441)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.load(ExternalSortBatch.java:400)
at
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.innerNext(ExternalSortBatch.java:355)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.physical.impl.aggregate.StreamingAggBatch.innerNext(StreamingAggBatch.java:214)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:111)
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:59)
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:85)
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:170)
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:103)
at
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:81)
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:93)
at
org.apache.drill.exec.work.fragment.FragmentExecutor.lambda$run$0(FragmentExecutor.java:321)
at .......(:0)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1762)
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:310)
at
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
at .......(:0)
2022-02-02 16:24:57,724 [1e050efc-fbe8-5bc0-8ee5-0e7240a05b42:frag:0:0] WARN
o.a.d.e.w.f.QueryStateProcessor - Dropping request to move to COMPLETED state
as query is already at FAILED state (which is terminal).
profile.json
Description: application/json
