Issue in connecting with HBase using Hortonworks

2014-09-01 Thread Vikas Agarwal
Hi, We have installed Hadoop cluster using Hortonworks distribution and trying to connect the Phoenix with HBase. However, even after following the steps mentioned here http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1.3/bk_installing_manually_book/content/rpm-chap-phoenix.html, we are not

Re: Issue in connecting with HBase using Hortonworks

2014-09-01 Thread Vikas Agarwal
Yes, I am using HDP 2.1 and installed Phoenix via yum and it installed 4.0.0 of phoenix. Added symlink to the phoenix-core*jar into /usr/lib/hbase/lib and I did restart after these changes. However, now, I am able to connect with HBase. Somehow, SYSTEM.CATALOG was got created in one of my earlier

Re: Issue in connecting with HBase using Hortonworks

2014-09-01 Thread James Taylor
Hi Vikas, Glad you got it working. Just curious - why did you install Phoenix via yum when the HDP 2.1 already comes pre-installed with Phoenix? Thanks, James On Mon, Sep 1, 2014 at 10:16 AM, Vikas Agarwal vi...@infoobjects.com wrote: Yes, I am using HDP 2.1 and installed Phoenix via yum and it

Re: Issue in connecting with HBase using Hortonworks

2014-09-01 Thread Vikas Agarwal
I didn't see Phoenix as option anywhere in Ambari and I found this http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1.3/bk_installing_manually_book/content/rpm-chap-phoenix.html Did I miss something in Ambari for Phoenix? On Mon, Sep 1, 2014 at 11:01 PM, James Taylor jamestay...@apache.org

Kerberos Secure cluster and phoenix

2014-09-01 Thread Deepak_Gattala
Hi all, Any one has success doing a Phoenix connection to a secure Hbase Hadoop cluster, if yes can you please kindly let me know the steps taken, I am on the recent version of phoenix and using Cloudera CDH 5.1 with hbase 0.98. Appreciate your help. Thanks Deepak Gattala

Re: Kerberos Secure cluster and phoenix

2014-09-01 Thread James Taylor
In addition to the above, in our 3.1/4.1 release, you can pass through the principal and keytab file on the connection URL to connect to different secure clusters, like this: DriverManager.getConnection(jdbc:phoenix:h1,h2,h3:2181:user/principal:/user.keytab); The full URL is now of the form

RE: Kerberos Secure cluster and phoenix

2014-09-01 Thread Deepak_Gattala
I am getting this following error really appreciate any comments. please Error: com.google.protobuf.ServiceException: java.io.IOException: Call to ausgtmhadoop10.us-poclab.dellpoc.com/192.168.1.100:6 failed on local exception: java.io.EOFException (state=08000,code=101)

Re: Kerberos Secure cluster and phoenix

2014-09-01 Thread anil gupta
Hi Deepak, What version of phoenix you are using? Phoenix 3.1 and 4.1 support connecting to secure Hadoop/HBase cluster out of the box(Phoenix-19). Are you running HBase on a fully distributed cluster? I would recommend you to use *phoenix-*-client-without-hbase.jar file.* Use following command

RE: Kerberos Secure cluster and phoenix

2014-09-01 Thread Deepak_Gattala
Hi Anil, Thanks for sharing the details, I am now getting the error like. 14/09/01 18:17:33 ERROR client.HConnectionManager$HConnectionImplementation: Can't get connection to ZooKeeper: KeeperErrorCode = AuthFailed for /hbase Are you familiar with this, it looks like its having issues

Re: Kerberos Secure cluster and phoenix

2014-09-01 Thread anil gupta
Hi Deepak, AFAIK, jaas.conf is not required when using OOTB feature of connecting to a secure cluster. It seems like User connecting to secure HBase cluster does not have proper permission setup for znode of ZK. Can you check the permission of znode /hbase and make sure that User has proper

Re: Kerberos Secure cluster and phoenix

2014-09-01 Thread Alex Kamil
looks like phoenix is trying to create SYSTEM.CATALOG table ( ensureTableCreated) but is not able to pass through kerberos (HConnectionManager error), i've seen this when supplying incorrect kerberos credentials or not using keytab at all. You would see exact reason if you enable kerberos debug

RE: Kerberos Secure cluster and phoenix

2014-09-01 Thread Deepak_Gattala
Well I am upgrading from 4.0 to 4.1 which means that I already have the table SYSTEM.CATALOG in place. One last quick question. I just want to know one thing what user it will use to communicate to hbase when you invoke sqlline? Please kindly let me know. Is that the same use I logged in as?

Re: Kerberos Secure cluster and phoenix

2014-09-01 Thread anil gupta
Then also it needs to check whether SYSTEM.CATALOG table is there or not. Sqlline will try to login as user that invoked sqlline.sh command. On Mon, Sep 1, 2014 at 5:26 PM, deepak_gatt...@dell.com wrote: Well I am upgrading from 4.0 to 4.1 which means that I already have the table

[ANNOUNCE] Apache Phoenix 3.1 and 4.1 released

2014-09-01 Thread James Taylor
Hello everyone, On behalf of the Apache Phoenix team, I'm pleased to announce the immediate availability of our 3.1 and 4.1 releases: http://phoenix.apache.org/download.html These include many bug fixes along with support for nested/derived tables, tracing, and local indexing. For details of the

Re: Kerberos Secure cluster and phoenix

2014-09-01 Thread Alex Kamil
..and reg My hbase runs as user hbase, but I login as deepak_gattala - your phoenix client has to run as user hbase On Mon, Sep 1, 2014 at 10:08 PM, Alex Kamil alex.ka...@gmail.com wrote: also hbase/ is missing in the principal name Client { com.sun.security.auth.module.Krb5LoginModule

Re: Issue in connecting with HBase using Hortonworks

2014-09-01 Thread Vikas Agarwal
Yes, that is what I understood from docs. I thought I missed something because James said it is inbuilt with HDP 2.1 now. Now, I got it. It is in HDP 2.1's repository but not in ambari. :) On Tue, Sep 2, 2014 at 5:29 AM, Devaraj Das d...@hortonworks.com wrote: Vikas, Phoenix installation is