Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Step Null If return error java.lang.Double can not be cast to [B

  1. #1
    Join Date
    Dec 2016
    Posts
    2

    Unhappy Step Null If return error java.lang.Double can not be cast to [B

    I am importing a text file with a numeric column that I defined as being Number (14).

    Some records in the file have value "0" (zero, without quotes) and I would like to turn this value into NULL, so I used the "Null If" step, but when I try to perform a preview it returns the error:

    Java.lang.RuntimeException: Unable to verify if [host_document Number (14) <binary-string>] is not or not because of an error: java.lang.ClassCastException: java.lang.Double can not be cast to [B

    I'm having the same problem with fields of type String, but in this case the value in the file can be "-" (dash) or "" (empty string). The error message for the String is identical.

    PS: sorry my english

    Sample file:
    Code:
    1;10395200  ;DL99999;DIV LOGRADOUROS E LOCALIDADES           ;0             ;19860220;19931129
    1;10395400  ;MG05393;-                                       ;0             ;19860331;19931129
    1;10395700  ;MG05439;MURIAE                                  ;0             ;19860716;19931129

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Turn off "Lazy Conversion" in your CSV or Text File Input.

  3. #3
    Join Date
    Dec 2016
    Posts
    2

    Default

    Thank you!! I had not found this information in the forum

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.