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 >>> >>> >>> >>> >> >
