Uploaded image for project: 'Pig'
  1. Pig
  2. PIG-920

optimizing diamond queries

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.6.0
    • None
    • None
    • Reviewed

    Description

      The following query

      A = load 'foo';
      B = filer A by $0>1;
      C = filter A by $1 = 'foo';
      D = COGROUP C by $0, B by $0;
      ......

      does not get efficiently executed. Currently, it runs a map only job that basically reads and write the same data before doing the query processing.

      Query where the data is loaded twice actually executed more efficiently.

      This is not an uncommon query and we should fix this issue.

      Attachments

        1. PIG-920.patch
          14 kB
          Richard Ding
        2. PIG-920.patch
          14 kB
          Richard Ding

        Activity

          People

            rding Richard Ding
            olgan Olga Natkovich
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: