Hi,    I have a table in Hadoop stores data monthwise ,  eg. 2014-01-01  2014-02-01 etc , I need to extract quarter from this. For instance, i acheive this with trunc(month_date_column,'q') in SQL (oracle) Looking for equivalent function or method in hive. Please help ! tried date_trunc, but that is not working . Looks i have to convert the date column to timestamp first and then try this function. Date is stored as string in my table   Any help is appreciated !   Thanks gi ... View more