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.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} -- This message was sent by Atlassian JIRA (v6.3.15#6346)