[DRILL-5440] Sqlline is not connecting to Hive database

• Type: Task
• Status: Resolved
• Priority: Minor
• Resolution: Invalid
• Affects Version/s: 1.10.0
• Fix Version/s: 1.10.0
• Component/s: Functions - Drill
• Labels: newbie

Environment

OS: Redhat Linux 6.7, HDP 2.5.3, Kerberos enabled, Hardware: VmWare

• Assignee: Unassigned
• Reporter: Parag Darji
• Created: 18/Apr/17 16:00
• Updated: 26/Apr/17 22:59
• Resolved: 26/Apr/17 22:59

Description

Sqlline is not showing hive database.

sqlline -u "jdbc:drill:schema:hiveremote;drillbit=host1.fqdn;auth=kerberos"

apache drill 1.10.0
"what ever the mind of man can conceive and believe, drill can query"
0: jdbc:drill:schema:hiveremote> show schemas;
+---------------------+
|     SCHEMA_NAME     |
+---------------------+
| INFORMATION_SCHEMA  |
| sys                 |
+---------------------+
2 rows selected (2.074 seconds)
0: jdbc:drill:schema:hiveremote> show databases;
+---------------------+
|     SCHEMA_NAME     |
+---------------------+
| INFORMATION_SCHEMA  |
| sys                 |
+---------------------+
2 rows selected (0.226 seconds)

0: jdbc:drill:schema:hiveremote>  !connect  jdbc:mysql://hive.fqdn:10010/hive
Enter username for jdbc:mysql://hive.fqdn:10010/hive:

I've kerberos enabled so I tried below command, but it's giving auth error.

sqlline --maxWidth=10000 -u "jdbc:drill:schema=hive:drillbit=host1.fqdn;auth=kerberos;principal=drill/[e-mail];keytab:/home/drill/.keytab/drill.keytab"

error: Error: Failure in connecting to Drill: org.apache.drill.exec.rpc.NonTransientRpcException: javax.security.sasl.SaslException: Authentication failed: Authentication failed. Incorrect credentials? [Caused by javax.security.sasl.SaslException: Authentication failed. Incorrect credentials?] (state=,code=0)
java.sql.SQLException: Failure in connecting to Drill: org.apache.drill.exec.rpc.NonTransientRpcException: javax.security.sasl.SaslException: Authentication failed: Authentication failed. Incorrect credentials? [Caused by javax.security.sasl.SaslException: Authentication failed. Incorrect credentials?]

When I try to use username/password, it doesn't return anything, just sits there for hours

drill@:/home/drill>  sqlline -u "jdbc:drill:drillbit=host1.fqdn;auth=kerberos"
apache drill 1.10.0
"drill baby drill"
0: jdbc:drill:drillbit=> !connect
Usage: connect <url> <username> <password> [driver]
0: jdbc:drill:drillbit=> !connect  jdbc:mysql://hivenode.fqdn:10010/hive test test

Below query doesn't return anything:

sqlline -u "jdbc:mysql://hive.fqdn:10010/default;zk=host1.fqdn:2181;service_name=drill;service_host=host2.fqdn;keytab=/home/drill/.keytab/drill.keytab";user="drill/[e-mail]"