3

I've kerbrized the HDP 2.3 cluster and have a valid TGT in the cache.

I can run queries successfully through beeline console. For example following things go well.

$beeline
$!connect jdbc:hive2://<HiveServer2Host>:10000/default;principal=hive/<HiveServer2Host>@<KDC_Realm>; 
Connected to: Apache Hive (version 1.2.1.2.3.2.0-2950)
Driver: Hive JDBC (version 1.2.1.2.3.2.0-2950)
Transaction isolation: TRANSACTION_REPEATABLE_READ
1: jdbc:hive2://HiveServer2Host> select * from <table>;

I am trying to execute the same query (placed in the file: query.sql) using following which does not work

$> beeline -u jdbc:hive2://<HiveServer2Host>:10000/default;principal=hive/<HiveServer2Host>@<KDC_Realm>; -f query.sql
Error: Could not open client transport with JDBC Uri: jdbc:hive2://<HiveServer2Host>:10000/default: Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0)

I am not sure why this issue. In both the cases I am using the same jdbc URL. Not sure if I am missing something.

Mogsdad
  • 44,709
  • 21
  • 151
  • 275
java_enthu
  • 2,279
  • 7
  • 44
  • 74

1 Answers1

8

It's enough to surround the connection string with ' like this:

beeline -u 'jdbc:hive2://<HiveServer2Host>:10000/default;principal=hive/<HiveServer2Host>@<‌​KDC_Realm>' -f query.sql
mgaido
  • 2,987
  • 3
  • 17
  • 39