Member since
06-21-2016
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
16698 | 06-21-2016 11:08 AM |
06-21-2016
11:08 AM
Solved it. According to page 68 of the installation guide, you set the HttpPath parameter in your odbc.ini file, but that failed to work: $ tail .odbc.ini
# The client private key. This is used for two-way SSL authentication.
ClientPrivateKey=
# The password for the client private key. Password is only required for password protected
# client private key.
ClientPrivateKeyPassword=
HttpPath=/cliservice
$ isql -v ClouderaHiveDSN
[S1000][unixODBC][Cloudera][Hardy] (34) Error from server: Bad Status: HTTP/1.1 404 Not Found.
[ISQL]ERROR: Could not SQLConnect
$ So I looked for path strings in the driver: $ strings /opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so | grep -i path
m_httpPath: %s
m_trustedCertsPath: %s
HttpPathPrefix
... I changed the paramter from HttpPath to HttpPathPrefix and was able to connect: [novetta@cdh-1 ~]$ tail .odbc.ini
# The client private key. This is used for two-way SSL authentication.
ClientPrivateKey=
# The password for the client private key. Password is only required for password protected
# client private key.
ClientPrivateKeyPassword=
HttpPathPrefix=/cliservice
[novetta@cdh-1 ~]$ isql -v ClouderaHiveDSN
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> Hope it helps!
... View more