Advertisement
Guest User

Untitled

a guest
Dec 30th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. sqoop import
  2. --connect "jdbc:mysql://quickstart.cloudera:3306/retail_db"
  3. --username retail_dba --password cloudera
  4. --query 'select * from sample_data where $CONDITIONS AND salary > 1000'
  5. --split-by salary
  6. --target-dir hdfs://quickstart.cloudera/user/cloudera/sqoop_new
  7.  
  8. SqlManager: Executing SQL statement: select * from sample_data where (1 = 0) AND salary > 1000
  9.  
  10. INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(salary), MAX(salary) FROM (select * from sample_data where (1 = 1) AND salary > 1000) AS t1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement