Posts: 14
Registered: ‎10-25-2014

could sqoop could load the query sql from a property file?

hi ,

   I am using the sqoop to transfer the data from sqlserver to the hdfs , If I using the --table ,i am woried that the column in the table maybe changed,  i want to use --query instead ,but  the talble have many columns ,  could i defined the query in another file ,and  the sqoop load the query form that file,?


   and i am using oozie , the file must in the hfds?