I assume you looked at the basic Hive Storage plugin configuration already. http://drill.apache.org/docs/hive-storage-plugin/
Also see this link for Hive Authorization http://drill.apache.org/docs/configuring-user-impersonation-with-hive-authorization/ You will need to enable user authentication and impersonation for Drill as well. http://drill.apache.org/docs/securing-drill/ --Andries On 7/6/17, 7:36 AM, "Sunil Kumar Thimmapuram" <sunil.thimmapu...@gmail.com> wrote: Hi Team: Greetings!! I am new to Drill and started exploring the tool and capabilities. As part of it, I am looking for a help to establish the connection to Hive from Drill. Our Hadoop Eco System has a hive2 server and I have been give access to hive server with user credentials for me to login to Hive. With following the documentation of Drill, I tried using the hive server but not able to successfully establish the connection. I know I have never provided the credentials anywhere. Can any of our team who did established the connection to hive successfully can help me with requisites that I need to get from Hadoop/Hive team and the hive connection details. Any help on my request is much appreciated and will help me to proceed further with my work. Thanks & Regards Sunil Kumar T.S.