Hitachi Vantara Pentaho Community Wiki
Child pages
  • Updates for BISERVER-2735 (Row Limit, Timeout, Read Only)

Versions Compared

Key

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

...

The components above now accept up to three new "known" optional inputs.

max_rows

Data Type: Integer
Limit: Must be greater or equal to zero

All of the above components look for, and respect the new input max_rows. For SQLBaseComponent/SQLLookupRule, MQLRelationalDataComponent, and HQLBaseComponent/HQLLookupRule, when max_rows comes in as an input, the value is ultimately passed into the JDBC statement object. For XQueryBaseComponent/XQueryLookupRule, the data limiting is performing during document parse. If the underlying JDBC driver does not support this setting, the action sequence will be terminated.

Care should be used when limiting the number of rows returned by a query because the user will never know that the results are being truncated.

timeout

Data Type: Integer
Limit: Must be greater than zero
Scale: seconds

Of the above components, only the JDBC-based components (SQLBaseComponent/SQLLookupRule, MQLRelationalComponent, HQLBaseComponent/HQLLookupRule) provide support for this setting. The query timeout is passed into the underlying JDBC statement object. Queries that take longer than the specified time (in seconds) will fail and an exception will be thrown to the server.

read_only

Data Type: Boolean
Limit: Must be true or false

Of the above components, only the JDBC-based components (SQLBaseComponent/SQLLookupRule, MQLRelationalComponent, HQLBaseComponent/HQLLookupRule) provide support for this setting. The read-only value is passed into the underlying JDBC connection object.