Hitachi Vantara Pentaho Community Wiki

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Strings have single quotes around them, escaping quotes is not yet supported.
  • Wiki Markup
    Dates have square brackets around them and the following formats are supported: \[yyyy/MM/dd HH:mm:ss.SSS\], \[yyyy/MM/dd HH:mm:ss\] and \[yyyy/MM/dd\]
  • Number and BigNumber should have no grouping symbol and the decimal is . (example 123.45)
  • Integers contain only digits
  • Boolean values can be TRUE or FALSE

Limitations

Besides the obviously plentiful limitations in the support for the SQL standard, there are a few noteworthy things to note:

  • Grouping is done using a "Memory Group By" step which keeps all the groups in memory. If you expect large amounts of groups to be used, watch your memory consumption on the server.  We're using the "memory group by" step to avoid doing a costly sort on the data.
  • Prepared statements are not yet supported which will limit the usefulness of the driver in 3rd party tools.

Future

The following things are next on the agenda:

  • DISTINCT values
  • prepared statements
  • writing to a service transformation (INSERT INTO)