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