Question: how to sqoop data in orc format?
Answer: Get data from remote database using Spark JDBC in the form of data frame, say dataDF.
Write data frame to HDFS or Hive table using dataDF.write.orc("PATH_IN_HDFS")