Re: Azure Blob storage backed secure cluster not working with Phoenix

2017-10-30 Thread rafa
in : http://beadooper.com/?p=409 Regards, rafa On Mon, Oct 30, 2017 at 12:43 PM, Mallieswari Dineshbabu < dmalliesw...@gmail.com> wrote: > Hi All, > > > > I have a Hadoop(version 2.7.2) - HBase(version 1.2.5) Kerberos enabled > secure cluster configured with default f

Re: Cannot connect phoenix client in kerberos cluster

2017-10-20 Thread rafa
in the cluster with the used keytab? could you regenerate the keytab? have you started the queryserver with the keytab and the log confirms it has authenticated correctly? regards, rafa On Thu, Oct 19, 2017 at 7:55 AM, Mallieswari Dineshbabu < dmalliesw...@gmail.com> wrote: > Hi Rafa, >

Re: Phoenix client failed when used HACluster name on hbase.rootdir property

2017-10-12 Thread rafa
You cannot use "hacluster" if that hostname is not resolved to a IP. Is what I tried to explain in my last mail. Use the ip of te machine that is running query server or its hostname Regards Rafa El 12 oct. 2017 6:19, "Mallieswari Dineshbabu" <dmalliesw...@gmail.co

Re: Phoenix client failed when used HACluster name on hbase.rootdir property

2017-10-11 Thread rafa
in.py http://hacluster:8765 is a hostname resource. What do you obtain from nslookup hacluster ? To have serveral Phoenix query servers to achieve HA in that layer you would need a balancer (sw or hw) defined to balance across all your available query servers. Regards, rafa On Wed, Oct 11, 2017

Re: Cannot connect phoenix client in kerberos cluster

2017-10-11 Thread rafa
principal and keytab. The access to query server : sqlline-thin.py http://hostname:8765 Regards, rafa

Re: Cannot connect phoenix client in kerberos cluster

2017-10-09 Thread rafa
Hi Mallieswari: *Method 1:* python sqlline-thin.py http://hostname:8765 This should be enough to connect to Phoenix query server. Increase the Phoenix Qeury Server log file level to see if there is a problem with it. regards, rafa On Fri, Oct 6, 2017 at 11:28 AM, Mallieswari Dineshbabu

Re: Phoenix- Client Shell Exception when starting phoenix thin client service in windows environment

2017-10-05 Thread rafa
ttp://repo1.maven.org/maven2/jline/jline/2.14.5/ regards rafa On Thu, Oct 5, 2017 at 2:53 PM, Mallieswari Dineshbabu < dmalliesw...@gmail.com> wrote: > > > > Hi all, > > > > > > I have facing "NoClassDefFoundError" When execute the phoenix thin

Re: Cannot connect phoenix client in kerberos cluster

2017-10-05 Thread rafa
Dineshbabu < dmalliesw...@gmail.com> wrote: > Yes, It is installed in all the JVMs. Any other solution. > > > On Wed, Oct 4, 2017 at 5:30 PM, rafa <raf...@gmail.com> wrote: > >> Hi Mallieswari, >> >> Perhaps the Java Cryptography Extension (JCE) Un

Re: Cannot connect phoenix client in kerberos cluster

2017-10-04 Thread rafa
Hi Mallieswari, Perhaps the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files are not installed in all the JVMs ? Regards, rafa On Wed, Oct 4, 2017 at 1:18 PM, Mallieswari Dineshbabu < dmalliesw...@gmail.com> wrote: > Hi , > > > > I have

Re: Support of OFFSET in Phoenix 4.7

2017-09-06 Thread rafa
Hi Sumanta, Here you have the answer. You already asked the same question some months ago :) https://mail-archives.apache.org/mod_mbox/phoenix-user/201705.mbox/browser >From 4.8 regards, rafa On Wed, Sep 6, 2017 at 9:19 AM, Sumanta Gh <sumanta...@tcs.com> wrote: > Hi, > Fro

