Keep only rows that meet the condition

Options
mntintchui
mntintchui Registered Posts: 2 ✭✭✭✭
Hello my name is Michael and I am new to DSS.

Here is variable i create

{
"v_date_m_1": "01-01-2020",
"v_date_m_3": "01-10-2019"
}

then in the PySpark recipe i do this:

SELECT *

FROM `table`
where date >= '${v_date_m_3}' and date < '${v_date_m_1}' ;

But nothing in output.
Can you guys tell me what is wrong ?


Best Answer

Answers

Setup Info
    Tags
      Help me…