Support Questions
Find answers, ask questions, and share your expertise

convert oracle sql to kudu sql

Contributor

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

1 REPLY 1

Super Collaborator

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.