You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Parag Darji (JIRA)" <ji...@apache.org> on 2017/04/18 16:00:43 UTC
[jira] [Created] (DRILL-5440) Sqlline is not showing Hive database
Parag Darji created DRILL-5440:
----------------------------------
Summary: Sqlline is not showing Hive database
Key: DRILL-5440
URL: https://issues.apache.org/jira/browse/DRILL-5440
Project: Apache Drill
Issue Type: Task
Components: Functions - Drill
Affects Versions: 1.10.0
Environment: OS: Redhat Linux 6.7, HDP 2.5.3, Kerberos enabled, Hardware: VmWare
Reporter: Parag Darji
Priority: Minor
Fix For: 1.10.0
Sqlline is not showing hive database.
{code}
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:
{code}
I've kerberos enabled so I tried below command, but it's giving auth error.
{code}
sqlline --maxWidth=10000 -u "jdbc:drill:schema=hive:drillbit=host1.fqdn;auth=kerberos;principal=drill/host1.fqdn@LAB.COM;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?]
{code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)