[
https://issues.apache.org/jira/browse/DRILL-1714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-1714:
----------------------------------
Fix Version/s: 0.7.0
Assignee: Hanifi Gunes
> 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:
> {quote}
> 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
> {quote}
> {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)
