[ https://issues.apache.org/jira/browse/DRILL-1249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-1249. ------------------------------------ Verified and added the below testcase Functional/Passing/json_storage/q_DRILL-1249.q > JSON select with "LIMIT 1" throws exception when NULL exists in array > --------------------------------------------------------------------- > > Key: DRILL-1249 > URL: https://issues.apache.org/jira/browse/DRILL-1249 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON > Affects Versions: 0.4.0 > Environment: 5-node Hadoop cluster (MapR 3.1.1) > Reporter: Andy Pernsteiner > Assignee: DrillCommitter > Priority: Critical > Fix For: 0.5.0 > > Attachments: DRILL-1249.1.patch.txt > > > This may be related to DRILL-1239 > With a JSON file that has the following contents: > {code} > {"trans_id":0,"date":"10/24/2012","time":"06:14:07","cust_id":3,"device":"IOS5","state":"nj","camp_id":4,"keywords":["the"],"prod_id":[],"purch_flag":"true"} > {"trans_id":1,"date":"06/07/2013","time":"12:29:37","cust_id":111464,"device":"IOS5","state":"va","camp_id":4,"keywords":[],"prod_id":[78,116,18,508,28,309,149,80,360,6,28,52,235],"purch_flag":"false"} > {"trans_id":2,"date":"05/16/2013","time":"04:55:41","cust_id":2817,"device":"IOS5","state":"sc","camp_id":10,"keywords":[],"prod_id":[179,247],"purch_flag":"false"} > {"trans_id":3,"date":"06/03/2013","time":"08:14:23","cust_id":14085,"device":"IOS6","state":"oh","camp_id":6,"keywords":["steal"],"prod_id":[510,142,18],"purch_flag":"false"} > {"trans_id":4,"date":"04/10/2013","time":"06:32:31","cust_id":1044,"device":"IOS6","state":"il","camp_id":16,"keywords":[],"prod_id":[25,28,316],"purch_flag":"false"} > {"trans_id":5,"date":"07/27/2013","time":"10:02:24","cust_id":13,"device":"IOS5","state":"oh","camp_id":4,"keywords":["town","you"],"prod_id":[4,1,79,449],"purch_flag":"false"} > {code} > Performing a select w/ a LIMIT throws an error if the LIMIT lines up with a > null value (I think): > {code} > 0: jdbc:drill:> select * from click.`json_small`.`small.json` limit 1; > Error: exception while executing query: null (state=,code=0) > {code} > If I re-run the query with a larger limit I don't hit the error: > {code} > 0: jdbc:drill:> select * from click.`json_small`.`small.json` limit 2; > +------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+ > | trans_id | date | time | cust_id | device | state > | camp_id | keywords | purch_flag | prod_id | > +------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+ > | 0 | 10/24/2012 | 06:14:07 | 3 | IOS5 | nj > | 4 | ["the"] | true | [] | > | 1 | 06/07/2013 | 12:29:37 | 111464 | IOS5 | va > | 4 | [] | false | > [78,116,18,508,28,309,149,80,360,6,28,52,235] | > +------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+ > 2 rows selected (0.223 seconds) > {code} > Note that the first record contains a null value for the prod_id array. -- This message was sent by Atlassian JIRA (v6.3.4#6332)