Hi Bruce, would you mind sending entire sqoop command that you've used as well as entire output that it generates with "--verbose" flag?
Jarcec On Thu, Mar 01, 2012 at 03:22:14PM +0800, Bruce Bian wrote: > Hi there, > When I'm using sqoop free-form query import to import the data from Oracle > to HDFS with some ETL process in the query, the results in HDFS contains > nothing. > The query is as follows: > > SELECT a.*, > b.acnt_no,b.addr_id,b.postcode,b.acnt_rmnd_tp,b.print_tp,b.media_type, > c.cust_code,c.root_cust_code, > d.mdf_name,d.sub_bureau_code,d.bureau_cd,d.adm_sub_bureau_name,d.bureau_name > FROM prc_idap_pi_root a > LEFT OUTER JOIN prc_idap_pi_root_acnt b ON a.acnt_id=b.acnt_id > LEFT OUTER JOIN prc_idap_pi_root_cust c ON a.cust_id=c.cust_id > LEFT OUTER JOIN ocrm_vt_area d ON a.dev_area_id=d.area_id > WHERE lst_upd_tmp >= (SELECT date_val - 1/240 FROM etl.etl_para_cfg_detail > WHERE para_id=84) AND \$CONDITIONS > > The same query has been executed successfully in oracle(without the > $CONDITIONS of course). Is it because the query contains sub-query in it? > > Thanks&Regards, > Bruce
signature.asc
Description: Digital signature
