ant-hive

command="exportHADOOP_HOME=/home/hadoop/hadoop-1.0.3;echo$HADOOP_HOME;exportPATH=$PATH:/home/hadoop/hadoop-1.0.3/bin;echo$PATH;cd/home/hadoop/hive-0.9.0/bin;./hive-e"INSERTOVERWRITEDIRECTORY'/user/hadoop/novelrecommend'selecta.VC_COOKIE_UID,a.p1_nid,a.p4_st_or_s_order,b.nid,b.gid,b.gpvfromngpvbjoinnovel4aon(a.p1_nid=b.nidanda.p4_st_or_s_order<>'#'anda.VC_COOKIE_UID<>''anda.VC_COOKIE_UID<>'#'anda.p1_nid<>'#'anda.vc_vst_url_name='show');""