New methods for Sqoop import with SQL query

Could you please refer me to some example in our code or some web page? I am not sure if I'm looking for right thing.