When performing LN on negative numbers, it returned invalid value for Redshift.
log(x) is undefined for x ≤ 0, If we pass a static number, Redshift can also directly display the error, however when we pass a column, that column can have multiple values which could be either >0 or <=0, so instead Redshift will show NaN for the values which are <=0.
There are no plans to change or modify this behavior from Redshift side.
No action required. MSTR uses the return value "-1.#IND" to indicate invalid value.
