[HIVE-21743] day( ) gives wrong day from the date in Apache Hive 3.1 server

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 3.0.1
• Component/s: Hive

Environment

Server: Apache Hive 3.1 

Driver hive-jdbc-3.1.0.3.1.0.0-78

• Target Version/s: 3.0.1
• Assignee: Unassigned
• Reporter: Adarshdeep Cheema
• Created: 16/May/19 17:15
• Updated: 25/Jul/19 14:54

Description

Using Apache Hive 3.1 server ////

Run the following SQL and you will get 3 instead of 1

SELECT
(day( DATE '0001-01-01'))

FROM
`table`

PLEASE NOTE THIS DOES NOT HAPPEN WITH Apache HIVE 2.1 SERVER