Yes, it is possible to load Hive tables using ODBC connection or using PowerExchange for Hadoop connector. Please see below KB for more details -
However, please note that its only on Linux that the above methods are supported.
Please review and let us know if you have any questions.
I hope you got a chance to take a look at the above.
Please let us know if you have additional questions.
Yes, it was really helpful...Thanks for your response.