Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3788

Directory based partition pruning not taking effect with metadata caching

    Details

      Description

      git.commit.id.abbrev=240a455

      Partition Pruning did not take place for the below query after I executed the "refresh table metadata command"

       explain plan for 
      select
        l_returnflag,
        l_linestatus
      from
        `lineitem/2006/1`
      where
        dir0=1 or dir0=2
      

      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

        Attachments

        1. plan.txt
          98 kB
          Rahul Challapalli
        2. lineitem.tgz
          2.38 MB
          Rahul Challapalli
        3. DRILL-3788-part2.patch
          3 kB
          Aman Sinha
        4. DRILL-3788.patch
          5 kB
          Mehant Baid

          Activity

            People

            • Assignee:
              mehant Mehant Baid
              Reporter:
              rkins Rahul Challapalli
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: