[jira] [Comment Edited] (DRILL-2141) Data type error in group by and order by for JSON

["Andries Engelbrecht (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14340566#comment-14340566 ] 

Andries Engelbrecht edited comment on DRILL-2141 at 2/27/15 6:49 PM:
---------------------------------------------------------------------

Sample file attached now.

Issue is more pronounced with larger sample file sizes and larger number of files.

Let me know if you experience the issue, and perhaps we can test on larger environment.


was (Author: aengelbrecht):
Sample file size.

Issue is more pronounced with larger sample file sizes and larger number of files.

> Data type error in group by and order by for JSON
> -------------------------------------------------
>
>                 Key: DRILL-2141
>                 URL: https://issues.apache.org/jira/browse/DRILL-2141
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Data Types
>    Affects Versions: 0.7.0
>            Reporter: Andries Engelbrecht
>            Assignee: Hanifi Gunes
>             Fix For: 0.9.0
>
>         Attachments: FlumeData.1422748800086, drillbit.log, new_drillbit.log
>
>
> When doing group by and oder by on complex nested JSON getting Data type errors.
> Query:
> select t.retweeted_status.`user`.name as name, count(t.retweeted_status.id) as rt_count from `./nfl` t where t.retweeted_status.`user`.name is not null group by t.retweeted_status.`user`.name order by count(t.retweeted_status.id) desc limit 10;
> Screen output:
> Query failed: Query failed: Failure while running fragment., Failure while reading vector.  Expected vector class of org.apache.drill.exec.vector.NullableIntVector but was holding vector class org.apache.drill.exec.vector.NullableVarCharVector. [ c6ea670f-5fa0-491c-acfb-5ccd128ec324 on drilldemo:31010 ]
> [ c6ea670f-5fa0-491c-acfb-5ccd128ec324 on drilldemo:31010 ]
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
> 	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> 	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> 	at sqlline.SqlLine.print(SqlLine.java:1809)
> 	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> 	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> 	at sqlline.SqlLine.dispatch(SqlLine.java:889)
> 	at sqlline.SqlLine.begin(SqlLine.java:763)
> 	at sqlline.SqlLine.start(SqlLine.java:498)
> 	at sqlline.SqlLine.main(SqlLine.java:460)
> Drill log attached



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