Hi Team, i request someone to please help me
thanks and regards Jagadeesh Maddi On Tue, Oct 11, 2022 at 11:39 PM jagadeesh maddi <jagadeesh.m...@gmail.com> wrote: > Hi Team, > > Can some one please suggest me how to solve the problem > > Thanks and regards > Jagadeesh maddi > > On Tue, 11 Oct 2022 at 1:12 PM, jagadeesh maddi <jagadeesh.m...@gmail.com> > wrote: > >> Hi Team, >> >> We are facing the same issue while running the “union/union all “ on >> drill when connecting to Druid >> >> Thanks and regards >> Jagadeesh maddi >> >> On Sun, 9 Oct 2022 at 12:52 PM, jagadeesh maddi <jagadeesh.m...@gmail.com> >> wrote: >> >>> Hi James, >>> >>> Adding the reference json in case if I don’t use order by >>> >>> But can you please help me with information like >>> >>> “How to make query to split into multiple fragments..because in this >>> case query has only 1 major and minor fragment” >>> >>> 2. The query time is also very high and is there a way to increase the >>> batch size as it is limited to pull only 4096 records per batch >>> >>> In our case each batch talking 4ms as per the debug logs when we use >>> this json >>> >>> >>> Thanks and regards >>> Jagadeesh maddi >>> >>> On Sat, 8 Oct 2022 at 8:00 PM, jagadeesh maddi <jagadeesh.m...@gmail.com> >>> wrote: >>> >>>> Yes James, >>>> >>>> If I remove order by it is working perfectly >>>> >>>> Thanks and regards >>>> Jagadeesh maddi >>>> >>>> On Sat, 8 Oct 2022 at 6:51 PM, James Turton <dz...@apache.org> wrote: >>>> >>>>> To confirm, if you remove the ORDER BY clause from this query it runs >>>>> successfully? >>>>> >>>>> On 2022/10/08 14:02, jagadeesh maddi wrote: >>>>> > Hi James, >>>>> > >>>>> > I am attaching the json profile >>>>> > >>>>> > Please can you look into this >>>>> > >>>>> > Waiting for your suggestion. >>>>> > >>>>> > Thanks and regards >>>>> > Jagadeesh maddi >>>>> > >>>>> > On Sat, 8 Oct 2022 at 11:03 AM, James Turton <dz...@apache.org >>>>> > <mailto:dz...@apache.org>> wrote: >>>>> > >>>>> > Please send the JSON query profile. >>>>> > >>>>> > On 2022/10/06 18:46, jagadeesh maddi wrote: >>>>> > > Hi James, >>>>> > > >>>>> > > We are in production. We need your help >>>>> > > >>>>> > > Please provide your suggestion to solve this problem >>>>> > > >>>>> > > Thanks and regards >>>>> > > Jagadeesh maddi >>>>> > > >>>>> > > On Thu, 6 Oct 2022 at 1:15 AM, jagadeesh maddi >>>>> > <jagadeesh.m...@gmail.com <mailto:jagadeesh.m...@gmail.com> >>>>> > > <mailto:jagadeesh.m...@gmail.com >>>>> > <mailto:jagadeesh.m...@gmail.com>>> wrote: >>>>> > > >>>>> > > HI james, >>>>> > > >>>>> > > Error: error i am geting >>>>> > > >>>>> > > [30038]Query execution error. Details:[ SYSTEM ERROR: >>>>> > > NullPointerException Fragment: 3:0 Please, refer to logs >>>>> for more >>>>> > > information. [Error Id: >>>>> ba482a08-ffab-4069-a094-9fb82cbe0955 on >>>>> > > blp14571311:31010] >>>>> > > >>>>> (com.fasterxml.jackson.databind.exc.ValueInstantiationException) >>>>> > > Cannot construct instance of >>>>> > > `org.apache.drill.exec.store.druid.DruidSubScan`, problem: >>>>> > > `java.lang.NullPointerException` at [Source: (String)"{ >>>>> "pop" : >>>>> > > "hash-partition-sender", "@id" : 0, >>>>> "receiver-major-fragment" >>>>> > : 2, >>>>> > > "child" : { "pop" : "druid-datasource-scan", "@id" : 1, >>>>> > "columns" : >>>>> > > [ "`__time`", "`COUNTER_GROUP_ID`", "C_1`", "`C_10`", >>>>> "`C_11`", >>>>> > > "`C_12`" ], "maxRecordsToRead" : -1, "initialAlloca... >>>>> > > thanks and regards >>>>> > > Jagadeesh Maddi >>>>> > > >>>>> > > On Wed, Oct 5, 2022 at 11:34 PM jagadeesh maddi >>>>> > > <jagadeesh.m...@gmail.com <mailto: >>>>> jagadeesh.m...@gmail.com> >>>>> > <mailto:jagadeesh.m...@gmail.com <mailto: >>>>> jagadeesh.m...@gmail.com>>> >>>>> > wrote: >>>>> > > >>>>> > > thanks james, >>>>> > > >>>>> > > But in using as `__time` not 'time' it was type >>>>> error..i am >>>>> > > sorry for that >>>>> > > >>>>> > > i have checked no keywords used in the Query >>>>> > > >>>>> > > thanks and regards >>>>> > > jagadeesh Maddi >>>>> > > >>>>> > > On Wed, Oct 5, 2022 at 7:55 PM James Turton >>>>> > <dz...@apache.org <mailto:dz...@apache.org> >>>>> > > <mailto:dz...@apache.org <mailto:dz...@apache.org>>> >>>>> wrote: >>>>> > > >>>>> > > Hi Jagadeesh >>>>> > > >>>>> > > "time" is a keyword in Drill SQL. I'm not sure >>>>> that >>>>> > this is >>>>> > > connected to >>>>> > > the problem you're hitting but please try your >>>>> query with >>>>> > > `time` (and >>>>> > > any other names that coincide with keywords) >>>>> enclosed in >>>>> > > backticks. >>>>> > > >>>>> > > Regards >>>>> > > James >>>>> > > >>>>> > > On 2022/10/05 15:01, jagadeesh maddi wrote: >>>>> > > > Hi Team, >>>>> > > > >>>>> > > > we are using Apache Drill to connect to Druid >>>>> and pull >>>>> > > the data >>>>> > > > we are facing a issue when we did "order by" >>>>> > > > >>>>> > > > Query: select time,XXX,YYY from XXXXX order by >>>>> > time desc >>>>> > > > >>>>> > > > Exception: >>>>> > > > 2022-10-05 13:46:44,594 >>>>> > > [1cc2834a-c555-f719-ae42-4a6e85b69d80:frag:3:0] >>>>> > > > INFO o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:3:0: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> FAILED >>>>> > > > 2022-10-05 13:46:44,594 >>>>> > > [1cc2834a-c555-f719-ae42-4a6e85b69d80:frag:3:0] >>>>> > > > INFO o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:3:0: >>>>> State change >>>>> > > requested FAILED >>>>> > > > --> FINISHED >>>>> > > > 2022-10-05 13:46:44,594 >>>>> > > [1cc2834a-c555-f719-ae42-4a6e85b69d80:frag:3:0] >>>>> > > > ERROR o.a.d.e.w.fragment.FragmentExecutor - >>>>> SYSTEM >>>>> > ERROR: >>>>> > > > NullPointerException >>>>> > > > >>>>> > > > Fragment: 3:0 >>>>> > > > >>>>> > > > Please, refer to logs for more information. >>>>> > > > >>>>> > > > [Error Id: >>>>> 9a7171d4-8789-412d-84c4-87b46040fe1b on >>>>> > > xxxxxxxxxx:31010] >>>>> > > > >>>>> org.apache.drill.common.exceptions.UserException: >>>>> > SYSTEM >>>>> > > ERROR: >>>>> > > > NullPointerException >>>>> > > > >>>>> > > > Fragment: 3:0 >>>>> > > > >>>>> > > > Please, refer to logs for more information. >>>>> > > > >>>>> > > > [Error Id: >>>>> 9a7171d4-8789-412d-84c4-87b46040fe1b on >>>>> > > xxxxxxxxxx:31010] >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:657) >>>>> > > > at >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392) >>>>> > > > at >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:244) >>>>> > > > at >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentExecutor.run(FragmentExecutor.java:359) >>>>> > > > 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) >>>>> > > > Caused by: >>>>> > > > >>>>> > > >>>>> > >>>>> com.fasterxml.jackson.databind.exc.ValueInstantiationException: Cannot >>>>> > > > construct instance of >>>>> > > `org.apache.drill.exec.store.druid.DruidSubScan`, >>>>> > > > problem: `java.lang.NullPointerException` >>>>> > > > at [Source: (String)"{ >>>>> > > > "pop" : "hash-partition-sender", >>>>> > > > "@id" : 0, >>>>> > > > "receiver-major-fragment" : 2, >>>>> > > > "child" : { >>>>> > > > "pop" : "druid-datasource-scan", >>>>> > > > "@id" : 1, >>>>> > > > "columns" : [ "`__time`", "`xxx_ID`", >>>>> > "`xxx_C_1`", >>>>> > > "`xxx_C_10`", >>>>> > > > "`xxx_C_11`", "`xxx_C_12`", "`xxx_C_13`", >>>>> > "`xxx_C_14`", >>>>> > > "`xxx_C_15`", >>>>> > > > "`xxx_C_16`", "`xxx_C_17`", "`xxx_C_18`", >>>>> > "`xxx_C_19`", >>>>> > > "`xxx_C_2`", >>>>> > > > "`xxx_C_20`", "`xxx_C_21`", "`xxx_C_22`", >>>>> > "`xxx_C_23`", >>>>> > > "`xxx_C_24`", >>>>> > > > "`xxx_C_25`", "`xxx_C_26`", "`xxx_C_27`", >>>>> > "`xxx_C_28`", >>>>> > > > "`xxx_C"[truncated 3449 chars]; line: 16, >>>>> column: 3] >>>>> > > (through reference >>>>> > > > chain: >>>>> > > >>>>> > >>>>> org.apache.drill.exec.physical.config.HashPartitionSender["child"]) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.exc.ValueInstantiationException.from(ValueInstantiationException.java:47) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.DeserializationContext.instantiationException(DeserializationContext.java:2047) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.wrapAsJsonMappingException(StdValueInstantiator.java:587) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.rewrapCtorProblem(StdValueInstantiator.java:610) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.createFromObjectWith(StdValueInstantiator.java:293) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.ValueInstantiator.createFromObjectWith(ValueInstantiator.java:288) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.impl.PropertyBasedCreator.build(PropertyBasedCreator.java:202) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:518) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:1405) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:351) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId(BeanDeserializerBase.java:1371) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:217) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:186) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:144) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:110) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:263) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:539) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping(BeanDeserializer.java:563) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:438) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:1405) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:351) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId(BeanDeserializerBase.java:1371) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:217) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:186) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:144) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:110) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:263) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.impl.TypeWrappedDeserializer.deserialize(TypeWrappedDeserializer.java:74) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.DefaultDeserializationContext.readRootValue(DefaultDeserializationContext.java:322) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReader.java:2051) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.java:1492) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.exec.planner.PhysicalPlanReader.readFragmentRoot(PhysicalPlanReader.java:103) >>>>> > > > at >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentExecutor.run(FragmentExecutor.java:288) >>>>> > > > ... 4 common frames omitted >>>>> > > > Caused by: java.lang.NullPointerException: null >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.shaded.guava.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:878) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.shaded.guava.com.google.common.cache.LocalCache.get(LocalCache.java:3950) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.shaded.guava.com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.shaded.guava.com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.getPluginByConfig(StoragePluginRegistryImpl.java:670) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.resolve(StoragePluginRegistryImpl.java:918) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> org.apache.drill.exec.store.druid.DruidSubScan.<init>(DruidSubScan.java:64) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >>>>> Method) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>>>> > > > at >>>>> > > >>>>> > java.lang.reflect.Constructor.newInstance(Constructor.java:423) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.introspect.AnnotatedConstructor.call(AnnotatedConstructor.java:128) >>>>> > > > at >>>>> > > > >>>>> > > >>>>> > >>>>> >>>>> com.fasterxml.jackson.databind.deser.std.StdValueInstantiator.createFromObjectWith(StdValueInstantiator.java:291) >>>>> > > > ... 32 common frames omitted >>>>> > > > 2022-10-05 13:46:44,595 >>>>> > > [1cc2834a-c555-f719-ae42-4a6e85b69d80:frag:3:0] >>>>> > > > DEBUG o.a.d.e.w.f.FragmentStatusReporter - >>>>> Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@55a64148 >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0: >>>>> State to >>>>> > report: >>>>> > > > CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0: >>>>> State change >>>>> > > requested >>>>> > > > CANCELLATION_REQUESTED --> FINISHED >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0: >>>>> State to >>>>> > > report: CANCELLED >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] DEBUG >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@58bc8bec >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] DEBUG >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - Cancel >>>>> and >>>>> > removed >>>>> > > fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:1:0 >>>>> manager >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.NonRootFragmentManager@71ce5324 from >>>>> > > > the work bus. >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0: >>>>> State to >>>>> > report: >>>>> > > > CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,601 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0: >>>>> State change >>>>> > > requested >>>>> > > > CANCELLATION_REQUESTED --> FINISHED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0: >>>>> State to >>>>> > > report: CANCELLED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] DEBUG >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@57871915 >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] DEBUG >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - Cancel >>>>> and >>>>> > removed >>>>> > > fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:0 >>>>> manager >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.NonRootFragmentManager@33815de1 from >>>>> > > > the work bus. >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1: >>>>> State to >>>>> > report: >>>>> > > > CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1: >>>>> State change >>>>> > > requested >>>>> > > > CANCELLATION_REQUESTED --> FINISHED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1: >>>>> State to >>>>> > > report: CANCELLED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] DEBUG >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@274e160d >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] DEBUG >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - Cancel >>>>> and >>>>> > removed >>>>> > > fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:1 >>>>> manager >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.NonRootFragmentManager@53aea3f7 from >>>>> > > > the work bus. >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2: >>>>> State to >>>>> > report: >>>>> > > > CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2: >>>>> State change >>>>> > > requested >>>>> > > > CANCELLATION_REQUESTED --> FINISHED >>>>> > > > 2022-10-05 13:46:44,602 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2: >>>>> State to >>>>> > > report: CANCELLED >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] DEBUG >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@494bd466 >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] DEBUG >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - Cancel >>>>> and >>>>> > removed >>>>> > > fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:2 >>>>> manager >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.NonRootFragmentManager@67728ff4 from >>>>> > > > the work bus. >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3: >>>>> State to >>>>> > report: >>>>> > > > CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3: >>>>> State change >>>>> > > requested >>>>> > > > CANCELLATION_REQUESTED --> FINISHED >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3: >>>>> State to >>>>> > > report: CANCELLED >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] DEBUG >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@7514c548 >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] DEBUG >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - Cancel >>>>> and >>>>> > removed >>>>> > > fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:3 >>>>> manager >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.NonRootFragmentManager@45f6d750 from >>>>> > > > the work bus. >>>>> > > > 2022-10-05 13:46:44,603 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4: >>>>> State to >>>>> > report: >>>>> > > > CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4: >>>>> State change >>>>> > > requested >>>>> > > > CANCELLATION_REQUESTED --> FINISHED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4: >>>>> State to >>>>> > > report: CANCELLED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] DEBUG >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@1ab4354e >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] DEBUG >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - Cancel >>>>> and >>>>> > removed >>>>> > > fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:4 >>>>> manager >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.NonRootFragmentManager@45223df5 from >>>>> > > > the work bus. >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5: >>>>> State to >>>>> > report: >>>>> > > > CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5: >>>>> State change >>>>> > > requested >>>>> > > > CANCELLATION_REQUESTED --> FINISHED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5: >>>>> State to >>>>> > > report: CANCELLED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] DEBUG >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@4d1da66b >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] DEBUG >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - Cancel >>>>> and >>>>> > removed >>>>> > > fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:5 >>>>> manager >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.NonRootFragmentManager@5e1a35c3 from >>>>> > > > the work bus. >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6: >>>>> State change >>>>> > > requested >>>>> > > > AWAITING_ALLOCATION --> CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6: >>>>> State to >>>>> > report: >>>>> > > > CANCELLATION_REQUESTED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.fragment.FragmentExecutor - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6: >>>>> State change >>>>> > > requested >>>>> > > > CANCELLATION_REQUESTED --> FINISHED >>>>> > > > 2022-10-05 13:46:44,604 [BitServer-9] INFO >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6: >>>>> State to >>>>> > > report: CANCELLED >>>>> > > > 2022-10-05 13:46:44,605 [BitServer-9] DEBUG >>>>> > > > o.a.d.e.w.f.FragmentStatusReporter - Closing >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.FragmentStatusReporter@5a62b34a >>>>> > > > 2022-10-05 13:46:44,605 [BitServer-9] DEBUG >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - Cancel >>>>> and >>>>> > removed >>>>> > > fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:2:6 >>>>> manager >>>>> > > > org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work> >>>>> > > <http://org.apache.drill.exec.work >>>>> > <http://org.apache.drill.exec.work >>>>> >>.fragment.NonRootFragmentManager@5c4655af from >>>>> > > > the work bus. >>>>> > > > 2022-10-05 13:46:44,605 [BitServer-9] WARN >>>>> > > > o.a.d.exec.rpc.control.WorkEventBus - >>>>> Fragment >>>>> > > > 1cc2834a-c555-f719-ae42-4a6e85b69d80:3:0 >>>>> manager >>>>> > is not >>>>> > > found in the >>>>> > > > work bus. >>>>> > > > 2022-10-05 13:46:44,605 [BitServer-9] WARN >>>>> > > > o.a.d.e.w.b.ControlMessageHandler - Dropping >>>>> > request to >>>>> > > cancel >>>>> > > > fragment. >>>>> 1cc2834a-c555-f719-ae42-4a6e85b69d80:3:0 >>>>> > does >>>>> > > not exist. >>>>> > > > >>>>> > > > i request to please help me with the issue >>>>> > > > >>>>> > > > Thanks and regards >>>>> > > > Jagadeesh Maddi >>>>> > > >>>>> > >>>>> >>>>
