sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: problems importing from oracle
Date Thu, 01 Mar 2012 07:27:39 GMT
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

Mime
View raw message