We are having CDH version 5.13.2 with Hue 4.
I am currently facing an issue with date_format function in Hue using Hive as source however the function is giving correct results through CLI.
Refer snapshot titled Query1_Error.PNG for the error. While querying date for D-2, the query is giving a date of one year ahead. This issue is only occurring for dates after 28th Dec.
Refer snapshot titled Query2_Ok.PNG for the same query but date of 28th.
Refer snapshot titled Query3.PNG without date_format function.
Refer snapshot titled Query4.PNG having current_date function.
Refer snapshot title CLI for the same query output in Hive shell.