Hi All,  I have developed Spring boot application to read data from hbase via phoenix. the application creats new phoenix connection all the time and due to which high memory usage results in app crash. Please suggest   ... View more

Hi Team, i have added Hbase client and phoenix core jar which has hbase client jar within it.   I have the hbase and core site xmls.   i get the Hconnection established message. But then i get  "MESSAGE":"Reading reply sessionid:0x200239e26e51663, packet:: clientPath:/hbase serverPath:/hbase finished:false header:: 16,8 replyHeader:: 16,313534022349,0 request:: '/hbase,F response:: v{'meta-region-server,'rs,'splitWAL,'backup-masters,'flush-table-proc,'master-maintenance,'online-snapshot,'switch,'master,'running,'tokenauth,'draining,'namespace,'hbaseid,'table I get this message repatedly.  I am doubting if my hbase.site.xml is getting loaded properly. How can i verify if it is loaded properly. What could be the issue ... View more

Hi Team, i have added Hbase client and phoenix core jar which has hbase client jar within it.   I have the hbase and core site xmls.   i get the Hconnection established message. But then i get  "MESSAGE":"Reading reply sessionid:0x200239e26e51663, packet:: clientPath:/hbase serverPath:/hbase finished:false header:: 16,8 replyHeader:: 16,313534022349,0 request:: '/hbase,F response:: v{'meta-region-server,'rs,'splitWAL,'backup-masters,'flush-table-proc,'master-maintenance,'online-snapshot,'switch,'master,'running,'tokenauth,'draining,'namespace,'hbaseid,'table   What could be the issue ... View more

Can you please provide the list of configurations to be set for phoenix connection. ... View more

Hi Willx,   I want to connect to phoenix via thick client and can you please suggest the jars required for thick client and phoenix connection url.   For authentication i am using kerberos ticket cache, can you please suggest the right phoenix url for the same. ... View more

From the documentation you shared for thin client it seems we need to use a avatica certificate and username , password onboarded on to Avatica.   In that case i need to go with thick client only.  Can you please support me on my issue. ... View more

Hi willx, am using the thick client and it is the same format as in the documentation you have just shared am using in my code. To informm you i donot have a keytab but i have kerberos cache which ma pointing to.   And for the thin client: jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF; authentication=SPNEGO;principal=pqs@EXAMPLE.COM;keytab=/etc/security/keytabs/phoenix.keytab what should be the value for url , here it is 8765 port, which is that server with 8765 port.   Also from my logs i see that , "Trying to connect to a secure cluster as a024563@EXCHAD.JPMCHASE.NET with keytab /app/jpmc_bsid/ccache/ccache_a024563.crd"} 2023-04-18T07:43:00.509+05:30 [APP/PROC/WEB/0] [OUT] {"TIMESTAMP":"2023-04-17 22:13:00.509/EDT","LEVEL":"INFO ","POOL":"na-3z","ENV":"dev","THREAD":"[http-nio-8080-exec-3]", application-id: slot-web-gaia, "SERV":"100.127.13.51:61010","CF_INSTANCE_INDEX":"0,,"CF_INSTANCE_GUID":"e7bc4234-666b-4cb3-7ef9-12fa,"MESSAGE":"Successful login to secure cluster"}   By this is it that the login to CDP is success and then is the issue with query now or authentication am getting. ... View more

Hi willx, please let me know if we an option to setup a call and understand or clarify my doubts ... View more

Hi willx, I have validated from sqlline script. It is connecting successfully. From my application am using the phoenix jdbc url in below formats: 1. jdbc:phoenix:[***zookeeper_quorum***]:[***zookeeper_port***]:[***zookeeper_hbase_path***] 2. jdbc:phoenix:thin:url=http://queryserver.domain:8765;serialization=PROTOBUF;authentication=SPENGO;principal=phoenix@EXAMPLE.COM;keytab=/etc/security/keytabs/phoenix.keytab   I am not clear as to what is the right phoenix url to be used from the java application ... View more

HI Vidya, Thanks for the reply. I ma trying multiple ways to establish the connectivity from Java to CDP Phoenix. Am getting the same error from all approaches. 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithRetries(RpcRetryingCallerImpl.java:145) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.HTable.get(HTable.java:384) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.HTable.get(HTable.java:358) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.MetaTableAccessor.getTableState(MetaTableAccessor.java:1118) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.MetaTableAccessor.tableExists(MetaTableAccessor.java:440) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.HBaseAdmin$6.rpcCall(HBaseAdmin.java:469) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.HBaseAdmin$6.rpcCall(HBaseAdmin.java:466) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.RpcRetryingCallable.call(RpcRetryingCallable.java:58) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithRetries(RpcRetryingCallerImpl.java:107) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] ... 154 more 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] Caused by: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Call to bdtcstr153n9.svr.us.jpmchase.net/169.23.107.110:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosedException: Connection closed 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.IPCUtil.wrapException(IPCUtil.java:201) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.AbstractRpcClient.onCallFinished(AbstractRpcClient.java:378) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.AbstractRpcClient.access$100(AbstractRpcClient.java:91) 2023-04-18T14:36:14.302+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.AbstractRpcClient$3.run(AbstractRpcClient.java:409) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.AbstractRpcClient$3.run(AbstractRpcClient.java:405) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.Call.callComplete(Call.java:117) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.Call.setException(Call.java:132) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.NettyRpcDuplexHandler.cleanupCalls(NettyRpcDuplexHandler.java:203) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hadoop.hbase.ipc.NettyRpcDuplexHandler.channelInactive(NettyRpcDuplexHandler.java:211) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:262) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:248) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:241) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.handler.codec.ByteToMessageDecoder.channelInputClosed(ByteToMessageDecoder.java:386) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.handler.codec.ByteToMessageDecoder.channelInactive(ByteToMessageDecoder.java:351) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:262) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:248) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:241) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.ChannelInboundHandlerAdapter.channelInactive(ChannelInboundHandlerAdapter.java:81) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.handler.timeout.IdleStateHandler.channelInactive(IdleStateHandler.java:277) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:262) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:248) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:241) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.DefaultChannelPipeline$HeadContext.channelInactive(DefaultChannelPipeline.java:1405) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:262) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:248) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.DefaultChannelPipeline.fireChannelInactive(DefaultChannelPipeline.java:901) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.AbstractChannel$AbstractUnsafe$8.run(AbstractChannel.java:818) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:497) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] at org.apache.hbase.thirdparty.io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) 2023-04-18T14:36:14.303+05:30 [APP/PROC/WEB/0] [ERR] ... 1 more       ... View more