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

Incorrect operator profiles for queries on json files

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.11.0
    • Fix Version/s: None
    • Component/s: Storage - JSON
    • Labels:
      None

      Description

      1) Join query on two json files

      select ps.ps_suppkey from dfs.`testData/json/part.josn` as p, dfs.`testData/json/partsupp.json` as ps where p.p_partkey = ps.ps_partkey;
      

      2) Check the query profile. It has the following issues -
      a) JSON_SUB_SCAN type incorrectly ordered
      b) Missing SCREEN type

      Attached
      1) Two json files
      2) Snapshot of query profile and operator profile

      Commit id - 9d1d815737528251a7500621cc976b57e7f3be59

        Attachments

        1. OperatorProfiles.png
          111 kB
          Prasad Nagaraj Subramanya
        2. part.json
          1 kB
          Prasad Nagaraj Subramanya
        3. partsupp.json
          5 kB
          Prasad Nagaraj Subramanya
        4. QueryProfile.png
          54 kB
          Prasad Nagaraj Subramanya

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              prasadns14 Prasad Nagaraj Subramanya
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: