Re: GROUP BY Issue

2013-06-10 Thread Gourav Sengupta
G's. > > Regards, > Shahab > > > On Mon, Jun 10, 2013 at 10:39 AM, Gourav Sengupta > wrote: > > > Hi, > > > > On running the following query I am getting multiple records with same > > value of F1 > > > > SELECT F1, COUNT(*) > >

GROUP BY Issue

2013-06-10 Thread Gourav Sengupta
STEP7: hadoop fs -mkdir /test2 STEP8: create table test2 location '/test2' as select f1, count(*) from (select f1, f2, count(*) from test1 group by f1, f2) a group by f1; STEP9: select * from test2 where f1 = 9887; ENVIRONMENT: HADOOP 2.0.4 HIVE 0.11 Please do let me know whether

DataGenerator and HADOOP 2.0.4

2013-06-09 Thread Gourav Sengupta
Hi, I have compiled PIG with HADOOP 2.0.4 as per the instructions in https://issues.apache.org/jira/browse/PIG-2125?focusedCommentId=13069124&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13069124 Kindly let me know how to build DataGenerator with HADOOP 2.0.4.