convert oracle sql to kudu sql

[#1]

Hello Team,

can you please  advise why Kudu returns 0 rows? count  of base table is same.

Oracle - returns 21000 rows:

select BankOrgProfile.*
from AR.HZ_ORGANIZATION_PROFILES BankOrgProfile where
SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1) ;

Kudu (Impala) - returns 0 rows:

select BankOrgProfile.* from oracle_financial.HZ_ORGANIZATION_PROFILES BankOrgProfile
where current_date() between cast(BankOrgProfile.effective_end_date as date)
and nvl(cast(BankOrgProfile.effective_end_date as date), adddate(current_date(),1))
;

Thanks,

Roshan

[#2]

Could you provide the output of the DESCRIBE command for your table in Kudu.