I checked online it says sqoop2 supports schedule, I was trying Oozie to setup a schedule job for sqoop2, but on the HUE UI, I think I can only create sqoop1 workflow, what should I do to have a schedule sqoop2 job?
For integrating sqoop2 with the HUE you need to enable the sqoop2 in HUE. Update the configuration of hue from cloudera manager as mentioned in the below URL.
This documentation is for older version of CM. But you can refer the documentation for your matching version.
Hope this helps!