[DRILL-1097] Sqlline seems to have issues with null values in hive table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.5.0
• Component/s: Client - CLI
• Assignee: Venki Korukanti
• Reporter: Ramana Inukonda Nagaraj
• Created: 02/Jul/14 17:59
• Updated: 05/Aug/14 21:29
• Resolved: 05/Aug/14 21:29

Description

Accessing a hive table from sqlline, Query succeeds when executed through jdbc test framework or through submitplan. Fails with an assert when executed through sqlline.

java.lang.AssertionError: Tried to get null value
at org.apache.drill.exec.vector.NullableTimeStampVector$Accessor.get(NullableTimeStampVector.java:299)
at org.apache.drill.exec.vector.accessor.NullableTimeStampAccessor.getTimestamp(NullableTimeStampAccessor.java:100)
at org.apache.drill.exec.vector.accessor.NullableTimeStampAccessor.getObject(NullableTimeStampAccessor.java:95)
at org.apache.drill.jdbc.AvaticaDrillSqlAccessor.getObject(AvaticaDrillSqlAccessor.java:136)
at net.hydromatic.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:336)
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)

Issue Links

• is duplicated by: DRILL-1186 NullableTimeStampAccessor asserts and returns wrong value when the value is null