,RTRIM(case when NUM_SERIES_PACS2 is NULL then 0 else NUM_SERIES_PACS2 end) as NUM_SERIES_PACS2 ,RTRIM(ISNULL(num_series,0)) as num_series_PACS1 ,RTRIM(case when secount.NUM_OBJECT_SERIES_PACS2 is ...
because of: java.lang.RuntimeException: not supported CASE WHEN isnull(input_2#137) THEN true END: org.apache.spark.sql.catalyst.expressions.CaseWhen: CASE WHEN ...
I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...