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

query on nested data returns bogus results

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.13.0
    • Fix Version/s: None
    • Component/s: Functions - Drill
    • Labels:
      None

      Description

      I created a nested parquet table nested_c_o_l with the following schema:

      message root {
        optional binary c_custkey (UTF8);
        optional binary c_name (UTF8);
        optional binary c_address (UTF8);
        optional int64 c_nationkey;
        optional binary c_phone (UTF8);
        optional double c_acctbal;
        optional binary c_mktsegment (UTF8);
        optional binary c_comment (UTF8);
        repeated group c_orders {
          optional int64 o_orderkey;
          optional binary o_orderstatus (UTF8);
          optional double o_totalprice;
          optional binary o_orderdate (UTF8);
          optional binary o_orderpriority (UTF8);
          optional binary o_clerk (UTF8);
          optional int64 o_shippriority;
          optional binary o_comment (UTF8);
          repeated group o_lineitems {
            optional int64 l_partkey;
            optional int64 l_suppkey;
            optional int64 l_linenumber;
            optional int64 l_quantity;
            optional double l_extendedprice;
            optional double l_discount;
            optional double l_tax;
            optional binary l_returnflag (UTF8);
            optional binary l_linestatus (UTF8);
            optional binary l_shipdate (UTF8);
            optional binary l_commitdate (UTF8);
            optional binary l_receiptdate (UTF8);
            optional binary l_shipinstruct (UTF8);
            optional binary l_shipmode (UTF8);
            optional binary l_comment (UTF8);
          }
        }
      }
      

      and run the following query:

      select * from nested_c_o_l c where c.c_orders.o_orderdate='1997-06-23';
      

      It returns two row, with the 2nd row does not satisfy the filter condition:

      0: jdbc:drill:schema=dfs.tpcdsView> select * from nested_c_o_l c where c.c_orders.o_orderdate='1997-06-23';
      +-----------+--------+-----------+-------------+---------+-----------+--------------+-----------+----------+
      | c_custkey | c_name | c_address | c_nationkey | c_phone | c_acctbal | c_mktsegment | c_comment | c_orders |
      +-----------+--------+-----------+-------------+---------+-----------+--------------+-----------+----------+
      | 1 | Customer#000000001 | IVhzIApeRb ot,c,E | 15 | 25-989-741-2988 | 711.56 | BUILDING | to the even, regular platelets. regular, ironic epitaphs nag e | [{"o_orderkey":9154,"o_orderstatus":"O","o_totalprice":357345.46,"o_orderdate":"1997-06-23","o_orderpriority":"4-NOT SPECIFIED","o_clerk":"Clerk#000000328","o_shippriority":0,"o_comment":"y ironic packages cajole. blithely final depende","o_lineitems":[{"l_partkey":866,"l_suppkey":100,"l_linenumber":1,"l_quantity":45,"l_extendedprice":79508.7,"l_discount":0.06,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-09-24","l_commitdate":"1997-08-11","l_receiptdate":"1997-10-14","l_shipinstruct":"NONE","l_shipmode":"FOB","l_comment":"nal, careful instructions wake carefully. b"},{"l_partkey":1735,"l_suppkey":36,"l_linenumber":7,"l_quantity":47,"l_extendedprice":76926.31,"l_discount":0.04,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-07-07","l_commitdate":"1997-09-07","l_receiptdate":"1997-07-25","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"SHIP","l_comment":"wake boldly above the furiousl"},{"l_partkey":1403,"l_suppkey":43,"l_linenumber":6,"l_quantity":40,"l_extendedprice":52176.0,"l_discount":0.03,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-24","l_commitdate":"1997-09-03","l_receiptdate":"1997-07-24","l_shipinstruct":"COLLECT COD","l_shipmode":"TRUCK","l_comment":"t haggle bli"},{"l_partkey":1770,"l_suppkey":13,"l_linenumber":5,"l_quantity":12,"l_extendedprice":20061.24,"l_discount":0.0,"l_tax":0.0,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-08-20","l_commitdate":"1997-07-26","l_receiptdate":"1997-09-17","l_shipinstruct":"NONE","l_shipmode":"RAIL","l_comment":"es. requests print furiously instead of th"},{"l_partkey":1967,"l_suppkey":100,"l_linenumber":4,"l_quantity":31,"l_extendedprice":57937.76,"l_discount":0.0,"l_tax":0.0,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-08-28","l_commitdate":"1997-07-29","l_receiptdate":"1997-09-07","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"final warthogs. slyly pending request"},{"l_partkey":534,"l_suppkey":65,"l_linenumber":3,"l_quantity":46,"l_extendedprice":65988.38,"l_discount":0.04,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-07-18","l_commitdate":"1997-08-22","l_receiptdate":"1997-07-31","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"inal depths. blithely quick deposits n"},{"l_partkey":143,"l_suppkey":22,"l_linenumber":2,"l_quantity":7,"l_extendedprice":7301.98,"l_discount":0.09,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-09-28","l_commitdate":"1997-09-21","l_receiptdate":"1997-10-27","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"SHIP","l_comment":"nts cajole near "}]},{"o_orderkey":14656,"o_orderstatus":"O","o_totalprice":28599.83,"o_orderdate":"1997-11-18","o_orderpriority":"2-HIGH","o_clerk":"Clerk#000000270","o_shippriority":0,"o_comment":"uests. blithely even platelet","o_lineitems":[{"l_partkey":596,"l_suppkey":97,"l_linenumber":1,"l_quantity":21,"l_extendedprice":31428.39,"l_discount":0.09,"l_tax":0.0,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1998-01-23","l_commitdate":"1997-12-23","l_receiptdate":"1998-02-15","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"AIR","l_comment":"lar deposits. fluffily regular accounts w"}]},{"o_orderkey":24322,"o_orderstatus":"O","o_totalprice":231040.44,"o_orderdate":"1997-01-29","o_orderpriority":"1-URGENT","o_clerk":"Clerk#000000100","o_shippriority":0,"o_comment":"regular deposits cajole slyly. ironic t","o_lineitems":[{"l_partkey":545,"l_suppkey":36,"l_linenumber":5,"l_quantity":22,"l_extendedprice":31801.88,"l_discount":0.08,"l_tax":0.08,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-26","l_commitdate":"1997-03-19","l_receiptdate":"1997-04-19","l_shipinstruct":"COLLECT COD","l_shipmode":"AIR","l_comment":"slyly regular ideas affix slyly. slyly fina"},{"l_partkey":1099,"l_suppkey":70,"l_linenumber":6,"l_quantity":50,"l_extendedprice":50004.5,"l_discount":0.07,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-04-26","l_commitdate":"1997-03-12","l_receiptdate":"1997-05-11","l_shipinstruct":"NONE","l_shipmode":"FOB","l_comment":"slyly blithel"},{"l_partkey":1787,"l_suppkey":88,"l_linenumber":1,"l_quantity":16,"l_extendedprice":27020.48,"l_discount":0.08,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-12","l_commitdate":"1997-03-22","l_receiptdate":"1997-03-14","l_shipinstruct":"COLLECT COD","l_shipmode":"FOB","l_comment":"g, pending waters. even ideas do"},{"l_partkey":99,"l_suppkey":50,"l_linenumber":2,"l_quantity":4,"l_extendedprice":3996.36,"l_discount":0.06,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-05-07","l_commitdate":"1997-03-04","l_receiptdate":"1997-05-25","l_shipinstruct":"COLLECT COD","l_shipmode":"RAIL","l_comment":"sts cajole fluffily silent instruc"},{"l_partkey":846,"l_suppkey":46,"l_linenumber":3,"l_quantity":29,"l_extendedprice":50658.36,"l_discount":0.02,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-04","l_commitdate":"1997-04-08","l_receiptdate":"1997-03-22","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"en ideas sleep carefully regu"},{"l_partkey":673,"l_suppkey":67,"l_linenumber":4,"l_quantity":44,"l_extendedprice":69241.48,"l_discount":0.02,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-03-05","l_commitdate":"1997-03-03","l_receiptdate":"1997-03-22","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":" about the fluffily ironic deposits. iro"}]},{"o_orderkey":31653,"o_orderstatus":"F","o_totalprice":152411.41,"o_orderdate":"1993-06-05","o_orderpriority":"2-HIGH","o_clerk":"Clerk#000000346","o_shippriority":0,"o_comment":"foxes. fluffily fin","o_lineitems":[{"l_partkey":341,"l_suppkey":98,"l_linenumber":4,"l_quantity":33,"l_extendedprice":40964.22,"l_discount":0.01,"l_tax":0.04,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-08-12","l_commitdate":"1993-07-14","l_receiptdate":"1993-08-24","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":"lent instruction"},{"l_partkey":217,"l_suppkey":99,"l_linenumber":2,"l_quantity":15,"l_extendedprice":16758.15,"l_discount":0.06,"l_tax":0.0,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-09-18","l_commitdate":"1993-07-13","l_receiptdate":"1993-10-18","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"REG AIR","l_comment":". fluffily express deposits above the"},{"l_partkey":1886,"l_suppkey":73,"l_linenumber":1,"l_quantity":46,"l_extendedprice":82242.48,"l_discount":0.09,"l_tax":0.01,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1993-09-11","l_commitdate":"1993-07-27","l_receiptdate":"1993-09-26","l_shipinstruct":"NONE","l_shipmode":"SHIP","l_comment":"lithely fi"},{"l_partkey":95,"l_suppkey":21,"l_linenumber":3,"l_quantity":12,"l_extendedprice":11941.08,"l_discount":0.08,"l_tax":0.08,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-07-08","l_commitdate":"1993-09-03","l_receiptdate":"1993-07-30","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":" the accounts. slyl"},{"l_partkey":1294,"l_suppkey":69,"l_linenumber":5,"l_quantity":6,"l_extendedprice":7171.74,"l_discount":0.02,"l_tax":0.0,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-06-07","l_commitdate":"1993-07-10","l_receiptdate":"1993-06-17","l_shipinstruct":"COLLECT COD","l_shipmode":"RAIL","l_comment":"ost furious"}]},{"o_orderkey":34019,"o_orderstatus":"O","o_totalprice":89230.03,"o_orderdate":"1998-03-29","o_orderpriority":"5-LOW","o_clerk":"Clerk#000000815","o_shippriority":0,"o_comment":"ic depths. boldly special multipliers caj","o_lineitems":[{"l_partkey":988,"l_suppkey":57,"l_linenumber":2,"l_quantity":35,"l_extendedprice":66114.3,"l_discount":0.1,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1998-07-05","l_commitdate":"1998-05-17","l_receiptdate":"1998-07-23","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":"posits integrate b"},{"l_partkey":581,"l_suppkey":72,"l_linenumber":1,"l_quantity":19,"l_extendedprice":28150.02,"l_discount":0.08,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1998-05-03","l_commitdate":"1998-06-06","l_receiptdate":"1998-06-01","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":" ideas-- quickly final package"}]},{"o_orderkey":36422,"o_orderstatus":"O","o_totalprice":270087.44,"o_orderdate":"1997-03-04","o_orderpriority":"3-MEDIUM","o_clerk":"Clerk#000000532","o_shippriority":0,"o_comment":"e evenly final dependencies. regular, bold pinto beans ","o_lineitems":[{"l_partkey":1542,"l_suppkey":83,"l_linenumber":1,"l_quantity":27,"l_extendedprice":38975.58,"l_discount":0.01,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-05-02","l_commitdate":"1997-05-01","l_receiptdate":"1997-05-25","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"into beans. blithely regular reque"},{"l_partkey":482,"l_suppkey":70,"l_linenumber":7,"l_quantity":27,"l_extendedprice":37326.96,"l_discount":0.06,"l_tax":0.04,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-18","l_commitdate":"1997-05-14","l_receiptdate":"1997-07-15","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"kages. blithely final excuses"},{"l_partkey":1466,"l_suppkey":67,"l_linenumber":2,"l_quantity":37,"l_extendedprice":50596.02,"l_discount":0.04,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-06-03","l_commitdate":"1997-04-07","l_receiptdate":"1997-06-17","l_shipinstruct":"COLLECT COD","l_shipmode":"SHIP","l_comment":"g deposits are about the as"},{"l_partkey":1458,"l_suppkey":76,"l_linenumber":3,"l_quantity":42,"l_extendedprice":57096.9,"l_discount":0.07,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-05-18","l_commitdate":"1997-05-09","l_receiptdate":"1997-05-28","l_shipinstruct":"NONE","l_shipmode":"MAIL","l |
      | 1484 | Customer#000001484 | WcOint654aJStnQWSgAAtI | 18 | 28-987-505-1842 | 4883.17 | FURNITURE | s against the furiously special packag | [{"o_orderkey":2275,"o_orderstatus":"F","o_totalprice":54526.45,"o_orderdate":"1992-10-22","o_orderpriority":"4-NOT SPECIFIED","o_clerk":"Clerk#000000206","o_shippriority":0,"o_comment":" furiously furious platelets. slyly final packa","o_lineitems":[{"l_partkey":904,"l_suppkey":73,"l_linenumber":2,"l_quantity":11,"l_extendedprice":19853.9,"l_discount":0.08,"l_tax":0.03,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1993-01-16","l_commitdate":"1992-12-10","l_receiptdate":"1993-01-25","l_shipinstruct":"COLLECT COD","l_shipmode":"REG AIR","l_comment":"ost across the never express instruction"},{"l_partkey":332,"l_suppkey":89,"l_linenumber":1,"l_quantity":30,"l_extendedprice":36969.9,"l_discount":0.08,"l_tax":0.05,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-01-10","l_commitdate":"1992-11-21","l_receiptdate":"1993-01-22","l_shipinstruct":"NONE","l_shipmode":"REG AIR","l_comment":"re slyly slyly special idea"}]},{"o_orderkey":11494,"o_orderstatus":"O","o_totalprice":90512.73,"o_orderdate":"1997-07-20","o_orderpriority":"3-MEDIUM","o_clerk":"Clerk#000000486","o_shippriority":0,"o_comment":"s. blithely unusual pi","o_lineitems":[{"l_partkey":410,"l_suppkey":98,"l_linenumber":3,"l_quantity":15,"l_extendedprice":19656.15,"l_discount":0.0,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-08-08","l_commitdate":"1997-09-05","l_receiptdate":"1997-08-15","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"ng platelets. even pac"},{"l_partkey":817,"l_suppkey":18,"l_linenumber":1,"l_quantity":13,"l_extendedprice":22331.53,"l_discount":0.05,"l_tax":0.0,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-10-03","l_commitdate":"1997-10-15","l_receiptdate":"1997-10-17","l_shipinstruct":"COLLECT COD","l_shipmode":"RAIL","l_comment":"the bold requests-- ironic deposit"},{"l_partkey":763,"l_suppkey":60,"l_linenumber":2,"l_quantity":2,"l_extendedprice":3327.52,"l_discount":0.07,"l_tax":0.02,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-08-07","l_commitdate":"1997-10-17","l_receiptdate":"1997-08-25","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"ake furiously sp"},{"l_partkey":225,"l_suppkey":80,"l_linenumber":4,"l_quantity":40,"l_extendedprice":45008.8,"l_discount":0.01,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-10-09","l_commitdate":"1997-09-11","l_receiptdate":"1997-10-23","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":" carefully regular deposits haggle blithel"}]},{"o_orderkey":11781,"o_orderstatus":"O","o_totalprice":147766.37,"o_orderdate":"1996-04-16","o_orderpriority":"5-LOW","o_clerk":"Clerk#000000619","o_shippriority":0,"o_comment":"s. final, final deposi","o_lineitems":[{"l_partkey":350,"l_suppkey":79,"l_linenumber":1,"l_quantity":37,"l_extendedprice":46262.95,"l_discount":0.07,"l_tax":0.01,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-06-14","l_commitdate":"1996-06-27","l_receiptdate":"1996-06-20","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"MAIL","l_comment":"packages use alongside of"},{"l_partkey":1136,"l_suppkey":45,"l_linenumber":2,"l_quantity":42,"l_extendedprice":43559.46,"l_discount":0.07,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-04-24","l_commitdate":"1996-06-02","l_receiptdate":"1996-04-28","l_shipinstruct":"NONE","l_shipmode":"SHIP","l_comment":" deposits wake. slyly regular dependenc"},{"l_partkey":686,"l_suppkey":80,"l_linenumber":3,"l_quantity":42,"l_extendedprice":66640.56,"l_discount":0.1,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-08","l_commitdate":"1996-07-07","l_receiptdate":"1996-07-17","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":" express, "}]},{"o_orderkey":26497,"o_orderstatus":"O","o_totalprice":93056.43,"o_orderdate":"1997-07-23","o_orderpriority":"3-MEDIUM","o_clerk":"Clerk#000000950","o_shippriority":0,"o_comment":"s platelets. bold accounts cajole furiously slyly pending excuses. furiously","o_lineitems":[{"l_partkey":874,"l_suppkey":8,"l_linenumber":1,"l_quantity":50,"l_extendedprice":88743.5,"l_discount":0.02,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1997-09-04","l_commitdate":"1997-09-07","l_receiptdate":"1997-09-12","l_shipinstruct":"COLLECT COD","l_shipmode":"RAIL","l_comment":"nt deposits. express"}]},{"o_orderkey":33413,"o_orderstatus":"O","o_totalprice":109300.44,"o_orderdate":"1996-06-23","o_orderpriority":"2-HIGH","o_clerk":"Clerk#000000029","o_shippriority":0,"o_comment":"kages. final, regular forges detect. blithely even packages ","o_lineitems":[{"l_partkey":36,"l_suppkey":37,"l_linenumber":3,"l_quantity":5,"l_extendedprice":4680.15,"l_discount":0.09,"l_tax":0.05,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-06","l_commitdate":"1996-09-18","l_receiptdate":"1996-07-18","l_shipinstruct":"NONE","l_shipmode":"RAIL","l_comment":"es. special de"},{"l_partkey":1905,"l_suppkey":94,"l_linenumber":2,"l_quantity":39,"l_extendedprice":70469.1,"l_discount":0.02,"l_tax":0.06,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-15","l_commitdate":"1996-08-26","l_receiptdate":"1996-07-30","l_shipinstruct":"NONE","l_shipmode":"AIR","l_comment":"aggle blithely above the p"},{"l_partkey":1283,"l_suppkey":21,"l_linenumber":1,"l_quantity":4,"l_extendedprice":4737.12,"l_discount":0.0,"l_tax":0.07,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-09-07","l_commitdate":"1996-07-25","l_receiptdate":"1996-09-11","l_shipinstruct":"COLLECT COD","l_shipmode":"FOB","l_comment":"- always s"},{"l_partkey":727,"l_suppkey":28,"l_linenumber":4,"l_quantity":16,"l_extendedprice":26043.52,"l_discount":0.01,"l_tax":0.03,"l_returnflag":"N","l_linestatus":"O","l_shipdate":"1996-07-02","l_commitdate":"1996-07-23","l_receiptdate":"1996-07-18","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"MAIL","l_comment":"rthogs cajole carefully. "}]},{"o_orderkey":33889,"o_orderstatus":"F","o_totalprice":192803.75,"o_orderdate":"1993-11-07","o_orderpriority":"5-LOW","o_clerk":"Clerk#000000726","o_shippriority":0,"o_comment":"ts cajole furiously final theodolites. furiously regular dependencies could","o_lineitems":[{"l_partkey":1897,"l_suppkey":27,"l_linenumber":3,"l_quantity":32,"l_extendedprice":57564.48,"l_discount":0.01,"l_tax":0.05,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-12-25","l_commitdate":"1994-01-18","l_receiptdate":"1994-01-17","l_shipinstruct":"NONE","l_shipmode":"MAIL","l_comment":"ve the furiously r"},{"l_partkey":1181,"l_suppkey":18,"l_linenumber":6,"l_quantity":6,"l_extendedprice":6493.08,"l_discount":0.05,"l_tax":0.0,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1994-03-07","l_commitdate":"1993-12-25","l_receiptdate":"1994-03-28","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"TRUCK","l_comment":"ate express, fluffy p"},{"l_partkey":1814,"l_suppkey":44,"l_linenumber":1,"l_quantity":14,"l_extendedprice":24021.34,"l_discount":0.03,"l_tax":0.01,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1993-12-13","l_commitdate":"1993-12-11","l_receiptdate":"1993-12-25","l_shipinstruct":"NONE","l_shipmode":"FOB","l_comment":"requests. ironic p"},{"l_partkey":992,"l_suppkey":95,"l_linenumber":2,"l_quantity":16,"l_extendedprice":30287.84,"l_discount":0.02,"l_tax":0.04,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1993-12-17","l_commitdate":"1993-12-21","l_receiptdate":"1994-01-08","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"REG AIR","l_comment":" sauternes wak"},{"l_partkey":439,"l_suppkey":40,"l_linenumber":7,"l_quantity":11,"l_extendedprice":14733.73,"l_discount":0.06,"l_tax":0.08,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-01-08","l_commitdate":"1994-01-06","l_receiptdate":"1994-01-17","l_shipinstruct":"NONE","l_shipmode":"TRUCK","l_comment":"l instructions haggle slyly regular deposi"},{"l_partkey":1945,"l_suppkey":90,"l_linenumber":5,"l_quantity":27,"l_extendedprice":49867.38,"l_discount":0.09,"l_tax":0.0,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1994-02-11","l_commitdate":"1994-01-16","l_receiptdate":"1994-03-04","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"SHIP","l_comment":"ong the boldly final request"},{"l_partkey":495,"l_suppkey":83,"l_linenumber":4,"l_quantity":8,"l_extendedprice":11163.92,"l_discount":0.0,"l_tax":0.08,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-01-29","l_commitdate":"1994-01-08","l_receiptdate":"1994-01-30","l_shipinstruct":"DELIVER IN PERSON","l_shipmode":"FOB","l_comment":"es are. blithe"}]},{"o_orderkey":36838,"o_orderstatus":"F","o_totalprice":330348.13,"o_orderdate":"1994-04-09","o_orderpriority":"5-LOW","o_clerk":"Clerk#000000179","o_shippriority":0,"o_comment":"equests haggle fluffily above the sometim","o_lineitems":[{"l_partkey":1488,"l_suppkey":28,"l_linenumber":7,"l_quantity":40,"l_extendedprice":55579.2,"l_discount":0.08,"l_tax":0.06,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-07-13","l_commitdate":"1994-06-19","l_receiptdate":"1994-07-31","l_shipinstruct":"NONE","l_shipmode":"RAIL","l_comment":"sts sleep furiously. blithe"},{"l_partkey":549,"l_suppkey":10,"l_linenumber":6,"l_quantity":25,"l_extendedprice":36238.5,"l_discount":0.04,"l_tax":0.02,"l_returnflag":"A","l_linestatus":"F","l_shipdate":"1994-07-10","l_commitdate":"1994-05-29","l_receiptdate":"1994-07-14","l_shipinstruct":"NONE","l_shipmode":"RAIL","l_comment":"equests agai"},{"l_partkey":664,"l_suppkey":27,"l_linenumber":5,"l_quantity":18,"l_extendedprice":28163.88,"l_discount":0.01,"l_tax":0.04,"l_returnflag":"R","l_linestatus":"F","l_shipdate":"1994-05-02","l_commitdate":"1994-06-20","l_receiptdate":"1994-05-18","l_shipinstruct":"TAKE BACK RETURN","l_shipmode":"RAIL","l_comment":"s packages after the brave i"},{"l_partkey":1256,"l_suppkey":57,"l_linenumber":4,"l_quantity":47,"l_extendedprice":54390.75,"l_discount":0.02, |
      +-----------+--------+-----------+-------------+---------+-----------+--------------+-----------+----------+
      2 rows selected (4.603 seconds)
      

      The issue is due to the filter refers c.c_orders.o_orderdate where c_orders is an array and should be flatten'ed. Drill should report error/warning on this filter instead executing it and
      return bogus results.

        Attachments

          Activity

            People

            • Assignee:
              arina Arina Ielchiieva
              Reporter:
              dechanggu Dechang Gu
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: