You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/01/05 20:33:34 UTC
[jira] [Updated] (DRILL-1589) count(*) on json fails with exception
[ https://issues.apache.org/jira/browse/DRILL-1589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Hsuan-Yi Chu updated DRILL-1589:
-------------------------------------
Assignee: Sean Hsuan-Yi Chu
> count(*) on json fails with exception
> -------------------------------------
>
> Key: DRILL-1589
> URL: https://issues.apache.org/jira/browse/DRILL-1589
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Neeraja
> Assignee: Sean Hsuan-Yi Chu
> Fix For: Future
>
>
> A simple count(*) query on JSON fails while count(column) works fine.
> Below are the queries.
> 0: jdbc:drill:zk=local> select count(*) from dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json` b
> . . . . . . . . . . . > ;
> Query failed: Screen received stop request sent. You tried to start when you are using a ValueWriter of type NullableVarCharWriterImpl. [23966ff6-7ea9-4c6d-a3c6-0a024cedc972]
> Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
> ------------
> 0: jdbc:drill:zk=local> select count(business_id) from dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json` b;
> +------------+
> | EXPR$0 |
> +------------+
> | 42153 |
> +------------+
> Explain plans are below.
> 0: jdbc:drill:zk=local> explain plan for select count(*) from dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json` b;
> +------------+------------+
> | text | json |
> +------------+------------+
> | 00-00 Screen
> 00-01 StreamAgg(group=[{}], EXPR$0=[COUNT()])
> 00-02 Project($f0=[0])
> 00-03 Scan(groupscan=[EasyGroupScan [selectionRoot=/users/nrentachintal |
> +------------+------------+
> 1 row selected (0.139 seconds)
> 0: jdbc:drill:zk=local> explain plan for select count(business_Id) from dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json` b;
> +------------+------------+
> | text | json |
> +------------+------------+
> | 00-00 Screen
> 00-01 StreamAgg(group=[{}], EXPR$0=[COUNT($0)])
> 00-02 Scan(groupscan=[EasyGroupScan [selectionRoot=/users/nrentachintala/Downloads/yelp_dataset_chall |
> +------------+------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)