Are you using Linux, OS X or Windows for the embedded system? I have not tried to do it in Embedded mode, but you may get lucky if you use Linux or even OS X. Not sure how you will get authentication going on some of these platforms in embedded mode, but good to explore https://drill.apache.org/docs/configuring-user-authentication/ <https://drill.apache.org/docs/configuring-user-authentication/>
I assume you looked at the Drill docs for this https://drill.apache.org/docs/configuring-user-impersonation-with-hive-authorization/ <https://drill.apache.org/docs/configuring-user-impersonation-with-hive-authorization/> Perhaps try to place the hive-site.xml file in the Drill/Conf directory on the embedded system. --Andries > On Nov 23, 2015, at 8:12 AM, Almog Tabak <[email protected]> wrote: > > Here is the error message I get when trying to query a Hive table: > Error: SYSTEM ERROR: ConnectException: Connection refused: no further > information > > [Error Id: dbe1a706-edcc-4266-997e-f3db840a180d on > ATABAK.vistaprint.net:31010] (state=,code=0) > > Can someone please help me with this issue? I just need a way to provide a > username and password when querying Hive using Drill. > > Thanks > From: Almog Tabak > Sent: Wednesday, November 18, 2015 12:05 PM > To: '[email protected]' > Subject: Hive Authentication > > Hi, > > I have been able to successfully connect to Hive using Drill 1.3 in Embedded > mode, but I cannot query any tables because I cannot pass permissions to > Hive. Is there a way to provide a username and password to Hive through Drill? > > Thanks, > Almog
