CODEWITHSUNDEEP
linuxpentahopentaho-spoonpentaho-data-integration
Hemanth S. Vaddi
Hemanth S. Vaddi

Reputation: 483

Pentaho: Binary file (standard input) matches

When I'm trying to use MySQL in Table input with an order by in the query, I'm getting below error and ETL stops abruptly.

Binary file (standard input) matches

If I remove order by in the query, it works. Is this a bug in Pentaho? And, it occurs only in Linux Environment

I'm using Pentaho 8.1.0.0 CE
OS: Ubuntu 16.04.4 LTS
MySQL Driver version: mysql-connector-java-5.1.46.jar

Upvotes: 0

Views: 1308

Answers (2)

olegueret
olegueret

Reputation: 370

This happened to me also in Ubuntu 16.04 and PDI 8.1 (although it worked fine in Windows 10 and PDI 8.1)

In my case happened by a step that had an accent in the name.

Try to keep the names of the steps simple, without accents or any other fancy characters.

Upvotes: 0

Gustavo Lima
Gustavo Lima

Reputation: 26

Checks whether the select is returning a zero date 0000-00-00 00:00:00

If so, add the property zeroDateTimeBehavior=convertToNull in the JDBC parameters

Upvotes: 1

Related Questions