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 <[email protected]> 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 <[email protected]> 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 <[email protected] >> > <mailto:[email protected]>> 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 >> > <[email protected] <mailto:[email protected]> >> > > <mailto:[email protected] >> > <mailto:[email protected]>>> 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 >> > > <[email protected] <mailto:[email protected]> >> > <mailto:[email protected] <mailto:[email protected] >> >>> >> > 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 >> > <[email protected] <mailto:[email protected]> >> > > <mailto:[email protected] <mailto:[email protected]>>> >> 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 >> > > >> > >> >
profile1.json
Description: application/json
