drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parag Darji (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-5440) Sqlline is not showing Hive database
Date Wed, 19 Apr 2017 17:02:41 GMT

     [ https://issues.apache.org/jira/browse/DRILL-5440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Parag Darji updated DRILL-5440:
-------------------------------
    Description: 
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}

  was:
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}


> 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
>              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}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message