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

["Vince Gonzalez (JIRA)" <ji...@apache.org>]

Vince Gonzalez created DRILL-1714:
-------------------------------------

             Summary: 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


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)