[ 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.f...@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.f...@lab.com" > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)