Member since
09-07-2017
9
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1120 | 06-15-2018 08:31 AM |
07-18-2018
07:19 AM
Hi Josh, In the phoenix datatype description ( link ), its mentioned that Phoenix Unsigned data types map to Hbase Bytes.toBytes method . Is there a way to utilize these unsigned data types to map existing Hbase data to Phoenix tables and be able to read the data correctly from Phoenix. I mapped numbers inserted through Hbase Shell to Unsigned_int datatype in phoenix but i was still getting same error that bsaini was getting in the above question. Could you please clarify if we can use Unsigned_Int in the above scenario. Thanks
... View more
06-27-2018
12:03 PM
Hi, I have created a table in phoenix through this sql using sqlline and inserted the data - create table test2(pk integer primary key,col1 integer,col2 double,col3 varchar);
upsert into test2 values (1, 1, 1.1, 'qwerty');
upsert into test2 values (2, 2, 1.23, 'test');
I can see the data when i do a select on test2 in sqlline . But when i try to read data of test2 table from Squirrel i get null for col1, col2 and col3. Please see attached photo. When the table is created through psl.py and we perform bulk loading operation we can see the data in Squirrel. Please help me understand why i am unable to see the data when table is created through sqlline.
... View more
Labels:
06-22-2018
07:34 AM
I am trying to connect to Phoenix from remote windows machine via DB visualizer. I followed the steps from this Link. I am getting below errors while connecting . Connection to phoenix via sqlline was successful and i am using same url - ip-1************************om:2181:/hbase:s*************-dev@AEXAMPLE.COM:/pathto/keytab.keytab. 2018-06-22 12:31:34.918 INFO 973 [pool-5-thread-7 - S.flush] Found ticket for svc__________@EXAMPLE.COM to go to krbtgt/EXAMPLE.COM@EXAMPLE.COM expiring on Fri Jun 22 21:59:49 IST 2018
2018-06-22 12:31:34.920 INFO 973 [pool-5-thread-7 - S.flush] Entered Krb5Context.initSecContext with state=STATE_NEW
2018-06-22 12:31:34.920 INFO 973 [pool-5-thread-7 - S.flush] Found ticket for svc__________@EXAMPLE.COM to go to krbtgt/EXAMPLE.COM@EXAMPLE.COM expiring on Fri Jun 22 21:59:49 IST 2018
2018-06-22 12:31:34.920 INFO 973 [pool-5-thread-7 - S.flush] Service ticket not found in the subject
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] >>> Credentials acquireServiceCreds: same realm
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] Using builtin default etypes for default_tgs_enctypes
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] default etypes for default_tgs_enctypes:
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] 18
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] 17
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] 16
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] 23
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] .
2018-06-22 12:31:34.921 INFO 973 [pool-5-thread-7 - S.flush] >>> CksumType: sun.security.krb5.internal.crypto.RsaMd5CksumType
2018-06-22 12:31:34.922 INFO 973 [pool-5-thread-7 - S.flush] >>> EType: sun.security.krb5.internal.crypto.ArcFourHmacEType
2018-06-22 12:31:34.922 INFO 973 [pool-5-thread-7 - S.flush] getKDCFromDNS using UDP
2018-06-22 12:31:34.987 INFO 973 [pool-5-thread-7 - S.flush] >>> KrbKdcReq send: kdc=ausy-pdir-am02.EXAMPLE.COM. TCP:88, timeout=30000, number of retries =3, #bytes=1564
2018-06-22 12:31:35.181 INFO 973 [pool-5-thread-7 - S.flush] >>> KDCCommunication: kdc=ausy-pdir-am02.EXAMPLE.COM. TCP:88, timeout=30000,Attempt =1, #bytes=1564
2018-06-22 12:31:35.377 INFO 973 [pool-5-thread-7 - S.flush] >>>DEBUG: TCPClient reading 115 bytes
2018-06-22 12:31:35.377 INFO 973 [pool-5-thread-7 - S.flush] >>> KrbKdcReq send: #bytes read=115
2018-06-22 12:31:35.377 INFO 973 [pool-5-thread-7 - S.flush] >>> KdcAccessibility: remove ausy-pdir-am02.EXAMPLE.COM.:88
2018-06-22 12:31:35.377 INFO 973 [pool-5-thread-7 - S.flush] >>> KDCRep: init() encoding tag is 126 req type is 13
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] >>>KRBError:
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] sTime is Fri Jun 22 12:31:35 IST 2018 1529650895000
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] suSec is 392441
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] error code is 7
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] error Message is Server not found in Kerberos database
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] sname is hbase/ip******19.example.com@EXAMPLE.COM
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] msgType is 30
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] KrbException: Server not found in Kerberos database (7)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.KrbTgsRep.<init>(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.KrbTgsReq.getReply(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.KrbTgsReq.sendAndGetCreds(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.internal.CredentialsUtil.serviceCreds(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.internal.CredentialsUtil.acquireServiceCreds(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.Credentials.acquireServiceCreds(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.jgss.krb5.Krb5Context.initSecContext(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.jgss.GSSContextImpl.initSecContext(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.jgss.GSSContextImpl.initSecContext(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at com.sun.security.sasl.gsskerb.GssKrb5Client.evaluateChallenge(Unknown Source)
2018-06-22 12:31:35.378 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.security.HBaseSaslRpcClient.saslConnect(HBaseSaslRpcClient.java:181)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupSaslConnection(RpcClientImpl.java:617)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.access$700(RpcClientImpl.java:162)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection$2.run(RpcClientImpl.java:743)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection$2.run(RpcClientImpl.java:740)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at java.security.AccessController.doPrivileged(Native Method)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at javax.security.auth.Subject.doAs(Unknown Source)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1693)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.setupIOstreams(RpcClientImpl.java:740)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.writeRequest(RpcClientImpl.java:906)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.tracedWriteRequest(RpcClientImpl.java:873)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1242)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:226)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:331)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.protobuf.generated.MasterProtos$MasterService$BlockingStub.isMasterRunning(MasterProtos.java:58383)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$MasterServiceStubMaker.isMasterRunning(ConnectionManager.java:1712)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$StubMaker.makeStubNoRetries(ConnectionManager.java:1650)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$StubMaker.makeStub(ConnectionManager.java:1672)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation$MasterServiceStubMaker.makeStub(ConnectionManager.java:1701)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getKeepAliveMasterService(ConnectionManager.java:1858)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.MasterCallable.prepare(MasterCallable.java:38)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:124)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.HBaseAdmin.executeCallable(HBaseAdmin.java:4131)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:555)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:547)
2018-06-22 12:31:35.379 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:577)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:979)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1369)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2116)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:828)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:338)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:326)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:324)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1326)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2279)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at java.lang.reflect.Method.invoke(Unknown Source)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at com.onseven.dbvis.g.B.D.?(Z:1548)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at com.onseven.dbvis.g.B.F$A.call(Z:1369)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at java.util.concurrent.FutureTask.run(Unknown Source)
2018-06-22 12:31:35.380 INFO 973 [pool-5-thread-7 - S.flush] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
2018-06-22 12:31:35.381 INFO 973 [pool-5-thread-7 - S.flush] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
2018-06-22 12:31:35.381 INFO 973 [pool-5-thread-7 - S.flush] at java.lang.Thread.run(Unknown Source)
2018-06-22 12:31:35.381 INFO 973 [pool-5-thread-7 - S.flush] Caused by: KrbException: Identifier doesn't match expected value (906)
2018-06-22 12:31:35.381 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.internal.KDCRep.init(Unknown Source)
2018-06-22 12:31:35.381 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.internal.TGSRep.init(Unknown Source)
2018-06-22 12:31:35.381 INFO 973 [pool-5-thread-7 - S.flush] at sun.security.krb5.internal.TGSRep.<init>(Unknown Source)
2018-06-22 12:31:35.381 INFO 973 [pool-5-thread-7 - S.flush] ... 63 more
2018-06-22 12:31:35.381 INFO 973 [pool-5-thread-7 - S.flush] 18/06/22 12:31:35 WARN security.UserGroupInformation: PriviledgedActionException as:svc__________@EXAMPLE.COM (auth:KERBEROS) cause:javax.security.sasl.SaslException: GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Server not found in Kerberos database (7))]
... View more
Labels:
06-15-2018
08:31 AM
So the issue was that socket connection was getting established but the hostname returned by the zookeeper was not getting resolved by squirrel. This answer also points to same issue link.
... View more
06-13-2018
09:42 AM
Were you able to connect. I am facing the same error.
... View more
06-13-2018
08:09 AM
Hello, I am trying to connect to phoenix from squirrel but i am facing some issues. First of all i tried to connect to phoenix through sqlline and i was able to establish connection with below connection string. "/usr/lib/phoenix/bin/sqlline.py ip- 8:2181:/hbase". After this i downloaded the phoenix client jar from hbase cluster and placed it in the lib folder of Squirrel. Now when i am trying to connect to phoenix with this connection string jdbc:phoenix:ip- 8:2181:/hbase" i am getting below error. Error : Unexpected Error occurred attempting to open an SQL connection.
class java.util.concurrent.TimeoutException: null error form stack trace - java.util.concurrent.TimeoutException
at java.util.concurrent.FutureTask.get(Unknown Source)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source) More details - Hbase version - 1.4, Phoenix client version - 4.13.0 Please help me understand what could be the problem here.
... View more
Labels:
09-15-2017
12:17 PM
How is authorization managed with service account and keytab. How is access managed with them. We can access hbase with phoenix from outside tool. In this case how is access managed as from documentation I found that we only need to give principal name and keytab for authentication. because when I tried to connect to phoenix using sqlline I needed to change the user I was running sqlline as . So how will Phoenix driver get which user have access to hbase from principal and keytab.
... View more
Labels:
09-15-2017
11:51 AM
I did this and was able to connect to hbase. But since I was using principal and keytab and they are credential mechanism in kerberized system then why did it matter which user I was running sqlline as. And if I want to connect to hbase from outside tool (spotfire) using phoenix driver then how do I get the connection string.
... View more
09-07-2017
01:00 PM
The connection string i am using to connect to hbase is of the form - phoenix-sqlline.py zookeeper:host:/hbase:principal name:keytab I am getting this error - Setting property: [incremental, false] Setting property: [isolation,
TRANSACTION_READ_COMMITTED] issuing: !connect
jdbc:phoenix:zk-host:/hbase:hbase/Principal_Name@Domain:/opt/app/svc-edl-dpc-ngmp-dev/svc-edl-dpc-ngmp-dev.keytab
none none org.apache.phoenix.jdbc.PhoenixDriver Connecting to
jdbc:phoenix:zk-host:/hbase:hbase/Principal_Name@Domain:/opt/app/svc-edl-dpc-ngmp-dev/svc-edl-dpc-ngmp-dev.keytab SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in
[jar:file:/opt/cloudera/parcels/CLABS_PHOENIX-4.7.0-1.clabs_phoenix1.3.0.p0.000/lib/phoenix/phoenix-4.7.0-clabs-phoenix1.3.0-client.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in
[jar:file:/opt/cloudera/parcels/CDH-5.10.0-1.cdh5.10.0.p0.41/jars/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings
for an explanation. SLF4J: Actual binding is of type
[org.slf4j.impl.Log4jLoggerFactory]
Error: ERROR 103
(08004): Unable to establish connection. (state=08004,code=103)
java.sql.SQLException: ERROR 103 (08004): Unable to establish
connection. at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:422)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:392) at
org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:211) at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2269) at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248) at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78) at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248) at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135) at
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202) at
sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) at
sqlline.Commands.connect(Commands.java:1064)
at
sqlline.Commands.connect(Commands.java:996) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at
java.lang.reflect.Method.invoke(Method.java:498) at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) at
sqlline.SqlLine.dispatch(SqlLine.java:804) at
sqlline.SqlLine.initArgs(SqlLine.java:588) at
sqlline.SqlLine.begin(SqlLine.java:656) at
sqlline.SqlLine.start(SqlLine.java:398) at
sqlline.SqlLine.main(SqlLine.java:292)
Caused by:
java.io.IOException: Login failure for hbase/Principal_Name@Domain from keytab
/opt/app/svc-edl-dpc-ngmp-dev/svc-edl-dpc-ngmp-dev.keytab:
javax.security.auth.login.LoginException: Unable to obtain password from user at
org.apache.hadoop.security.UserGroupInformation.loginUserFromKeytab(UserGroupInformation.java:962) at
org.apache.hadoop.security.SecurityUtil.login(SecurityUtil.java:243) at
org.apache.hadoop.hbase.security.User$SecureHadoopUser.login(User.java:420) at
org.apache.hadoop.hbase.security.User.login(User.java:258) at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:380) ... 22
more Caused by: javax.security.auth.login.LoginException: Unable
to obtain password from user at
com.sun.security.auth.module.Krb5LoginModule.promptForPass(Krb5LoginModule.java:897) at
com.sun.security.auth.module.Krb5LoginModule.attemptAuthentication(Krb5LoginModule.java:760) at
com.sun.security.auth.module.Krb5LoginModule.login(Krb5LoginModule.java:617) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at
java.lang.reflect.Method.invoke(Method.java:498)
at
javax.security.auth.login.LoginContext.invoke(LoginContext.java:755) at
javax.security.auth.login.LoginContext.access$000(LoginContext.java:195) at
javax.security.auth.login.LoginContext$4.run(LoginContext.java:682)
at
javax.security.auth.login.LoginContext$4.run(LoginContext.java:680) at
java.security.AccessController.doPrivileged(Native Method) at
javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680) at
javax.security.auth.login.LoginContext.login(LoginContext.java:587) at
org.apache.hadoop.security.UserGroupInformation.loginUserFromKeytab(UserGroupInformation.java:953) ... 26
more sqlline version 1.1.8
0: jdbc:phoenix:zk-host:/>
Command canceled. 0: jdbc:phoenix:zk-host:/>
... View more
Labels: