You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently ssaProgram doesn't support nulls. And so predicate with Nothing can't be pushed down
But in some cases it's possible to get rid of Nothing by rewriting a predicate
example predicate:
(case when household_demographics.hd_vehicle_count > 0
then household_demographics.hd_dep_count/ household_demographics.hd_vehicle_count
else null
end) > 1.2
it can be rewritten to:
if (household_demographics.hd_vehicle_count > 0, household_demographics.hd_dep_count/ household_demographics.hd_vehicle_count > 1.2, false)
The text was updated successfully, but these errors were encountered:
Uh oh!
There was an error while loading. Please reload this page.
Currently ssaProgram doesn't support nulls. And so predicate with Nothing can't be pushed down
But in some cases it's possible to get rid of Nothing by rewriting a predicate
example predicate:
(case when household_demographics.hd_vehicle_count > 0
then household_demographics.hd_dep_count/ household_demographics.hd_vehicle_count
else null
end) > 1.2
it can be rewritten to:
if (household_demographics.hd_vehicle_count > 0, household_demographics.hd_dep_count/ household_demographics.hd_vehicle_count > 1.2, false)
The text was updated successfully, but these errors were encountered: