Most of the connectors would have the performance close to same as you'll have a set of MapReduce jobs on the very end of your workflow and this would play the main role in your overall performance.
Oracle provides a set of different connectors for accessing the Hive and you could check a nice overview about standard solutions
but I doubt that on the very end you will expect significant performance differences other then you see in Sqoop:
Personally, I prefer Sqoop for Hadoop-driven import-export operations and connector approach for querying the data in Hadoop.
Hope this will answer your query to some extent.