Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: What specific versions of MS SQL Server are suppported?

  1. #1

    Default What specific versions of MS SQL Server are suppported?

    The reason I ask is that SQL Server Personal Edition (8.00.194 (RTM)) may have an issue under KETTLE. When I attempt to use a table input step to retrieve a column which is of type float or decimal KETTLE interprets the field as an integer.

  2. #2
    Join Date
    Nov 1999
    Posts
    459

    Default RE: What specific versions of MS SQL Server are suppported?

    Hi Marc,

    all versions of MS SQL including 2005 are supported - but:

    There is a generall issue with the handling of float and some decimals. This concerns all DBs, we are solving this soon.

    Thanks for the feedback,
    Jens

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: What specific versions of MS SQL Server are suppported?

    Interesting, the first time I hear of this...
    Jens, were are these problems situated?

  4. #4
    Join Date
    Nov 1999
    Posts
    459

    Default RE: What specific versions of MS SQL Server are suppported?

    Hi Matt,

    just added a KETTLE - Tracker: Change Request - [# 2035] Optimize field type conversion of DECIMAL, DOUBLE, FLOAT, REAL, NUMERIC

    Cheers,
    Jens

  5. #5

    Default RE: What specific versions of MS SQL Server are suppported?

    There is a work around for this in the meantime. Cast the float values to VARCHAR in the SQL statement.

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.