20120820

hive>  load data  inpath '/fenxi_system/r_fx_daily_all/stat_time=20120612/000000_0' overwrite into table r_fx_daily_all partition(stat_time='20120612'); 

FAILED: Parse Error: line 1:0 character ' ' not supported here

....空格不行

hive> select user_name,1,sum(sms_send_count),1,1,1,1,1,1,1,1,1,1,1,1
    >  from r_fx_daily_all
    >  where dd_date='2012-06-12'
    >  group by user_name
    > union all
    >  select user_name,3,sum(sms_send_count),1,1,1,1,1,1,1,1,1,1,1,1
    >   from r_fx_daily_all
    >  where dd_date>date_sub('2012-06-12',15)
    >  group by user_name;
FAILED: Error in semantic analysis: 2:6 Top level UNION is not supported currently; use a subquery for the UNION. Error encountered near token 'user_name'