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

ResultSet getObject method throws not implemented exception if the column type is NULL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.15.0
    • Fix Version/s: 1.17.0
    • Component/s: None
    • Labels:

      Description

      This method is used by some tools, for example DBeaver. Not reproduced with sqlline or Drill Web-UI.

      Query:

      select coalesce(n_name1, n_name2) from cp.`tpch/nation.parquet` limit 1;
      

      Expected result:
      null

      Actual result:
      Exception is thrown:

      java.lang.RuntimeException: not implemented
      	at oadd.org.apache.calcite.avatica.AvaticaSite.notImplemented(AvaticaSite.java:421)
      	at oadd.org.apache.calcite.avatica.AvaticaSite.get(AvaticaSite.java:380)
      	at org.apache.drill.jdbc.impl.DrillResultSetImpl.getObject(DrillResultSetImpl.java:183)
      	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCResultSetImpl.getObject(JDBCResultSetImpl.java:628)
      	at org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCObjectValueHandler.fetchColumnValue(JDBCObjectValueHandler.java:60)
      	at org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCAbstractValueHandler.fetchValueObject(JDBCAbstractValueHandler.java:49)
      	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetDataReceiver.fetchRow(ResultSetDataReceiver.java:122)
      	at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.fetchQueryData(SQLQueryJob.java:729)
      	at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.executeStatement(SQLQueryJob.java:465)
      	at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.lambda$0(SQLQueryJob.java:392)
      	at org.jkiss.dbeaver.model.DBUtils.tryExecuteRecover(DBUtils.java:1598)
      	at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:390)
      	at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.extractData(SQLQueryJob.java:822)
      	at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:2532)
      	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:93)
      	at org.jkiss.dbeaver.model.DBUtils.tryExecuteRecover(DBUtils.java:1598)
      	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:91)
      	at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:101)
      	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                angozhiy Anton Gozhiy
                Reporter:
                angozhiy Anton Gozhiy
                Reviewer:
                Bohdan Kazydub
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: