20120817

6:28

hive>  from r_fx_daily_all 
    >  insert into table r_fx_period_all partition(stat_time='20120807')
    >  select user_name,1,sum(sms_send_count),1,1,1,1,1,1,1,1,1,1,1,1
    >  group by user_name
    >  where dd_date>'20120615';
FAILED: Parse Error: line 5:1 mismatched input 'where' expecting EOF near 'user_name'


hive>  
    >  from r_fx_daily_all 
    >  insert into table r_fx_period_all partition(stat_time='20120807')
    >  select user_name,1,sum(sms_send_count),1,1,1,1,1,1,1,1,1,1,1,1
    >   where dd_date>'20120615'
    >  group by user_name;
Total MapReduce jobs = 3
Launching Job 1 out of 3