Have you tried `PLAIN`? The nest approach is probably to fire up an iPython shell and interact with the underlying library until you find a working path. Then you can read the fairly simple HiveServer2Hook code and figure out how to pass your configuration settings through.
Max On Thu, Oct 27, 2016 at 2:01 AM, twinkle sachdeva < [email protected]> wrote: > Hi Maxime, > > Before this setting, i was getting following exception: > > File "/home/xxx/.pyenv/versions/2.7.12/lib/python2.7/site- > packages/pyhs2/cloudera/thrift_sasl.py", line 66, in open > > message=("Could not start SASL: %s" % self.sasl.getError())) > > thrift.transport.TTransport.TTransportException: Could not start SASL: > Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy > mechs found > > > After using the NOSASL setting, I am getting following exception: > > File "/home/xxx/.pyenv/versions/2.7.12/lib/python2.7/site- > packages/pyhs2/TCLIService/TCLIService.py", line 154, in OpenSession > > return self.recv_OpenSession() > > File "/home/xxx/.pyenv/versions/2.7.12/lib/python2.7/site- > packages/pyhs2/TCLIService/TCLIService.py", line 165, in recv_OpenSession > > (fname, mtype, rseqid) = self._iprot.readMessageBegin() > > File "/home/xxx/.pyenv/versions/2.7.12/lib/python2.7/site- > packages/thrift/protocol/TBinaryProtocol.py", line 140, in > readMessageBegin > > name = self.trans.readAll(sz) > > File "/home/xxx/.pyenv/versions/2.7.12/lib/python2.7/site- > packages/thrift/transport/TTransport.py", line 58, in readAll > > chunk = self.read(sz - have) > > File "/home/xxx/.pyenv/versions/2.7.12/lib/python2.7/site- > packages/thrift/transport/TTransport.py", line 159, in read > > self.__rbuf = StringIO(self.__trans.read(max(sz, self.__rbuf_size))) > > File "/home/xxx/.pyenv/versions/2.7.12/lib/python2.7/site- > packages/thrift/transport/TSocket.py", line 118, in read > > message='TSocket read 0 bytes') > > thrift.transport.TTransport.TTransportException: TSocket read 0 bytes. > > > I did checked, if the hive server is running or not. > > I am getting the same issue, if i try to connect using simple python > program also. > > On Wed, Oct 26, 2016 at 9:17 PM, Maxime Beauchemin < > [email protected]> wrote: > > > From memory, I think this is related to having the wrong authentication > > method. > > https://github.com/apache/incubator-airflow/blob/master/ > > airflow/hooks/hive_hooks.py#L578 > > > > You may want to try NOSASL. To do that i think you have to put something > > like `{ "authMechanism": "NOSASL" }` in your Connection's extra params. > > > > On Wed, Oct 26, 2016 at 1:50 AM, twinkle sachdeva < > > [email protected]> wrote: > > > > > Hi, > > > > > > I am trying to use HiveToMySqlTransfer operator, but I am not able to > > read > > > any data with the following configuration: > > > > > > TSocket.py", line 120, in read > > > > > > message='TSocket read 0 bytes') > > > > > > thrift.transport.TTransport.TTransportException: TSocket read 0 bytes > > > > > > It seems to happen due to some mismatch in thrift protocol etc > > > specification. > > > > > > Please help me on what can be done. > > > > > > > > > Regards, > > > > > > Twinkle > > > > > >
