I've since found the following:
Which suggests loading the data to HDFS then creating a table with a hive2 action. This has since solved my problem and I have a working job. I appreciate your help!
View solution in original post
There are 2 options that you can do.
1. Sqoop import command with + hive import ( 1 step hive import)
2. Sqoop import to HDFS and create hive table on top of it.
Either of the above option will reach the desired results.
Let me know if you have any questions.