[jira] [Created] (DRILL-1558) Count() does not work on JSON (and JSON-converted-Parquet)

["Abhishek Girish (JIRA)" <ji...@apache.org>]

Abhishek Girish created DRILL-1558:
--------------------------------------

             Summary: Count(<ArrayColumn>) does not work on JSON (and JSON-converted-Parquet)
                 Key: DRILL-1558
                 URL: https://issues.apache.org/jira/browse/DRILL-1558
             Project: Apache Drill
          Issue Type: Bug
          Components: Metadata
            Reporter: Abhishek Girish


Works:
> select count(`type`) from yelp_academic_dataset_review;
+------------+
|   EXPR$0   |
+------------+
| 1125458    |
+------------+
1 row selected (0.065 seconds)

Fails:
> select count(`votes`) from yelp_academic_dataset_review;
+------------+
|   EXPR$0   |
+------------+
| 0          |
+------------+

> select count(`votes[0]`) from `yelp_academic_dataset_review.json`;
+------------+
|   EXPR$0   |
+------------+
| 0          |
+------------+
1 row selected (116.563 seconds)

> select count(`votes[1]`) from `yelp_academic_dataset_review.json`;
+------------+
|   EXPR$0   |
+------------+
| 0          |
+------------+
1 row selected (138.264 seconds)

> select count(`votes[0]`) from yelp_academic_dataset_review;
+------------+
|   EXPR$0   |
+------------+
| 0          |
+------------+
1 row selected (0.118 seconds)

> select count(`votes[1]`) from yelp_academic_dataset_review;
+------------+
|   EXPR$0   |
+------------+
| 0          |
+------------+
1 row selected (0.061 seconds)

Sample data:
+------------+------------+------------+------------+------------+------------+------------+-------------+
|   votes    |  user_id   | review_id  |   stars    |    date    |    text    |    type    | business_id |
+------------+------------+------------+------------+------------+------------+------------+-------------+
| {"funny":0,"useful":0,"cool":0} | 3MSa_fdxgsaY9yF9vqmeUg | ag1fnnEmc2yernTW2ur2eg | 5          | 2010-09-07 | Great food and service | review     | KPoTixdjoJxSqRSEApSAGg |
| {"funny":0,"useful":0,"cool":0} | f3LA83yEEBMj9q92H28O7w | LNW2d7TDLB7XHT-V8k-6Jg | 4          | 2010-09-08 | I haven't been in a while but I remember being impressed.  Nice amb |
| {"funny":0,"useful":0,"cool":0} | SaC2fZjZZfWV-8wYb6o6fw | 449K7FhWs5Hn1xB1Qv8KPw | 4          | 2010-09-18 | Finally got to eat at this place after driving by so many times.  I |
| {"funny":0,"useful":0,"cool":0} | Sg9eHImUp1DMYhY7gA2img | yjEOpYaOnahtzCHBzY6KUg | 3          | 2010-09-27 | It was fine.  A fine thai meal to have before a rock show downtown. |




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)