Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Sqoop Import with a query - Where to set $CONDITIONS


+
Raj Hadoop 2013-07-12, 15:42
Copy link to this message
-
Re: Sqoop Import with a query - Where to set $CONDITIONS
Hi Raj,
the placeholder "$CONDITIONS" is being used by Sqoop itself to fill dynamically generated conditions (for slicing your data into independent pieces). As a result, you do not need to set the placeholder to any value.

Jarcec

On Fri, Jul 12, 2013 at 08:42:12AM -0700, Raj Hadoop wrote:
> Hi,
>  
> I am trying to load data from an Oracle query to HDFS using Sqoop.
>  
> sqoop import --connect jdbc:oracle:thin:@//gobyuioids:1521/dbgyru --username user1 --password pwd--query 'select a.col1,a.col2,b.col1 from sch1.t1 a , sch1.t2 b  where $CONDITIONS' --split-by col1 --target-dir tgrdir1
>  
>  
> How to set $CONDITIONS' . Is this a OS variable ? How do I set this ? Please advise.
>  
> Thanks,
> Raj