Hi Sadegh,
If I recall well the behavior of the string concatenation is defined
by the SQL standard (ISO/IEC 9075).
Section 6.29: General rules 2.b.i:
If at least one of S1 and S2 is the null value, then the result of the
is the null value.
Hive as well as many other DBMS systems strive to rema
Dear Hive User Group,
I hope this email finds you well.
I’m writing to inquire about the behavior of string concatenation with NULL
values in Hive. I’ve observed that when concatenating a string with a NULL
value using the || operator or concat function, Hive returns NULL.
For example:
```sql
