I have been trying to use sqoop import using join 2 tables into hdfs folder using SQL free form query . Tried multiple times with various scenarios but keep on having the same error about not having the $Condition ?
this is my query looks like
sqoop import \ --connect (mask out)\ --username (mask out) --password (mask out)\ --query "SELECT od.orderdate,pdt.productid, pdt.productname,ord.orderquantity,ord.orderprice, cust.customerid,cust.first_name,cust.last_name from products pdt inner join orderdetails ord on pdt.productid = ord.productid WHERE $CONDITIONS inner join orders od on od.orderid = ord.orderid WHERE $CONDITIONS inner join customers cust on cust.customerid = od.customerid WHERE $CONDITIONS WHERE $CONDITIONS od.orderdate between '2018-01-26' and '2018-01-31'" \ --split-by od.orderdate \ --target-dir /user/cloudera/2tables
Thank you very much for your help! Appreciated!
@valsnoky please explain further how you resolved your issue. It may be of assistance to others in a similar situation.