I need to format a date as 2017-04-20H18. No amount of backslashes or ticks will get this done.
In hive, it looks like:
In impala, the same query returns the wrong thing. Instead of a literal H, it gives me '8' (because the hour happens to be 8).
from_unixtime should support literals. My preference would be that it uses the same syntax as hive to achieve this.
|Impala Doc: from_unixtime supports literal H||Open||Unassigned|