KNIME Analytics Platform 4.1

KNIME Analytics Platform 4.1.1

Release date: February 05, 2020

Enhancements

  • AP-13403: Line Reader should allow user to specify encoding
  • AP-13401: Support new Google API specific endpoints
  • AP-13300: Power BI: Support refreshing an existing dataset
  • AP-13228: Power BI: Save unused dialog options to keep them in the dialog
  • AP-12990: Power BI node - specify error message
  • AP-12891: Send to Power BI: Take care of API limitations

Bug Fixes

  • BD-1003: (Big Data Extensions): Table to Spark node fails on Spark Jobserver when connecting from Windows
  • AP-13588: Excel Writer node refuses write to mountpoint when running on KNIME Server (new file handling)
  • AP-13574: Credentials Input node doesn't work when used in job pool on KNIME Server
  • AP-13564: Ranger Slider Widget fails with certain settings, it did not in 4.0.2 (tested)
  • AP-13555: knime.in cannot be properly initialized if model input contains variables named F
  • AP-13554: Labeling Widget has wrong warning message
  • AP-13552: ClassCastException instead of error message when streamed component contains metanode
  • AP-13533: RXN/RD Reader execution fails while reading rd files with more than one reaction
  • AP-13527: IllegalArgumentException when reading from Custom URL that contains spaces
  • AP-13526: Power BI: Fix tracking if authentication is in progress
  • AP-13525: Amazon Authentication and S3 Connection node cannot be configured to use credentials
  • AP-13519: Credentials Widget can not deserialize view value
  • AP-13517: Line Reader node has resource leak
  • AP-13486: Silhouette Coefficient: returns "NaN" as mean silhouette coefficient for some clusters
  • AP-13480: Our Windows fix for Eclipse not doing horizontal scrolling needs improving
  • AP-13399: EXAMPLE and My-KNIME-Hub mountpoints not browseable revised reader/writer nodes
  • AP-13398: Kerberos logging does not capture messages logged to standard out
  • AP-13384: Replacing node via Drag and Drop swaps connections
  • AP-13362: Reading files from folder in new file reader dialog component reads files in filesystem-dependent order
  • AP-13361: Default position of output ports bar in metanodes shifted to the to right after upgrade to 4.1
  • AP-13358: Label view produces String '?' instead of true missing values in output column
  • AP-13356: Label view 'clear selection' button only visually de-selects tiles
  • AP-13354: Column Filter Widget is not displayed in node view for tables with many columns
  • AP-13353: Fix ui glitches in the labeling view
  • AP-13348: Deprecated Excel Writer/Sheet Appender nodes fail with InvocationTargetException
  • AP-13347: Google Cloud and BigQuery scopes should not be available in Google Authentication node
  • AP-13346: File Download Widget blocks workflow when file does not exist
  • AP-13341: Sometimes the second tile of the label view is initially selected instead of the first tile
  • AP-13325: Streamable source nodes are not correctly flagged as such anymore in node repo
  • AP-13318: NullPointerException when loading workflows with String flow variables of value null
  • AP-13316: H2O Integration: Partitioning node handles incorrectly an input column named "split"
  • AP-13309: MDF Reader: Linear integer interpolation option not respected
  • AP-13303: Webpage Retriever fails with NAMESPACE_ERR
  • AP-13292: Incompatibility of 'Binary Objects to Files' with network shares
  • AP-13291: FilterPanel Dialog does not restore FilterExpression
  • AP-13283: (Linux, certain flavors only:) AP potentially crashes when multiple components are opened
  • AP-13282: File systems requiring absolute paths should show error when relative path is provided
  • AP-13281: Opening component from hub claims in a message that it's showing a remote workflow... but it's a component
  • AP-13278: Details text to "KNIME Extension providing Chromium" states wrong version
  • AP-13267: Missing mountpoint causes NullPointerException
  • AP-13203: Error when saving workflow that contains a previously executed node with internal tables in an inactive branch
  • AP-13125: Naive Bayes Predictor fails with "Mean hasn't been calculated" when data contains infinity
  • AP-12676: H2O Integration: Race condition during partitioning
  • AP-12656: Word metanode still used when checking if update available
  • AP-11953: H2O Integration: DistributedException during parallel predictions
  • AP-11873: "Normalizer", "Transformation", and "PCA" Ports Not Available in Component Reconfiguration Dialog

KNIME Analytics Platform 4.1.0

(see highlight summary)

Release date: December 06, 2019

New node

  • AP-8200: Send to Power BI
  • AP-8088: Google BigQuery Connector
  • AP-9465: Google Cloud Storage (2 nodes)
  • BD-963: Create Databricks Environment
  • BD-961: Databricks File System Connection
  • AP-12995: Integration of Amazon Personalize services
  • AP-13290: MDF Reader -- Measurement Data Format
  • AP-12705: Split Density Scorer into Updater and Scorer
  • AP-12703: Add Active Learning Loop
  • AP-11817: H2O Integration: Add H2O MOJO Predictor (Isolation Forest) node
  • AP-12694: Excel Writer (new file handling)
  • AP-12688: Excel Reader (new file handling)
  • AP-13051: Line Reader (new file handling)
  • AP-12652: Weak Label Model Learner and Predictor
  • AP-10631: Run R Model in Microsoft SQL Server (new db framework)
  • AP-12324: Nominal Probability Distribution Creator and Splitter
  • AP-12189: DB Connection Closer
  • AP-11954: DB Connection Extractor
  • AP-10256: Amazon Athena Connector (new)
  • AP-12788: Webpage Retriever
  • AP-7928: Silhouette Coefficient
  • AP-12336: Top K Selector Node
  • AP-11964: Row Filter (Labs) -- supporting multiple, more advanced search criteria
  • BD-735: Vertica Connector (new)

Enhancements

  • AP-13232: Ensure a menu item for the Node Monitor in the View menu
  • AP-13219: Add option to Boolean Widget and Configuration nodes to push flow variable of type boolean
  • AP-13066: Select background when opening a component
  • AP-13049: Add success message after successfull deployment of preferences
  • AP-13038: Component metadata editor
  • AP-12998: Show DB Meta Data Browser in DB Table Selector when custom query is enabled
  • AP-12988: Make input ports of concatenate node configurable
  • AP-12959: Add visual indicator for nodes whose ports are configurable
  • AP-12953: Show "Recent Workflows" under "File" menu
  • AP-12947: Pass NodeCreationConfiguration to createNodeDialogPane
  • AP-12945: Allow to disable DB Data port in DB Manipulation nodes
  • AP-12943: Support none local KNIME URL resolving in JDBC parameters
  • AP-12939: Allow earlier garbage collection of cached tables
  • AP-12928: Allow garbage collection of in-memory tables that are being iterated over
  • AP-12881: Text Processing: Arabic language support
  • AP-12809: Enable flow variables of type boolean, long, array for Table Row/Column to Variable and Variable to Table Row/Column node
  • AP-12786: Implement new File Handling Port Type
  • AP-12783: Implement Nominal Probability Distributions with Metadata
  • AP-12747: Support Probability Distribution Values in Uncertainty Scorer Nodes
  • AP-12746: Modify NodeFactoryClassMapper to expose mappings
  • AP-12744: Suggest URL template for known db types
  • AP-12740: Component editor with example data
  • AP-12706: Probability Distribution Creator: One-hot encoding of String columns
  • AP-12665: Create Temp Directory node should create directory inside workflow
  • AP-12660: Implement responsive design for welcome page
  • AP-12657: Support TLS1.2 in the Send Email node
  • AP-12651: Label model: Calculate covariance matrix in KNIME
  • AP-12650: Support probabilistic Inputs in the Label Model
  • AP-12645: Table Reader Node to have timeout option (important when reading from remote resources)
  • AP-12643: Improved JDBC URL template UI
  • AP-12636: DB transaction management including Start and End Transaction node
  • AP-12615: Rank/Linear Correlation: save p-value and degrees of freedom in correlation model
  • AP-12567: Configurations and Widgets: improve error message on variable name starting with "knime"
  • AP-12561: Support loading of a native library per user defined JDBC driver
  • AP-12553: Cache static model contents of density scorer models
  • AP-12531: Untangle Testing Framework feature
  • AP-12514: Let Label Model output probabilistic labels
  • AP-12503: Workflow migration tool tooltip
  • AP-12482: Write code-base allowing to add/remove ports to/from standard nodes
  • AP-12480: Allow multiple table views within one view
  • AP-12473: CSV Writer: Make comment header indentation optional
  • AP-12463: Switching to "Welcome Page" should clear Description View
  • AP-12462: Restrict metadata editor link types via pulldown
  • AP-12338: Rewrite Potential Uncertainty Scorer Node
  • AP-12325: Custom Renderer for Probabilistic Labels
  • AP-12323: Probability Distribution Cell
  • AP-12308: Revise Exploration/Exploitation Scorer (Rename to Exploration/Exploitation Score Combiner)
  • AP-12306: Rewrite Graph Density Uncertainty Scorer Node
  • AP-12296: Enhance Logistic Regression to support a probabilistic target column
  • AP-12295: Enhance Gradient Boosted Trees to support a probabilistic target column
  • AP-12294: Revise Uncertainty Scorer Nodes
  • AP-12241: Change default settings of the Partitioning nodes
  • AP-12194: Add flow variable support to DB Table Selection component
  • AP-12120: Drag'n'drop of workflow from Hub
  • AP-11962: Allow to disable DB connection recreation on workflow loading
  • AP-11949: Improve node description of the Feature Selection Loop Start nodes
  • AP-11943: Improved error messaging on Components (e.g. when contained nodes are not fully connected or fail on execution)
  • AP-11916: Remove annotation border menu and toolbar items for node annotations
  • AP-10906: H2O Integration: Support MOJOs of category 'Ordinal'
  • AP-10119: H2O Integration: Add option to treat unknown categorical values as NA to MOJO predictors
  • AP-10030: Rank/Linear Correlation: show p-values and number of cases for each correlation
  • AP-9891: Improve usability of Zooming
  • AP-9722: Add more space to the workbench to the bottom and right (additional space when moving or adding nodes)
  • AP-9338: JavaScript Line Plot with option to start x and y axis at 0 and not at minimum
  • AP-8357: H2O Integration: Improve tool tips of H2O ports and labels/layout in H2O frame view
  • AP-7165: K-Means: Add option to randomly select initial centroids
  • AP-6747: List Remote Files: Update Node Description
  • AP-5550: PMML Predictor should output probabilities and allow change of prediction column name
  • AP-3201: Additional flow variable types for boolean, long, and arrays
  • BD-987: (Big Data Extensions): Allow custom configuration keys in custom Spark settings of the Livy node
  • BD-978: (Big Data Extensions): Support user name and password authentication in Create Spark Context (Livy) node e.g. to connect to Azure HDInsight
  • BD-971: (Big Data Extensions): Support Livy 0.6 in KNIME
  • BD-949: (Big Data Extensions): Persistently save and display Kerberos username
  • BD-766: (Big Data Extensions): Implement fallback solution for ORC/Parquet reader
  • BD-121: (Big Data Extensions): Add support for KNOX to Create Spark Context (Livy) node
  • BD-120: (Big Data Extensions): Add WebHDFS via KNOX Connector node
  • BD-119: (Big Data Extensions): Add support for KNOX to Hive Connector node

