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

Directory based partition pruning not taking effect with metadata caching

    XMLWordPrintableJSON

    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. DRILL-3788-part2.patch
          3 kB
          Aman Sinha
        2. DRILL-3788.patch
          5 kB
          Mehant Baid
        3. lineitem.tgz
          2.38 MB
          Rahul Kumar Challapalli
        4. plan.txt
          98 kB
          Rahul Kumar Challapalli

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: