[jira] [Resolved] (DRILL-1714) query fails with AssertionError when querying Yelp business data

["Hanifi Gunes (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hanifi Gunes resolved DRILL-1714.
---------------------------------
    Resolution: Duplicate

The issue is known and relates to mutating field type for "Accepts Credit Card" field. Should be addressed by DRILL-1602

> query fails with AssertionError when querying Yelp business data
> ----------------------------------------------------------------
>
>                 Key: DRILL-1714
>                 URL: https://issues.apache.org/jira/browse/DRILL-1714
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - CLI
>    Affects Versions: 0.6.0
>         Environment: Mac OS X, Java 7, Drill 0.6.0 - dataset: http://www.yelp.com/dataset_challenge
>            Reporter: Vince Gonzalez
>            Assignee: Hanifi Gunes
>             Fix For: 0.7.0
>
>
> The query:
> {code:sql}
> SELECT
>     t.type,
>     t.business_id,
>     t.name,
>     t.neighborhoods,
>     t.full_address,
>     t.city,
>     t.state,
>     CAST(t.latitude AS FLOAT) as latitude,
>     CAST(t.longitude AS FLOAT) as longitude,
>     CAST(t.stars as FLOAT) as stars,
>     CAST(t.review_count as INT) as review_count,
>     t.categories,
>     t.`open` AS is_open,
>     t.hours,
>     t.attributes
> FROM dfs.`/Users/vince/Desktop/data/yelp/yelp_academic_dataset_business.json` AS t
> {code}
> {quote}
> | business   | AnqXhbdkHHimMBR3UMS1Jw | Homewood Suites | []            | 2001 E Highland Avenue
> Phoenix, AZ 85016 | Phoenix    | AZ         | 33.505135  | -112.03801 | 3.5        |  |
> java.lang.AssertionError
> 	at org.apache.drill.exec.vector.VarCharVector$Accessor.get(VarCharVector.java:367)
> 	at org.apache.drill.exec.vector.VarCharVector$Accessor.getObject(VarCharVector.java:393)
> 	at org.apache.drill.exec.vector.NullableVarCharVector$Accessor.getObject(NullableVarCharVector.java:381)
> 	at org.apache.drill.exec.vector.accessor.NullableVarCharAccessor.getObject(NullableVarCharAccessor.java:98)
> 	at org.apache.drill.jdbc.AvaticaDrillSqlAccessor.getObject(AvaticaDrillSqlAccessor.java:136)
> 	at net.hydromatic.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:351)
> 	at sqlline.SqlLine$Rows$Row.<init>(SqlLine.java:2388)
> 	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2504)
> 	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)
> {quote}



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