Bug Fixes

  • AP-13152: Unable to parse container.compression property Gzip (on system with Turkish Locale)
  • AP-13058: PCA node fails when large number of input columns are present
  • AP-12931: SSH Connection does not resolve ~ on linux updating to 4.0
  • AP-13234: KNIME doesn't open with empty workspace (CentOS 6)
  • AP-13230: Naive Bayes Model handles derived fields incorrectly
  • AP-13224: PMML Transformation Applier fails when no TransformationDictionary is present
  • AP-13222: PMML Transformation Applier fails to apply missing value and/or normalization model
  • AP-13213: Slider Widget loads with JS error
  • AP-13194: Metanode disappears when converting to component
  • AP-13191: Right click on empty canvas does not deselect component
  • AP-13183: NullPointerException when closing Parquet Table Store Reader
  • AP-13156: Math Formula (Multi Column) does not seem to work with certain column names
  • AP-13127: Git Push node: Push tags checkbox in config dialog not configurable
  • AP-13120: Column/Variable Expressions: Function selection dialog stays open after closing configuration dialog
  • AP-13112: Column Filter configuration validation does not import options created in 4.0
  • AP-13097: NullPointerException when loading Workflow with Excel Reader node that reads from Amazon S3
  • AP-13096: Writing files to custom URL fails
  • AP-13081: Close component metadata editor when left
  • AP-13077: Edit "icon" missing when stepping into component after it has been unlinked
  • AP-13075: Excel Writer has option to save file relative to workflow, but does not seem to support it
  • AP-13070: Column Filter Configuration filters out all columns if the dialog is never opened
  • AP-13032: Loading org.knime.ext.ssh bundle slows KNIME start drastically (class traversal issue)
  • AP-13025: Gradient Boosted Trees to PMML produces invalid PMML in some cases
  • AP-13005: Support setting alpha and beta to 0 for Tversky Distance
  • AP-12980: DB manipulation nodes (Insert, Update, Merge, Delete, Writer) do not work in loops
  • AP-12960: BarChart highlights wrong row on selection
  • AP-12933: Range Slider Filter Definition Node has rounding errors
  • AP-12893: Flow Variable should be spelled correctly in the node port type
  • AP-12892: Node annotation toolbar doesnt disappear when switching windows
  • AP-12865: Custom URL does not work with file scheme
  • AP-12864: DB Reader throws duplicate key exception when reading multiple binary columns
  • AP-12860: Typo in Update Components dialog
  • AP-12843: Pie/Donut Chart can't be configured if Number type column is not present in table
  • AP-12781: CSS styling not working for SVG output of Plotly nodes
  • AP-12720: Random Forest progress seems stuck during the creation of the final trees
  • AP-12712: Choosing KNIME FileSystem causes the Dialog to resize so that Browse Button is not visible
  • AP-12675: Windows Eclipse 4.7 does not support horizontal scrolling via scrollwheel
  • AP-12670: Missing Value node description incorrect
  • AP-12616: Rank Correlation: Rank output should be of type long not double
  • AP-12613: Scroll bar resizes during scrolling in H2O and Spark table views for large datasets
  • AP-12606: When selecting <RowID> for the axis column in the Line Plot (Plotly) it fails when executing
  • AP-12526: Wrong port color displayed for BufferedDataTable ports on components
  • AP-12523: Table Difference Checker ignores domain order
  • AP-12520: Mouse goes to upper left corner during loading of streamable nodes
  • AP-12519: Color legend too small on Plotly Bubble Chart node
  • AP-12515: New database feature added to knime-ap target platform
  • AP-12220: Drag'n'drop problem with Image Processing nodes from Hub to AP
  • AP-12109: Update File Reader node description
  • AP-12079: Python: stderr messages should be logged to INFO unless they're warnings
  • AP-12062: DB Connector node: Database URL (if long) is not moving together with the cursor to the end of the URL
  • AP-11929: KNIME types without a mapping rule are shown in the Source Type dropdown box
  • AP-11525: Stacked Area Chart assigns colors based on column order instead of column name
  • AP-11269: Executed Keras Input Layer doesn't work after upload and download from server
  • AP-10907: Support cancellation of fetch unique values query in DB Row Filter
  • AP-10032: Remove duplicates in node repository
  • AP-9290: Streamable Metanode can be reset during execution
  • AP-9284: Problem restoring file store cells on re-loaded of executed and streamed component
  • AP-6364: Empty Table Switch fails in streamed node
  • AP-6192: Streaming Wrapped nodes fails with NPE in inactive Branch
  • BD-988: (Big Data Extensions): DB Loader for Hive has problems with input KNIME tables that have non-word characters in their name
  • BD-983: (Big Data Extensions): H2O nodes do not show string columns on Sparkling Water

General Release Notes

Developers of community and other custom extensions should pay attention to the following:

  • Testing framework restructured into different repositories (contact us if you have dependencies to; org.knime.testing, org.knime.testing.headless, org.knime.testing.ui, or org.knime.js.testing)
  • Interested in using the dynamics ports feature mentioned above? Have a looked at the Concatenate Node.
  • The new flow variable API (as per AP-12809) focuses on extensibility and takes care of maintaining backwards compatibility. It enables the implementation of custom flow variable types by extending an abstract class. (Currently!) available types are defined here, usage in individual nodes are done following these methods (1, 2)