org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Date' from database resultset, index 1 Illegal conversion

Pentaho BI Platform Tracking | Geoffrey Cleaves | 2 years ago
  1. 0

    Spoon can't read DATE columns from Hortonworks. If I convert the source column to TIMESTAMP it works fine. hive> desc entrance_summary; OK visits int createdday date createdhour int productid int campaignid int country string devicetype string network string networktypes string osname string ------ Spoon Table Input step: select visits ,createdday ,createdhour ,productid ,campaignid ,country ,devicetype ,network ,networktypes ,osname from entrance_summary limit 10 Error: 2015/03/12 09:25:11 - Spoon - Asking for repository 2015/03/12 09:25:11 - RepositoriesMeta - Reading repositories XML file: Z:\data-integration\repositories.xml 2015/03/12 09:25:11 - Version checker - OK 2015/03/12 09:25:16 - Spoon - Connected to metastore : repo, added to delegating metastore 2015/03/12 11:10:16 - /hadoop/trans_load_hadoop_campaign_offer_conversion_entrance - Dispatching started for transformation [/hadoop/trans_load_hadoop_campaign_offer_conversion_entrance] 2015/03/12 11:10:17 - entrance hadoop input.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unexpected error 2015/03/12 11:10:17 - entrance hadoop input.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2015/03/12 11:10:17 - entrance hadoop input.0 - Couldn't get row from result set 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - Unable to get value 'Date' from database resultset, index 1 2015/03/12 11:10:17 - entrance hadoop input.0 - Illegal conversion 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2357) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2328) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2306) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/03/12 11:10:17 - entrance hadoop input.0 - at java.lang.Thread.run(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2015/03/12 11:10:17 - entrance hadoop input.0 - Unable to get value 'Date' from database resultset, index 1 2015/03/12 11:10:17 - entrance hadoop input.0 - Illegal conversion 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4688) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2852) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2349) 2015/03/12 11:10:17 - entrance hadoop input.0 - ... 6 more 2015/03/12 11:10:17 - entrance hadoop input.0 - Caused by: java.sql.SQLException: Illegal conversion 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.apache.hive.jdbc.HiveBaseResultSet.getTimestamp(HiveBaseResultSet.java:560) 2015/03/12 11:10:17 - entrance hadoop input.0 - at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - at java.lang.reflect.Method.invoke(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$ResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:746) 2015/03/12 11:10:17 - entrance hadoop input.0 - at com.sun.proxy.$Proxy22.getTimestamp(Unknown Source) 2015/03/12 11:10:17 - entrance hadoop input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4670) 2015/03/12 11:10:17 - entrance hadoop input.0 - ... 9 more 2015/03/12 11:10:17 - entrance hadoop input.0 - Finished reading query, closing connection. 2015/03/12 11:10:17 - entrance hadoop input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2015/03/12 11:10:17 - /hadoop/trans_load_hadoop_campaign_offer_conversion_entrance - Transformation detected one or more steps with errors. 2015/03/12 11:10:17 - /hadoop/trans_load_hadoop_campaign_offer_conversion_entrance - Transformation is killing the other steps!

    Pentaho BI Platform Tracking | 2 years ago | Geoffrey Cleaves
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Date' from database resultset, index 1 Illegal conversion
  2. 0

    What prepared statement can do?

    Oracle Community | 1 decade ago | 807551
    java.sql.SQLException: JZ0TC: Attempted conversion between an illegal pair of ty pes.
  3. 0

    Encrypting and inject into database

    Oracle Community | 1 decade ago | 843810
    java.sql.SQLException: JZ0TC: Attempted conversion between an illegal pair of types.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem with jconnect55

    Google Groups | 1 decade ago | Start Software s.r.l.
    java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0TC: Attempted conversion between an illegal pair of types.
  6. 0

    JZ0TE Error Message

    Google Groups | 1 decade ago | odbcpse
    java.sql.SQLException: JZ0TE: Attempted conversion between an illegal pair of ty pes. Valid database datatypes are: 'Double, Float, BigDecimal, Boolean, Integer, Long, byte[], String'

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Illegal conversion

      at org.apache.hive.jdbc.HiveBaseResultSet.getTimestamp()
    2. org.apache.hive
      HiveBaseResultSet.getTimestamp
      1. org.apache.hive.jdbc.HiveBaseResultSet.getTimestamp(HiveBaseResultSet.java:560)
      1 frame
    3. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      3. java.lang.reflect.Method.invoke(Unknown Source)
      3 frames
    4. org.pentaho.hadoop
      DriverProxyInvocationChain$ResultSetInvocationHandler.invoke
      1. org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$ResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:746)
      1 frame
    5. com.sun.proxy
      $Proxy22.getTimestamp
      1. com.sun.proxy.$Proxy22.getTimestamp(Unknown Source)
      1 frame
    6. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4670)
      2. org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086)
      3. org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2852)
      4. org.pentaho.di.core.database.Database.getRow(Database.java:2349)
      5. org.pentaho.di.core.database.Database.getRow(Database.java:2328)
      6. org.pentaho.di.core.database.Database.getRow(Database.java:2306)
      7. org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247)
      8. org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138)
      9. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      9 frames
    7. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame