Re: [ANNOUNCE] Apache Phoenix 4.13 released

gt; in PHOENIX-3736) > > Cheers. > > On 27 Nov 2017 08:28, "Kumar Palaniappan" <kpalaniap...@marinsoftware.com> > wrote: > >> Thanks @james. >> >> Since this patch(Phoenix-4372) is tightly coupled with CDH5.11.2, would >> like to get the 4.13HB

Re: [ANNOUNCE] Apache Phoenix 4.13 released

;> available (HBase 1.2) somewhere? >> >> Best, >> Flavio >> >> On Thu, Nov 23, 2017 at 7:33 AM, Kumar Palaniappan < >> kpalaniap...@marinsoftware.com> wrote: >> >>> @Jmaes, are you still planning to release 4.13HBase1.2? >>> >&g

Re: [ANNOUNCE] Apache Phoenix 4.13 released

SS threads. > > Thanks, > James > > [1] https://lists.apache.org/thread.html/5b8b44acb1d3608770309767c3cdde > cbc6484c29452fe6750d8e1516@%3Cdev.phoenix.apache.org%3E > [2] https://lists.apache.org/thread.html/70cffa798d5f21ef87b02e07aeca8c > 7982b0b30251411b7be17fadf9@%3Cdev.phoenix.

Re: [ANNOUNCE] Apache Phoenix 4.13 released

Thanks James. Sure will look into it from my end n update. Currently we are focused on the ZK connection leak https://issues.apache.org/jira/browse/PHOENIX-4247 https://issues.apache.org/jira/browse/PHOENIX-4319 Kumar Palaniappan > On Nov 19, 2017, at 1:21 PM, James Taylor <ja

Re: [ANNOUNCE] Apache Phoenix 4.13 released

Are there any plans to release Phoenix 4.13 compatible with HBase 1.2? On Sat, Nov 11, 2017 at 5:57 PM, James Taylor wrote: > The Apache Phoenix team is pleased to announce the immediate availability > of the 4.13.0 release. Apache Phoenix enables SQL-based OLTP and >

Connection issue with Spark/Phoenix/ZK

After upgrading to CDH 5.9.1/Phoenix 4.10/Spark 1.6 from CDH 5.5.2/Phoenix 4.6/Spark 1.5, streaming jobs that read data from Phoenix no longer release their zookeeper connections, meaning that the number of connections from the driver grow with each batch until the ZooKeeper limit on connections

Phoenix Connection

After we did upgrade to 4.10 on a CDH 5.10, we do see too many ZK connections (increased the max connections form 60->300->1000), but the problem still exist. Are there any known issues? Phoenix connection leak? Appreciate your time.

Re: Duplicate rows with the PK

Deleting the table entries from system stats helped to get rid of duplicates. Problem to be monitored during the high growth. Kumar Palaniappan > On Aug 28, 2017, at 11:48 AM, James Taylor <jamestay...@apache.org> wrote: > > Is the table salted? If the SALT_BUCKETS property w

Duplicate rows with the PK

For a weird reason, if we do scan on a table, with a non key, there are duplicate rows in the table. If we do look up with the complete RK of a table, it doesnt show the duplicates. What could be wrong? Appreciate your time. Similar as this one

Re: Combining an RVC query and a filter on a datatype smaller than 8 bytes causes an Illegal Data Exception

The problem is when we have just 1 param in the rvc it works. but this one , for 2+ SELECT * FROM TEST.RVC_TEST WHERE (COLONE, COLTWO) IN ((1,2),(1,2)) AND COLTHREE=3; blows up. On Mon, Sep 19, 2016 at 3:58 PM, Kumar Palaniappan < kpalaniap...@marinsoftware.com> wrote: > No

Re: Combining an RVC query and a filter on a datatype smaller than 8 bytes causes an Illegal Data Exception

wrote: > Kumar, > > Can you try with the 4.8 release? > > > > On Mon, Sep 19, 2016 at 2:54 PM, Kumar Palaniappan < > kpalaniap...@marinsoftware.com> wrote: > >> >> Any one had faced this issue? >> >> https://issues.apache.org/jira/browse/PH

Re: Cloning a table in Phoenix

Will do James. On Fri, Sep 9, 2016 at 10:27 AM, James Taylor <jamestay...@apache.org> wrote: > Good idea - this would make a great contribution. Please file a JIRA. > > On Fri, Sep 9, 2016 at 6:29 AM, Kumar Palaniappan < > kpalaniap...@marinsoftware.com> wrote: >

Re: Cloning a table in Phoenix

Yes James. Kumar Palaniappan > On Sep 9, 2016, at 12:53 AM, Heather, James (ELS-LON) > <james.heat...@elsevier.com> wrote: > > This does rather suggest that it would be fairly easy to implement a SHOW > CREATE TABLE statement. Is that right? > > It would

Re: Cloning a table in Phoenix

Yes, we found a way to do off of system.catalog In the meantime, trying to to explore are there any off the shelves options. Thanks dalin. Kumar Palaniappan > On Sep 8, 2016, at 6:43 PM, dalin.qin <dalin...@gmail.com> wrote: > > Hi Kumar, > > I believe righ

Re: Cloning a table in Phoenix

It's not about data. Would like to clone just the table structure(s) under the schema partially or entire tables. Kumar Palaniappan > On Sep 8, 2016, at 5:48 PM, dalin.qin <dalin...@gmail.com> wrote: > > try this: > > 0: jdbc:phoenix:namenode:2181:/hbase-unsecure>

Cloning a table in Phoenix

What is an easy solution or is there a solution to clone the table/schema in phoenix? Thanks in advance.

Disable Index

While data migration, we simply drop the indices on the tables and recreate. Would like to avoid. Is there disable all index syntax in phoenix grammar? How do we disable an index? If we disable index in phoenix and rebuild what does that translates to phoenix intercepting WAL? We know rebuilding

Re: Announcing phoenix-for-cloudera 4.6.0

s the expected year to 2015). > > > On Thu, Jan 28, 2016 at 11:23 AM, Andrew Purtell <apurt...@apache.org> > wrote: > >> Looking today >> >> >> On Tue, Jan 26, 2016 at 11:00 PM, Kumar Palaniappan < >> kpalaniap...@marinsoftware.com> wrote: >

Re: Announcing phoenix-for-cloudera 4.6.0

Andrew, any updates? Seem HBase-11544 impacted the Phoenix and CDH 5.5.1 isnt working. On Sun, Jan 17, 2016 at 11:25 AM, Andrew Purtell wrote: > This looks like something easy to fix up. Maybe I can get to it next week. > > > On Jan 15, 2016, at 9:07 PM, Krishna

Re: Having Global covered Index

Thanks James. Do we need an index on a pk column, since it's a last element in the rowkey, to speed up the query? ( because of this, write won't be impacted on that table) we do leverage the call queue. Kumar Palaniappan > On Jan 18, 2016, at 10:07 AM, James Taylor <ja

Having Global covered Index

We have a table *create table t1 ( a bigint not null, a1 bigint not null, b bigint not null, c varchar, d varchar pk_constraint "t1_pk" (a, a1,b))* create a global indices as - *create index id_t1 on t1 (b) include (a,a1,c,d)* - this one is to speed up filtering on b since it is the last

Re: array of BIGINT index

Thanks James. We will look into it. we need to find a way to overcome the full scan. On Wed, Jan 6, 2016 at 9:26 AM, James Taylor <jamestay...@apache.org> wrote: > In that case, you'd need PHOENIX-1544 to be implemented. > > On Wed, Jan 6, 2016 at 8:52 AM, Kumar Palaniappa

array of BIGINT index

We have a table with a data type BIGINT[], Since phoenix doesnt support to index this data type, our queries are doing a full table scan when we have to do filtering on this field. What are the alternate approaches? Tried looking into Views, but nope. Appreciate your time. Kumar

Re: array of BIGINT index

; > > In this case, the following query would use the index: > SELECT K FROM T WHERE A[3] = 5; > > Does this help for your usage? > > Thanks, > James > > On Tue, Jan 5, 2016 at 2:51 PM, Kumar Palaniappan < > kpalaniap...@marinsoftware.com> wrote: > >&

Re: Help tuning for bursts of high traffic?

same > problem at first blush. > > > On Dec 4, 2015, at 1:27 PM, Kumar Palaniappan < > kpalaniap...@marinsoftware.com> wrote: > > working on getting it. the problem is where to store the file...working > with our IT :( > > It's on your way. > > On Fri, Dec 4,

[no subject]

I'm getting this when I use sqlline. I compiled phoenix4.4 with cdh5.4 along with code changes and pom changes. Any clue? Appreciate your time. Error: ERROR 103 (08004): Unable to establish connection. (state=08004,code=103) java.sql.SQLException: ERROR 103 (08004): Unable to establish

Re:Connection error with Phoenix 4.4

Re-sending with the subject. On Sun, Jun 21, 2015 at 3:51 PM, Kumar Palaniappan kpalaniap...@marinsoftware.com wrote: I'm getting this when I use sqlline. I compiled phoenix4.4 with cdh5.4 along with code changes and pom changes. Any clue? Appreciate your time. Error: ERROR 103 (08004

JPA-Phoenix/HBase

We are exploring using a JPA implementation to persist objects into HBase using Phoenix SQL. Curious to know if anyone is exploring the same. Appreciate the sync-up.