Query regarding Filter Stage

[suchit1983]

Hi,

Can we use BETWEEN in the where clause of a Filter Stage?

I got the following error :

Parse error: Expected between [field/literal] and [field/literal], got: between "CLM_CHK_DT" "("
Parse error: Expected boolean operator (and, or) got: "'01/01/0100'".

My where clause condition in filter stage:

CUST_KEY = 68 AND CLM_CHK_DT BETWEEN TO_DATE('01/01/0100','MM/DD/YYYY') AND TO_DATE('01/01/2006','MM/DD/YYYY')

Why am i getting the above error? Please suggest...

[ray.wurlod]

TO_DATE is a purely database function - you can not use that in a WHERE clause in a Filter stage.

Page 29-3 of the Parallel Job Developer's Guide suggests that BETWEEN is supported as an operator in the Filter stage WHERE clause property.