Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

Explorer

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?