[
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)
