[
https://issues.apache.org/jira/browse/DRILL-3788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rahul Challapalli updated DRILL-3788:
-------------------------------------
Attachment: plan.txt
Log file contents
{code}
2015-09-16 00:59:51,812 [2a0740fa-e089-4afc-a162-cfc554a4e70a:frag:0:0] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a0740fa-e089-4afc-a162-cfc554a4e70a:0:0:
State to report: FINISHED
2015-09-16 00:59:51,822 [BitServer-4] INFO
o.a.drill.exec.work.foreman.Foreman - State change requested. RUNNING -->
COMPLETED
2015-09-16 00:59:51,828 [BitServer-4] INFO
o.a.drill.exec.work.foreman.Foreman - foreman cleaning up.
2015-09-16 01:02:10,342 [2a07406d-9089-755a-2371-fc8750a53628:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING -->
RUNNING
2015-09-16 01:02:10,343 [2a07406d-9089-755a-2371-fc8750a53628:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a07406d-9089-755a-2371-fc8750a53628:0:0:
State change requested AWAITING_ALLOCATION --> RUNNING
2015-09-16 01:02:10,343 [2a07406d-9089-755a-2371-fc8750a53628:frag:0:0] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a07406d-9089-755a-2371-fc8750a53628:0:0:
State to report: RUNNING
2015-09-16 01:02:10,351 [2a07406d-9089-755a-2371-fc8750a53628:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a07406d-9089-755a-2371-fc8750a53628:0:0:
State change requested RUNNING --> FINISHED
2015-09-16 01:02:10,351 [2a07406d-9089-755a-2371-fc8750a53628:frag:0:0] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a07406d-9089-755a-2371-fc8750a53628:0:0:
State to report: FINISHED
2015-09-16 01:02:10,360 [BitServer-4] INFO
o.a.drill.exec.work.foreman.Foreman - State change requested. RUNNING -->
COMPLETED
2015-09-16 01:02:10,367 [BitServer-4] INFO
o.a.drill.exec.work.foreman.Foreman - foreman cleaning up.
2015-09-15 22:42:33,037 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:1:11] INFO
o.a.d.e.w.fragment.FragmentExecutor -
2a07630c-0d47-a04a-5490-a814a65a575d:1:11: State change requested RUNNING -->
FINISHED
2015-09-15 22:42:33,038 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:1:11] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a07630c-0d47-a04a-5490-a814a65a575d:1:11:
State to report: FINISHED
2015-09-15 22:42:33,040 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:1:13] INFO
o.a.d.e.w.fragment.FragmentExecutor -
2a07630c-0d47-a04a-5490-a814a65a575d:1:13: State change requested RUNNING -->
FINISHED
2015-09-15 22:42:33,040 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:1:13] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a07630c-0d47-a04a-5490-a814a65a575d:1:13:
State to report: FINISHED
2015-09-15 22:42:33,041 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:1:15] INFO
o.a.d.e.w.fragment.FragmentExecutor -
2a07630c-0d47-a04a-5490-a814a65a575d:1:15: State change requested RUNNING -->
FINISHED
2015-09-15 22:42:33,042 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:1:15] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a07630c-0d47-a04a-5490-a814a65a575d:1:15:
State to report: FINISHED
2015-09-15 22:42:33,042 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:2:1] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a07630c-0d47-a04a-5490-a814a65a575d:2:1:
State change requested RUNNING --> FINISHED
2015-09-15 22:42:33,043 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:2:1] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a07630c-0d47-a04a-5490-a814a65a575d:2:1:
State to report: FINISHED
2015-09-15 22:42:33,156 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:1:29] INFO
o.a.d.e.w.fragment.FragmentExecutor -
2a07630c-0d47-a04a-5490-a814a65a575d:1:29: State change requested RUNNING -->
FINISHED
2015-09-15 22:42:33,157 [2a07630c-0d47-a04a-5490-a814a65a575d:frag:1:29] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a07630c-0d47-a04a-5490-a814a65a575d:1:29:
State to report: FINISHED
2015-09-16 01:09:37,149 [2a073eae-ca95-9ca5-26a5-335acf3085c5:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING -->
RUNNING
2015-09-16 01:09:37,150 [2a073eae-ca95-9ca5-26a5-335acf3085c5:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a073eae-ca95-9ca5-26a5-335acf3085c5:0:0:
State change requested AWAITING_ALLOCATION --> RUNNING
2015-09-16 01:09:37,150 [2a073eae-ca95-9ca5-26a5-335acf3085c5:frag:0:0] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a073eae-ca95-9ca5-26a5-335acf3085c5:0:0:
State to report: RUNNING
2015-09-16 01:09:37,160 [2a073eae-ca95-9ca5-26a5-335acf3085c5:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a073eae-ca95-9ca5-26a5-335acf3085c5:0:0:
State change requested RUNNING --> FINISHED
2015-09-16 01:09:37,160 [2a073eae-ca95-9ca5-26a5-335acf3085c5:frag:0:0] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a073eae-ca95-9ca5-26a5-335acf3085c5:0:0:
State to report: FINISHED
2015-09-16 01:09:37,171 [BitServer-4] INFO
o.a.drill.exec.work.foreman.Foreman - State change requested. RUNNING -->
COMPLETED
2015-09-16 01:09:37,178 [BitServer-4] INFO
o.a.drill.exec.work.foreman.Foreman - foreman cleaning up.
{code}
> Partition Pruning not taking place with metadata caching when we have ~20k
> files
> --------------------------------------------------------------------------------
>
> Key: DRILL-3788
> URL: https://issues.apache.org/jira/browse/DRILL-3788
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.2.0
> Reporter: Rahul Challapalli
> Assignee: Jinfeng Ni
> Priority: Critical
> Fix For: 1.2.0
>
> Attachments: plan.txt
>
>
> git.commit.id.abbrev=240a455
> Partition Pruning did not take place for the below query after I executed the
> "refresh table metadata command"
> {code}
> explain plan for
> select
> l_returnflag,
> l_linestatus
> from
> `lineitem/2006/1`
> where
> dir0=1 or dir0=2
> {code}
> The logs did not indicate that "pruning did not take place"
> Before executing the refresh table metadata command, partition pruning did
> take effect
> I am not attaching the data set as it is larger than 10MB. Reach out to me if
> you need more information
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
