You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2017/04/26 22:59:04 UTC
[jira] [Resolved] (DRILL-5440) Sqlline is not connecting to Hive
database
[ https://issues.apache.org/jira/browse/DRILL-5440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhishek Girish resolved DRILL-5440.
------------------------------------
Resolution: Invalid
> Sqlline is not connecting to 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
> Labels: newbie
> Fix For: 1.10.0
>
> Original Estimate: 168h
> Remaining Estimate: 168h
>
> 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}
> When I try to use username/password, it doesn't return anything, just sits there for hours
> {code}
> 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
> {code}
> Below query doesn't return anything:
> {code}
> 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/host2.fqdn@LAB.COM"
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)