Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1097

Sqlline seems to have issues with null values in hive table

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 0.5.0
    • Component/s: Client - CLI
    • Labels:
      None

      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)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vkorukanti Venki Korukanti
                Reporter:
                inramana Ramana Inukonda Nagaraj
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: