hive cast string to date in 'dd/MMM/yyyy' format order by and group by issue

2016-03-08 Thread dhruv kapatel
in-dd-mmm--format-order-by-and-group-by-issue -- *With Regards:Kapatel Dhruv v*

GROUP BY Issue

2013-06-10 Thread Gourav Sengupta
Hi, On running the following query I am getting multiple records with same value of F1 SELECT F1, COUNT(*) FROM ( SELECT F1, F2, COUNT(*) FROM TABLE1 GROUP BY F1, F2 ) a GROUP BY F1; As per what I understand there are multiple number of records based on number of reducers. Replicating the test