sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruce Bian <weidong....@gmail.com>
Subject problems importing from oracle
Date Thu, 01 Mar 2012 07:22:14 GMT
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

Mime
View raw message