Hi,
while preparing an example workflow for knowledge sharing, trying to auto cast the type of aa table with unknown values, this error was thrown:
ERROR Column Auto Type Cast 3:1623:0:1585 Execute failed: class org.knime.core.data.def.LongCell cannot be cast to class org.knime.core.data.StringValue (org.knime.core.data.def.LongCell and org.knime.core.data.StringValue are in unnamed module of loader org.eclipse.osgi.internal.loader.EquinoxClassLoader @de63949)
I want to suggest to allow the Column Auto Type Cast Node to skip columns it fails to process by adding n option to error out or just warn.
| true | true | true | NaN | NaN | NaN | PT0S | 2147483647 | 2147483647 | 2147483647 | -999999999-01-01 | -999999999-01-01T00:00 | 00:00 | 9223372036854775807 | NaN | 9223372036854775807 | 9223372036854775807 | semicolon;semicolon | ? | ? | ? | P0D | 0 | semicolon;semicolon | semicolon;semicolon | semicolon;semicolon | 2021-04-11T19:37:07.665 | 2021-04-11T19:37:07.665 | 2021-04-11T19:37:07.665 | URI: http://rsvimcfngtmtgtc; EXT: | URI: http://jsrtcsegmwgbpka; EXT: | URI: http://shjoryrxjeccelf; EXT: | -999999999-01-01T00:00+00:53:28[Europe/Berlin] |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| false | true | true | -Infinity | -Infinity | -Infinity | PT0.000000059S | -2147483648 | -2147483648 | -2147483648 | +999999999-12-31 | +999999999-12-31T23:59:59.999999999 | 23:59:59.999999999 | -9223372036854775808 | -Infinity | -9223372036854775808 | -9223372036854775808 | backslash\bakslash | ? | ? | ? | P59D | 1 | backslash\bakslash | backslash\bakslash | backslash\bakslash | 1970-01-01T00:00:00.0 | 1970-01-01T00:00:00.0 | 1970-01-01T00:00:00.0 | URI: https://C:/najmrakldxxnodm.csv; EXT: csv | URI: https://C:/aabditdtihpkbam.csv; EXT: csv | URI: https://C:/bwapkkekhyxkhbp.csv; EXT: csv | +999999999-12-31T23:59:59.999999999+01:00[Europe/Berlin] |
| true | true | true | -0.42916606780356525 | -0.5049963757996139 | -0.9995785084319507 | PT0.00000002S | 1085367651 | -1062049934 | -1120828560 | 2021-04-11 | 2021-04-11T22:28:20.765 | 22:28:20.765 | 2034213130788453791 | -0.08988914492464295 | 7724047385755175226 | 7702735761263663848 | ? | ? | ? | P20D | 10 | 4000-02-01T00:01:01.0 | 4000-02-01T00:01:01.0 | 4000-02-01T00:01:01.0 | URI: file://C:/hgueyulfdrilnoo.xml; EXT: xml | URI: file://C:/bqctwqdokgksxjh.xml; EXT: xml | URI: file://C:/kbqkpxtxlodetvy.xml; EXT: xml | 2021-04-11T22:28:20.765+02:00[Europe/Berlin] |
Original table definition
| StringCol | String |
|---|---|
| StringListCol | String |
| StringSetCol | String |
| IntCol | Number (integer) |
| IntListCol | String |
| IntSetCol | String |
| LongCol | Number (long) |
| LongListCol | String |
| LongSetCol | String |
| DoubleCol | Number (double) |
| DoubleListCol | String |
| DoubleSetCol | String |
| TimestampCol | Date and Time |
| TimestampListCol | String |
| TimestampSetCol | String |
| BooleanCol | Boolean value |
| BooleanListCol | String |
| BooleanSetCol | String |
| UriCol | URI |
| UriListCol | String |
| UriSetCol | String |
| MissingValStringCol | String |
| MissingValStringListCol | String |
| MissingValStringSetCol | String |
| LongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnNameLongStringColumnName | String |
| LongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnNameLongDoubleColumnName | Number (double) |
| Local Date | Local Date |
| Local Time | Local Time |
| Local Date Time | Local Date Time |
| Zoned Date Time | Zoned Date Time |
| Period | Period |
| Duration | Duration |
| RowIndex | Number (long) |
Best
Mike