[
https://issues.apache.org/jira/browse/DRILL-6448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva reassigned DRILL-6448:
---------------------------------------
Assignee: (was: Arina Ielchiieva)
> query on nested data returns bogus results
> ------------------------------------------
>
> Key: DRILL-6448
> URL: https://issues.apache.org/jira/browse/DRILL-6448
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.13.0
> Reporter: Dechang Gu
> Priority: Major
>
> I created a nested parquet table nested_c_o_l with the following schema:
> {code}
> 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);
> }
> }
> }
> {code}
> and run the following query:
> {code}
> select * from nested_c_o_l c where c.c_orders.o_orderdate='1997-06-23';
> {code}
> It returns two row, with the 2nd row does not satisfy the filter condition:
> {code}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)
> {code}
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
