question Hive trunc function to extract quarter just like sql trunc(column,'q) in Archives of Support Questions (Read Only)

Hive trunc function to extract quarter just like sql trunc(column,'q)

gi — Thu, 16 Mar 2017 11:17:12 GMT

namaheshwari — Thu, 16 Mar 2017 12:30:46 GMT

Do you need quarter of the year for some date, timestamp, or string? If yes then Hive already has a built-in date functions defined for it :

quarter(date/timestamp/string)

deepesh1 — Thu, 23 Mar 2017 09:37:13 GMT

In the Hive version prior to 2.2.0 there is no function available, I added support for it recently, see HIVE-16234. Example

SELECT trunc('2017-03-15', 'Q');
'2017-01-01'