Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problem with sorting CSV input

  1. #1

    Default Problem with sorting CSV input

    Hi,

    I am trying to read a csv file and afterwards sort the entries (with uniqe rows option), but i'm getting the following error:

    2008/11/17 12:12:14 - Sort rows.0 - Starting quickSort algorithm...
    2008/11/17 12:12:14 - Sort rows.0 - The number of binary string to data type conversions done in this sort block is 0
    2008/11/17 12:12:14 - Sort rows.0 - QuickSort algorithm has finished.
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Unexpected error :
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : org.pentaho.di.core.exception.KettleValueException:
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : client_id String<binary-string> : There was a data type error: the data type of java.lang.String object [104NO58OUV25N2U0NN] does not correspond to value meta [String<binary-string>]
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) :
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1322)
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:181)
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:579)
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.trans.steps.sort.SortRows.processRow(SortRows.java:420)
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
    2008/11/17 12:12:14 - Sort rows.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : at org.pentaho.di.trans.steps.sort.SortRows.run(SortRows.java:566)
    2008/11/17 12:12:14 - CSV file input 2.0 - Stopped while putting a row on the buffer


    All the input fields are string. and the preview works ok . Any idea what i might be doing wrong ?

    thx

  2. #2

    Default

    nevermind...problem solved: lazy conversion was checked in the input csv :">

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.