[SPARK-25457] IntegralDivide (div) should not always return long

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Marco Gaido
• Created: 18/Sep/18 14:20
• Updated: 12/Dec/22 18:10
• Resolved: 13/Mar/20 01:52

Description

The operation div returns always long. This came from Hive's behavior, which is different to the one of most of other DBMS (eg. MySQL, Postgres) which return as a datatype the same of the operands.

This JIRA tracks changing our return type and allowing the users to re-enable the old behavior using spark.sql.legacy.integralDivide.returnBigint.

I'll submit a PR for this soon.

Issue Links

• links to: GitHub Pull Request #27835