Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: PDI 7.1 Sybase IQ 12.7

  1. #1
    Join Date
    Mar 2009
    Posts
    21

    Talking PDI 7.1 Sybase IQ 12.7

    Hi everyone,

    I was wondering if someone could help me with this. I am running on PDI 7.1 (I also tested this on PDI 8.0) a query with a table input step to a Sybase IQ 12.7 DB. If I use a top 1 or top 1000 everything works fine. Even up to top 1000000, but if I remove the top it doesn't do anything. I waited 30 minutes until I decided to cancel it. It seems like this is loading the whole result set in memory before it does anything else. Is it possible to change that?
    I am using jconn3.jar and jconn4.jar and both of them take a long time to start. So far, the only way to get this to work is by using pan.bat. I still have to wait and it sometimes fails as well (I have waited over 1 hour), but at least it sometimes works.

    One last thing I had forgotten to mention was that if I use any SQL query console like DBQuery Analyzer, I get a response in an acceptable time. I use ODBC on DB Analyzer and JDBC on PDI.

    Any ideas?

    Cheers.
    Last edited by lhonores; 03-12-2018 at 10:38 AM. Reason: Additional information

Tags for this Thread

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.