Date Filter doesn't Work

KNIME Analytics Platform
1

Hi,

I’m trying to filter by the Column Type “Date and Time”.
My whole Workflow is in Spark. It doesn’t matter whether i filter with a PySpark Script or Spark SQL Query. The Error, which I’m getting when trying to cache no.of rows is the same.

The Error, which I am getting is: Unexpected parameters (date, varchar(10)) for function $operator$less_than_or_equal. Expected: $operator$less_than_or_equal(T, T) T:orderable (FailureException)

image

PySpark_Script
PySpark_Script1237×762 35.5 KB

Spark_SQL_Query
Spark_SQL_Query1056×203 9.97 KB

2

Hi it seems working this way
tests2.knwf (50.7 KB). Beware of types.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.