zhongyujiang commented on PR #1028: URL: https://github.com/apache/parquet-mr/pull/1028#issuecomment-1433005114
> I don't know if there is a downstream that relies on Parquet judge value <> null as TRUE instead of UNKNOW, I guess that might be in some non-ansi standard engines. I just want to make sure it's safe to revert this, I did some search and find this: https://stackoverflow.com/questions/129077/null-values-inside-not-in-clause Seems SQL Server 2005 has a switch `ansi_null` to control wheather the result of `value <> null` is `TRUE` or `UNKNOWN`, when `ansi_nulls` is off, `3 <> null` is true. Though I didn't find such a switch in engines like Hive or Spark. Do you have any comments on this? Or do you think it's worth caring about? @gszadovszky @wgtmac @huaxingao. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@parquet.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
