[
https://issues.apache.org/jira/browse/DRILL-1714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanifi Gunes updated DRILL-1714:
--------------------------------
Description:
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}
was:
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}
> 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)
