Row FIlter/Splitter/Rule-Based cannot process SMILES

KNIME Analytics Platform
1

Previous versions of these nodes used to allow for string filtering using RegEx on SMILES columns and now this is not possible. Please can this functionality be restored.
Thanks.
Simon.

2

Hey there,

cannot comment on KNIME’s plans to re-introduce this to the node versions in modern UI - that said given backwards compatibility you can still use the “old” nodes.

In modern UI simply type the node name into the search field followed by “//deprecated” - e.g.:

row filter //deprecated

And the “old versions” should show up with the (deprecated) tag at the end:

image

5 Likes
3

Hello @richards99,

May I ask what version of KNIME AP you are running? The functionality you are asking for should be a part of the Row Filter since KNIME AP versions 5.3.2 and 5.4.0.

image
image1042Ă—742 44.1 KB

  • Marc
4

Hi, I’m on the latest 5.4 release and using this on a Mac.
The options are there in the drop down of the node for RegEx etc, but when I try to run the node it fails.

5

So when I choose RegEx and put a value in, I can click OK on the node, and then when I run it I get this error;
ERROR Row Filter 3:3426 Execute failed: (“ClassCastException”): null

This is where a Molecule column started off as String Format (of SMILES) from a CSV import, and was recast to SMILES using the Molecule Type Cast node. Row Filter node then applied directly after this.

Simon.

6

Hello @richards99 ,
I’m using version 5.4.3 on Windows. In the simple case bellow, thte regex seems to work with SMILES. What happens if you apply the row filter to the string format before casting? After that, I wonder if casting the filtered string to SMILES format would work well.

[Apply row filter to SMILES format after casting]

image
image1263Ă—739 132 KB

[Apply row filter String format before casting]

image
image1189Ă—693 124 KB

7

The filtering works fine when the filtering is applied before casting. It is just after casting where the problem is. I’m wondering if this is an Apple Mac issue.

8

@richards99 is there more in the knime.log than?

ERROR Row Filter 3:3426 Execute failed: (“ClassCastException”): null

It should not fail with this exception, so I consider it a bug.

9

@richards99 thanks so much for reporting! We actually found a bug (and fix) in the chemistry types (an assumption about the KNIME type system, that the Columnar backend needs but the Row backend does not, and which the chemistry types violate).

I can make it succeed on macOS if I use the Row backend and fail for the Columnar backend.

1 Like
10

Great that makes sense as I do have the columnar backend on as default. I will change it to row for now. Thanks for identifying the cause of the bug.
Simon.

11

The internal ID is AP-24512, I’ll get it backported to 5.4 as well. There should be a notification here when a fix is released.

1 Like
12

Internal ticket ID: AP-24512
Summary: Chemistry type value factories do not adhere to KNIME type system contract
Fix version(s): 5.4.5, 5.5.0