Hi Sun, Yes, that sounds weird. I'm not sure if it would help but I am using CDH 5.5.2. I do copy phoenix-server, client and the core jar on all the hbase region and master servers. After the jar copy, restart hbase master, region-server and zookeeper.
Regards, Amit. On Tue, Mar 1, 2016 at 4:05 PM, Fulin Sun <[email protected]> wrote: > Hi, Amit > The command line is ./sqlline.py <zkServer>:2181 . I had no idea why all > regionservers would be killed > when I issue the command initially. Is this because createing SYSTEM > tables would cause regionserver down? > But I did not find any error message from the regionserver log. That is > supre weird. > > ------------------------------ > ------------------------------ > > > *From:* Amit Shah <[email protected]> > *Date:* 2016-03-01 19:02 > *To:* user <[email protected]> > *Subject:* Re: Re: HBase Phoenix Integration > Hi Sun, > > In my deployment I have only one zookeeper node. I do not have cluster. > What was your command line string to connect? Did you specify the port > number? > I specify this ./sqlline.py <zookeeper-server-name>:2181 > > Regards, > Amit. > > On Tue, Mar 1, 2016 at 3:38 PM, Fulin Sun <[email protected]> wrote: > >> Hi, Amit >> I had successfully built the git repo according to your file change. But >> when I try to use sqlline to connect to Phoenix, >> I ran into the following error: >> >> while dev-1,dev-2,dev-3 are my zookeeper hosts. I can still see the >> regionservers being killed abnormally. >> >> Had you met this issue when you use in your scenerio ? If so, please >> suggest how to resolve this. >> >> Thanks. >> >> Connecting to jdbc:phoenix:dev-1,dev-2,dev-3 >> >> 16/03/01 18:04:17 WARN util.NativeCodeLoader: Unable to load native-hadoop >> library for your platform... using builtin-java classes where applicable >> Error: Failed after attempts=36, exceptions: >> >> Tue Mar 01 18:05:30 CST 2016, null, java.net.SocketTimeoutException: >> callTimeout=60000, callDuration=69350: row 'SYSTEM.SEQUENCE,,00000000000000' >> on table 'hbase:meta' at region=hbase:meta,,1.1588230740, >> hostname=dev-2,60020,1456826584858, seqNum=0 (state=08000,code=101) >> >> org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, >> exceptions: >> >> Tue Mar 01 18:05:30 CST 2016, null, java.net.SocketTimeoutException: >> callTimeout=60000, callDuration=69350: row 'SYSTEM.SEQUENCE,,00000000000000' >> on table 'hbase:meta' at region=hbase:meta,,1.1588230740, >> hostname=dev-2,60020,1456826584858, seqNum=0 >> >> ------------------------------ >> >> *From:* Amit Shah <[email protected]> >> *Date:* 2016-03-01 18:00 >> *To:* user <[email protected]> >> *Subject:* Re: Re: HBase Phoenix Integration >> Sure Sun. >> PFA. >> >> Regards, >> Amit. >> >> On Tue, Mar 1, 2016 at 2:58 PM, Fulin Sun <[email protected]> wrote: >> >>> Hi Amit, >>> Glad you found a temporory fix for that. Can you share the relative >>> java file you modified ? >>> Thanks a lot. >>> >>> Best, >>> Sun. >>> >>> ------------------------------ >>> ------------------------------ >>> >>> >>> *From:* Amit Shah <[email protected]> >>> *Date:* 2016-03-01 17:22 >>> *To:* user <[email protected]> >>> *Subject:* Re: RE: HBase Phoenix Integration >>> Hi All, >>> >>> I got some success in deploying phoenix 4.6-HBase-1.0 on CDH 5.5.2. I >>> resolved the compilation errors by commenting out the usage of >>> BinaryCompatibleIndexKeyValueDecoder and >>> BinaryCompatibleCompressedIndexKeyValueDecoder classes since they only >>> get used in secondary indexing. This is a temporary fix but yes it works ! >>> >>> Hope that helps. >>> Waiting to see the phoenix-cloudera fix for the latest phoenix version >>> 4.7 especially since 4.7 has some new features. >>> >>> Thanks, >>> Amit. >>> >>> On Tue, Mar 1, 2016 at 2:13 PM, Fulin Sun <[email protected]> >>> wrote: >>> >>>> No idea. I had only searched for this relatively latest post for >>>> supporting phoenix with CDH 5.5.x >>>> However, I cannot connect to phoenix according to the post guide. >>>> Compiling the git repo had also >>>> give me no luck. >>>> >>>> >>>> ------------------------------ >>>> ------------------------------ >>>> >>>> >>>> *From:* Dor Ben Dov <[email protected]> >>>> *Date:* 2016-03-01 16:39 >>>> *To:* [email protected] >>>> *Subject:* RE: Re: HBase Phoenix Integration >>>> >>>> Sun >>>> >>>> This is an old post there, do you know or are there any news about >>>> Cloudera Adopting the new Apache Phoenix 4.7 ? >>>> >>>> >>>> >>>> Dor >>>> >>>> >>>> >>>> *From:* Fulin Sun [mailto:[email protected]] >>>> *Sent:* יום ג 01 מרץ 2016 09:14 >>>> *To:* user; James Taylor >>>> *Subject:* Re: Re: HBase Phoenix Integration >>>> >>>> >>>> >>>> Hi Amit >>>> >>>> Yeah. Meet the same error message when doing mvn package. I compared >>>> between the apache phoenix 4.6.0-hbase-1.0 >>>> >>>> code with this repo code for CDH 5.5.1 , I did not find the abstract >>>> class BinaryCompatiblePhoenixBaseDecoder in the former. >>>> >>>> Hope some guy can explain this and issue an workaround. >>>> >>>> >>>> >>>> If no way to resolve this, I would still be using the Cloudera-Labs >>>> phoenix version from this : >>>> >>>> >>>> https://blog.cloudera.com/blog/2015/11/new-apache-phoenix-4-5-2-package-from-cloudera-labs/ >>>> >>>> >>>> >>>> >>>> Thanks, >>>> >>>> Sun. >>>> >>>> >>>> ------------------------------ >>>> ------------------------------ >>>> >>>> >>>> >>>> *From:* Amit Shah <[email protected]> >>>> >>>> *Date:* 2016-03-01 15:37 >>>> >>>> *To:* user <[email protected]>; jamestaylor >>>> <[email protected]> >>>> >>>> *Subject:* Re: HBase Phoenix Integration >>>> >>>> Hi James, >>>> >>>> I get a compilation error along with multiple warnings when >>>> packaging 4.6-HBase-1.0-cdh5.5 branch. Attached is the error. >>>> >>>> >>>> >>>> Also I realized that the pom.xml indicates the branch is for cloudera >>>> CDH version 5.5.1. Do you know if it would work for the latest CDH version >>>> 5.5.2? >>>> >>>> >>>> >>>> Thanks, >>>> >>>> Amit. >>>> >>>> >>>> >>>> On Tue, Mar 1, 2016 at 12:05 PM, Dor Ben Dov <[email protected]> >>>> wrote: >>>> >>>> James, >>>> >>>> Do you have any problems working with Phoenix latest with CDH 5.5.X ? >>>> >>>> >>>> >>>> Dor >>>> >>>> >>>> >>>> *From:* James Taylor [mailto:[email protected]] >>>> *Sent:* יום ג 01 מרץ 2016 08:24 >>>> *To:* user >>>> *Cc:* Murugesan, Rani >>>> *Subject:* Re: HBase Phoenix Integration >>>> >>>> >>>> >>>> Hi Amit, >>>> >>>> >>>> >>>> For Phoenix 4.6 on CDH, try using this git repo instead, courtesy of >>>> Andrew Purtell: >>>> https://github.com/chiastic-security/phoenix-for-cloudera/tree/4.6-HBase-1.0-cdh5.5 >>>> >>>> >>>> >>>> Thanks, >>>> >>>> James >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Mon, Feb 29, 2016 at 10:19 PM, Amit Shah <[email protected]> wrote: >>>> >>>> Hi Sergey, >>>> >>>> >>>> >>>> I get lot of compilation errors when I compile the source code >>>> for 4.6-HBase-1.0 branch or v4.7.0-HBase-1.0-rc3 tag. Note that the source >>>> compilation succeeds when the changes to include cloudera dependent >>>> versions are not included. The only difference between the code changes >>>> suggested on the stackoverflow post and mine is the cloudera cdh version. I >>>> am using cdh 5.5.2. I didn't quite follow the reason behind the code >>>> changes needed in phoenix when deployed on CDH. >>>> >>>> >>>> >>>> Thanks, >>>> >>>> Amit. >>>> >>>> >>>> >>>> On Tue, Mar 1, 2016 at 1:15 AM, Sergey Soldatov < >>>> [email protected]> wrote: >>>> >>>> Hi Amit, >>>> >>>> Switching to 4.3 means you need HBase 0.98. What kind of problem you >>>> experienced after building 4.6 from sources with changes suggested on >>>> StackOverflow? >>>> >>>> Thanks, >>>> Sergey >>>> >>>> >>>> On Sun, Feb 28, 2016 at 10:49 PM, Amit Shah <[email protected]> wrote: >>>> > An update - >>>> > >>>> > I was able to execute "./sqlline.py <zookeeper-server-name>" command >>>> but I >>>> > get the same exception as I mentioned earlier. >>>> > >>>> > Later I tried following the steps mentioned on this link with phoenix >>>> 4.3.0 >>>> > but I still get an error this time with a different stack trace >>>> (attached to >>>> > this mail) >>>> > >>>> > Any help would be appreciated >>>> > >>>> > On Sat, Feb 27, 2016 at 8:03 AM, Amit Shah <[email protected]> >>>> wrote: >>>> >> >>>> >> Hi Murugesan, >>>> >> >>>> >> What preconditions would I need on the server to execute the python >>>> >> script? I have Python 2.7.5 installed on the zookeeper server. If I >>>> just >>>> >> copy the sqlline script to the /etc/hbase/conf directory and execute >>>> it I >>>> >> get the below import errors. Note this time I had 4.5.2-HBase-1.0 >>>> version >>>> >> server and core phoenix jars in HBase/lib directory on the master >>>> and region >>>> >> servers. >>>> >> >>>> >> Traceback (most recent call last): >>>> >> File "./sqlline.py", line 25, in <module> >>>> >> import phoenix_utils >>>> >> ImportError: No module named phoenix_utils >>>> >> >>>> >> Pardon me for my knowledge about python. >>>> >> >>>> >> Thanks, >>>> >> Amit >>>> >> >>>> >> On Fri, Feb 26, 2016 at 11:26 PM, Murugesan, Rani <[email protected] >>>> > >>>> >> wrote: >>>> >>> >>>> >>> Did you test and confirm your phoenix shell from the zookeeper >>>> server? >>>> >>> >>>> >>> cd /etc/hbase/conf >>>> >>> >>>> >>> > phoenix-sqlline.py <zookeeperserver>:2181 >>>> >>> >>>> >>> >>>> >>> >>>> >>> >>>> >>> >>>> >>> From: Amit Shah [mailto:[email protected]] >>>> >>> Sent: Friday, February 26, 2016 4:45 AM >>>> >>> To: [email protected] >>>> >>> Subject: HBase Phoenix Integration >>>> >>> >>>> >>> >>>> >>> >>>> >>> Hello, >>>> >>> >>>> >>> >>>> >>> >>>> >>> I have been trying to install phoenix on my cloudera hbase cluster. >>>> >>> Cloudera version is CDH5.5.2 while HBase version is 1.0. >>>> >>> >>>> >>> >>>> >>> >>>> >>> I copied the server & core jar (version 4.6-HBase-1.0) on the >>>> master and >>>> >>> region servers and restarted the hbase cluster. I copied the >>>> corresponding >>>> >>> client jar on my SQuirrel client but I get an exception on connect. >>>> Pasted >>>> >>> below. The connection url is >>>> “jdbc:phoenix:<zookeeper-server-name>:2181". >>>> >>> >>>> >>> I even tried compiling the source by adding cloudera dependencies as >>>> >>> suggested on this post but didn't succeed. >>>> >>> >>>> >>> >>>> >>> >>>> >>> Any suggestions to make this work? >>>> >>> >>>> >>> >>>> >>> >>>> >>> Thanks, >>>> >>> >>>> >>> Amit. >>>> >>> >>>> >>> >>>> >>> >>>> >>> ________________________________________________________________ >>>> >>> >>>> >>> >>>> >>> >>>> >>> Caused by: >>>> >>> >>>> org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException): >>>> >>> org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG: >>>> >>> >>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:87) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1319) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:11715) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7388) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1776) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1758) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32209) >>>> >>> >>>> >>> at >>>> >>> org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2034) >>>> >>> >>>> >>> at >>>> >>> org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130) >>>> >>> >>>> >>> at >>>> >>> org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107) >>>> >>> >>>> >>> at java.lang.Thread.run(Thread.java:745) >>>> >>> >>>> >>> Caused by: java.lang.NoSuchMethodError: >>>> >>> >>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildDeletedTable(MetaDataEndpointImpl.java:1016) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.loadTable(MetaDataEndpointImpl.java:1092) >>>> >>> >>>> >>> at >>>> >>> >>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1266) >>>> >>> >>>> >>> ... 10 more >>>> >>> >>>> >>> >>>> >>> >>>> >>> P.S - The full stacktrace is attached in the mail. >>>> >> >>>> >> >>>> > >>>> >>>> >>>> >>>> >>>> >>>> This message and the information contained herein is proprietary and >>>> confidential and subject to the Amdocs policy statement, you may review at >>>> http://www.amdocs.com/email_disclaimer.asp >>>> >>>> >>>> >>>> >>> >> >
