Complex Oracle query to HDFS or Hive through Sqoop

[Raj Hadoop]

Hello everyone,


I want to load data from an Oracle query to HDFS or Hive through Sqoop.
  

My query in Oracle is based on something like this -
    
   select a.col1,a.col2,bcol3,c.col4,d.col5 from T1 a,T2 b, T3 c, T4 d where 
a.col1=b.col1 and b.col2=c.col2 and c.col3 = d.col3;

 Is this possible in SQOOP ? Please advise.



Thanks,

Raj