Re: how to modify column in phoenix?

2017-06-16 Thread rafa
Hi, As far as I know there is no support for that in Phoenix. James Taylor explained an alternative to accomplish that in this thread: https://mail-archives.apache.org/mod_mbox/phoenix-user/201610.mbox/browser Regards, rafa On Fri, Jun 16, 2017 at 10:33 AM, 曾柏棠 <zengbait...@qq.com>

Re: pagination

2017-05-18 Thread rafa
6] *https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12334393=12315120 <https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12334393=12315120>* [7] https://phoenix.apache.org/download.html Regards, rafa On Thu, May 18, 2017 at 2:04 PM, rafa <raf...@gmail.com> wrote: &g

Re: pagination

2017-05-18 Thread rafa
Ups...sorry my mistake. The Jira is for limit - offset with orderby. sorry. On Thu, May 18, 2017 at 2:02 PM, rafa <raf...@gmail.com> wrote: > Hi Sumanta, > > I think it is not supported yet: > > https://issues.apache.org/jira/browse/PHOENIX-3353 > > Best regards, >

Re: pagination

2017-05-18 Thread rafa
Hi Sumanta, I think it is not supported yet: https://issues.apache.org/jira/browse/PHOENIX-3353 Best regards, rafa On Thu, May 18, 2017 at 1:52 PM, Sumanta Gh <sumanta...@tcs.com> wrote: > Hi, > From which version of Phoenix LIMIT-OFFSET based pagination is supported? >

Re: Phoenix connection to kerberized hbase fails

2017-04-19 Thread rafa
- offline032.dx.momo.com@MOMO.OFFLINE ? Regards, rafa On Wed, Apr 19, 2017 at 12:46 PM, Reid Chan <reidddc...@outlook.com> wrote: > Hi rafa, > > I followed the guides on site: > https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/ > bk_command-line-installation/conten

Re: Phoenix connection to kerberized hbase fails

2017-04-19 Thread rafa
of the working cluster core-site.xml in your client machine? regards, rafa On Wed, Apr 19, 2017 at 11:51 AM, Reid Chan <reidddc...@outlook.com> wrote: > Version infomation, phoenix: phoenix-4.10.0-HBase-1.2, hbase: hbase-1.2.4 > > > > -- > View this message in context: http://apa

Re: Problem connecting JDBC client to a secure cluster

2017-04-18 Thread rafa
Hi Sergey, Josh, Thank you very much for your comments !! Best Reagrds, Rafa. On Tue, Apr 18, 2017 at 5:29 AM, Sergey Soldatov <sergeysolda...@gmail.com> wrote: > That's not hbase-site.xml loaded incorrectly. This is the behavior of java > classpath. It's accept only jars and dir

Re: Problem connecting JDBC client to a secure cluster

2017-04-11 Thread rafa
eption while reading:Authentication is required Thanks !! Best Regards, rafa On Tue, Apr 11, 2017 at 4:05 PM, rafa <raf...@gmail.com> wrote: > Hi everybody !, > > We have a CDH 5.8 kerberized cluster in which we have installed Apache > Phoenix 4.7 (via CLABS parcel). Ever

Problem connecting JDBC client to a secure cluster

2017-04-11 Thread rafa
che.hadoop.hbase.protobuf.generated.MasterProtos$MasterService$BlockingInterface It seems that the JDBC driver is not trying to authenticate to Hbase. Perhaps some of you have faced a similar situation or could point me to a new direction. Thank you very much for your help ! Best Regards, rafa.

Re: Retiring empty regions

2017-03-24 Thread rafa
Hi, For everyone to know, Nick has published the script for retiring empty regions in : https://issues.apache.org/jira/browse/HBASE-15712 Nick, Thank you very much for your help and great work !!! Best Regards, Rafa. On Mon, Mar 6, 2017 at 5:49 PM, rafa <raf...@gmail.com> wrote: >

Re: Retiring empty regions

