You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by jagadeesh maddi <ja...@gmail.com> on 2022/10/05 13:01:39 UTC
Error while implementing order By drill
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.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392)
at
org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:244)
at
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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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
Re: Error while implementing order By drill
Posted by jagadeesh maddi <ja...@gmail.com>.
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 <ja...@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 <ja...@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 <ja...@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 <ja...@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 <dzamo@apache.org
>>>>> > <ma...@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.m297@gmail.com <ma...@gmail.com>
>>>>> > > <mailto:jagadeesh.m297@gmail.com
>>>>> > <ma...@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.m297@gmail.com <mailto:
>>>>> jagadeesh.m297@gmail.com>
>>>>> > <mailto:jagadeesh.m297@gmail.com <mailto:
>>>>> jagadeesh.m297@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
>>>>> > <dzamo@apache.org <ma...@apache.org>
>>>>> > > <mailto:dzamo@apache.org <ma...@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
>>>>> > >
>>>>> >
>>>>>
>>>>
Re: Error while implementing order By drill
Posted by jagadeesh maddi <ja...@gmail.com>.
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 <ja...@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 <dzamo@apache.org
>> > <ma...@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.m297@gmail.com <ma...@gmail.com>
>> > > <mailto:jagadeesh.m297@gmail.com
>> > <ma...@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.m297@gmail.com <ma...@gmail.com>
>> > <mailto:jagadeesh.m297@gmail.com <mailto:jagadeesh.m297@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
>> > <dzamo@apache.org <ma...@apache.org>
>> > > <mailto:dzamo@apache.org <ma...@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
>> > >
>> >
>>
>
Re: Error while implementing order By drill
Posted by jagadeesh maddi <ja...@gmail.com>.
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 <dzamo@apache.org
> > <ma...@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.m297@gmail.com <ma...@gmail.com>
> > > <mailto:jagadeesh.m297@gmail.com
> > <ma...@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.m297@gmail.com <ma...@gmail.com>
> > <mailto:jagadeesh.m297@gmail.com <ma...@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
> > <dzamo@apache.org <ma...@apache.org>
> > > <mailto:dzamo@apache.org <ma...@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
> > >
> >
>
Re: Error while implementing order By drill
Posted by James Turton <dz...@apache.org>.
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 <dzamo@apache.org
> <ma...@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.m297@gmail.com <ma...@gmail.com>
> > <mailto:jagadeesh.m297@gmail.com
> <ma...@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.m297@gmail.com <ma...@gmail.com>
> <mailto:jagadeesh.m297@gmail.com <ma...@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
> <dzamo@apache.org <ma...@apache.org>
> > <mailto:dzamo@apache.org <ma...@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
> >
>
Re: Error while implementing order By drill
Posted by James Turton <dz...@apache.org>.
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.m297@gmail.com
> <ma...@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.m297@gmail.com <ma...@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 <dzamo@apache.org
> <ma...@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>.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392)
> > at
> > 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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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>.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
>
Re: Error while implementing order By drill
Posted by jagadeesh maddi <ja...@gmail.com>.
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 <ja...@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 <ja...@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> 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
>>> .fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392)
>>> > at
>>> > org.apache.drill.exec.work
>>> .fragment.FragmentExecutor.cleanup(FragmentExecutor.java:244)
>>> > at
>>> > 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
>>> .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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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
>>>
>>
Re: Error while implementing order By drill
Posted by jagadeesh maddi <ja...@gmail.com>.
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 <ja...@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> 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
>> .fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392)
>> > at
>> > org.apache.drill.exec.work
>> .fragment.FragmentExecutor.cleanup(FragmentExecutor.java:244)
>> > at
>> > 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
>> .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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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
>>
>
Re: Error while implementing order By drill
Posted by jagadeesh maddi <ja...@gmail.com>.
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> 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
> .fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392)
> > at
> > org.apache.drill.exec.work
> .fragment.FragmentExecutor.cleanup(FragmentExecutor.java:244)
> > at
> > 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
> .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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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
>
Re: Error while implementing order By drill
Posted by James Turton <dz...@apache.org>.
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.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:392)
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:244)
> at
> 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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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