Raj Hadoop 2013-07-12, 15:42
-Re: Sqoop Import with a query - Where to set $CONDITIONS
Jarek Jarcec Cecho 2013-07-12, 15:58
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.
On Fri, Jul 12, 2013 at 08:42:12AM -0700, Raj Hadoop wrote:
> 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.