Member since
01-12-2022
4
Posts
0
Kudos Received
0
Solutions
03-29-2022
03:26 PM
please omit "[...] because Cloudera does work at least, not how I would imagine it should." Meant to say, "Cloudera does not work as I had hoped it would have."
... View more
03-29-2022
01:01 PM
I managed to finally connect to Hadoop 3.0 using the 64-bit Cloudera driver. There is a switch in the 64-bit ODBC Administrator (odbcadm32.exe) that permits you to turn SSL on (it appears when you choose 'SSL options' while configuring a Cloudera DSN). (I also had to be made part of a Unix user group in Active Directory, but that is probably specific to our network architecture.) The remaining problem is that even though I was able to connect, not all queries against Hadoop 3.0 run. Trivial queries, such as "SELECT * FROM <tablename>" work, but anything other than a trivial query throw a tez error. And that's where I am right now. We have switched to the Apache Hive JDBC driver to connect to Hadoop and have put Cloudera ODBC aside for the time being because Cloudera does work at least, not how I would imagine it should.
... View more
03-20-2022
11:34 AM
Hello, all,
I am trying to connect to our Hadoop 3.0 Unix server using the 64-bot Hortonworks ODBC driver. SSL is enabled on this server. I am able to connect using the Cloudera 64-bit ODBC driver, but, for reasons that I won't go into here, we would prefer to use the Hortonworks driver instead. The error message I keep getting from the Hortonworks connection dialog from odbcadm32.exe is "SSL v3 alert: handshake error." No other info is available. I know relatively little regarding security, so this is not something I can solve on my own. Was wondering if anyone else has experienced this, and, if so, what you did to rectify it.
Thank you,
Sincerely,
... View more
Labels:
- Labels:
-
Hortonworks Data Platform (HDP)