2017-03-06 Thread rafa
Hi Nick, We are facing the same issue. Increasingly number of empty regions derived from TTL and Timestamp in row key. Did you finally published that scripts? Are they available for public usage? Thank you very much in advance for your work and help, Best Regards, rafa On Thu, Apr 21, 2016

Re: problems about using phoenix over hbase

2016-04-19 Thread rafa
Hi, test with: create view if not exists "test" (pk VARCHAR primary key, "family"."number" INTEGER); regards, rafa On Tue, Apr 19, 2016 at 12:58 PM, 金砖 <jinzh...@wacai.com> wrote: > I'm new to phoenix > using phoenix-4.7.0-HBase-1.1 on hbase-1.1

Re: Phoenix for CDH5 compatibility

2016-04-16 Thread rafa
Hi Swapna, You can download the official parcel from Cloudera, although it is not the last phoenix version. http://archive.cloudera.com/cloudera-labs/phoenix/parcels/latest/ If you want to use higher versions you'll have to compile them against the cdh libraries Regards, Rafa El 16/04/2016

Re: org.apache.phoenix.join.MaxServerCacheSizeExceededException

2016-02-10 Thread rafa
. - Attempting to serializing the raw results of a relation with a size bigger than this setting will result in a MaxServerCacheSizeExceededException. - *Default: 104,857,600* Regards, rafa On Wed, Feb 10, 2016 at 1:37 PM, Nanda <tnkish...@gmail.com> wrote: > Hi , > >

Re: Using Sqoop to load HBase tables , Data not visible via Phoenix

2016-01-28 Thread rafa
Hi Manya, see this thread: http://mail-archives.apache.org/mod_mbox/incubator-phoenix-user/201512.mbox/%3CCAOnY4Jd6u9T8-Ce2Lp54CbH_a8zj41FVc=iXT=z8hp8-mxv...@mail.gmail.com%3E http://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table regards, rafa On Thu, Jan 28

Re: Question about support for ARRAY data type with Pig Integration

2016-01-11 Thread rafa
Hi Kiran, Thank you very much for the information and your work ! Best Regards, rafa. On Sat, Jan 9, 2016 at 8:53 AM, Ravi Kiran <maghamraviki...@gmail.com> wrote: > Hi Rafa, > >I will be working on this ticket > https://issues.apache.org/jira/browse/PHOENIX-2584. Yo

Question about support for ARRAY data type with Pig Integration

2015-12-23 Thread rafa
in advance, Best Regards, rafa.

Re: Is it possible to run the phoenix query server on a machine other than the regionservers?

2015-12-17 Thread rafa
think so. Copy the hbase-site.xml from the cluster into the new query Server machine and set the directory where the xml resides in the classpath of the Query Server. That should be enough, Regards rafa On Thu, Dec 17, 2015 at 12:21 PM, F21 <f21.gro...@gmail.com> wrote: > Hey Raf

Re: ConcurrentModificationException when making concurrent requests through Phoenix Query Server

2015-11-25 Thread rafa
"I don't know if there is a problem with our Phoenix Query Server configuration, which is the default one" I meant, Thanks !! On Wed, Nov 25, 2015 at 5:08 PM, rafa <raf...@gmail.com> wrote: > Hi all ! > > We are using Apache Phoenix 4.5.2. We are making some tests fro

ConcurrentModificationException when making concurrent requests through Phoenix Query Server

2015-11-25 Thread rafa
Phoenix Query Server, which is the default one, or there is some kind of problem when pooling connections from an application server to the Query Server, Thank you very much for your help, Best Regards, Rafa

Problem setting an alternate Phoenix Query Server Listen Port

2015-11-20 Thread rafa
Hi all ! We are having some trouble setting Phoenix Query Server listen port other than the deafult one. It seems that it is not taking the property. setting the property: phoenix.queryserver.http.port 8300 in the local bin directory inside the hbase-site.xml and starting query server: