79321972

Date: 2025-01-01 16:48:53
Score: 0.5
Natty:
Report link

As I mentioned in the comment this is because of aligning its behavior with other query engines like apache spark.

In older versions of Hive:

Behavior in Hive 2.3.9:

References:

There is a workaround to reach the old result? Let me know if you are intrested in hearing that. I will update the answer.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Contains question mark (0.5):
Posted by: Ali Saberi