[ANNOUNCE] Apache Phoenix 5.2.0 is now available for download

The Apache Phoenix team is pleased to announce the immediate availability of Phoenix 5.2.0. Apache Phoenix enables SQL-based OLTP and operational analytics for Apache Hadoop using Apache HBase as its backing store and provides integration with other projects in the Apache ecosystem such as Spark,

Participate in the ASF 25th Anniversary Campaign

Hi everyone, As part of The ASF’s 25th anniversary campaign[1], we will be celebrating projects and communities in multiple ways. We invite all projects and contributors to participate in the following ways: * Individuals - submit your first contribution:

Community Over Code NA 2024 Travel Assistance Applications now open!

Hello to all users, contributors and Committers! [ You are receiving this email as a subscriber to one or more ASF project dev or user mailing lists and is not being sent to you directly. It is important that we reach all of our users and contributors/committers so that they may get a chance

[ANNOUNCE] Phoenix Omid 1.1.2 released

Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 1.1.2 release of the Phoenix Omid. Phoenix Omid (Optimistically transaction Management In Datastores*)* is a flexible, reliable, high performant and scalable transactional framework that allows Big

UPDATE_CACHE_FREQUENCY on tables with a ROW_TIMESTAMP column

Hi, It seems that the UPDATE_CACHE_FREQUENCY setting is ignored on tables with a ROW_TIMESTAMP column set. This results in an RPC call to fetch the SYSTEM.CATALOG table for every query to such a table and resulting hotspotting on the node assigned the system catalog region. I was wondering if

Community Over Code Asia 2024 Travel Assistance Applications now open!

Hello to all users, contributors and Committers! The Travel Assistance Committee (TAC) are pleased to announce that travel assistance applications for Community over Code Asia 2024 are now open! We will be supporting Community over Code Asia, Hangzhou, China July 26th - 28th, 2024. TAC exists

[ANNOUNCE] Phoenix Omid 1.1.1 released

Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 1.1.1 release of the Phoenix Omid. Highlights of this releases are: - JDK 17 support - TLS support - Changed default commit store module to HBase from InMemory. - Various dependency version updates.

Community over Code EU 2024 Travel Assistance Applications now open!

Hello to all users, contributors and Committers! The Travel Assistance Committee (TAC) are pleased to announce that travel assistance applications for Community over Code EU 2024 are now open! We will be supporting Community over Code EU, Bratislava, Slovakia, June 3th - 5th, 2024. TAC exists

[no subject]

Hello to all users, contributors and Committers! The Travel Assistance Committee (TAC) are pleased to announce that travel assistance applications for Community over Code EU 2024 are now open! We will be supporting Community over Code EU, Bratislava, Slovakia, June 3th - 5th, 2024. TAC exists

Re: [ANNOUNCE] Lokesh Khurana as Phoenix Committer

Congratulations! On Thu, Jan 18, 2024 at 6:48 PM Kadir Ozdemir wrote: > Congratulations Lokesh! > > On Thu, Jan 18, 2024 at 10:58 PM Rushabh Shah > wrote: > > > Congratulations Lokesh !! > > > > > > > > > > On Wed, Jan 17, 2024 at 9:26 AM Viraj Jasani wrote: > > > > > On behalf of the Apache

Re: [ANNOUNCE] Lokesh Khurana as Phoenix Committer

Congratulations Lokesh! On Thu, Jan 18, 2024 at 10:58 PM Rushabh Shah wrote: > Congratulations Lokesh !! > > > > > On Wed, Jan 17, 2024 at 9:26 AM Viraj Jasani wrote: > > > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Lokesh > > Khurana has accepted the PMC's invitation to

Re: [ANNOUNCE] Lokesh Khurana as Phoenix Committer

Congratulations Lokesh!! On Wed, Jan 17, 2024, 10:55 PM Viraj Jasani wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Lokesh > Khurana has accepted the PMC's invitation to become a committer on Apache > Phoenix. > > We appreciate all of the great contributions Lokesh

Re: [ANNOUNCE] Lokesh Khurana as Phoenix Committer

Congratulations, Lokesh! On Wed, Jan 17, 2024 at 12:25 PM Viraj Jasani wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Lokesh > Khurana has accepted the PMC's invitation to become a committer on Apache > Phoenix. > > We appreciate all of the great contributions Lokesh

[ANNOUNCE] Lokesh Khurana as Phoenix Committer

On behalf of the Apache Phoenix PMC, I'm pleased to announce that Lokesh Khurana has accepted the PMC's invitation to become a committer on Apache Phoenix. We appreciate all of the great contributions Lokesh has made to the community thus far and we look forward to his continued involvement.

Re: Engineering blog post on HBase/Phoenix major upgrade without downtime

Great article! And congratulations on the successful upgrade! Viraj Jasani 于2024年1月13日周六 08:21写道： > > Hello, > > We have completed major upgrade of HBase/Phoenix from 1.6/4.16 to 2.4/5.1 > versions and continuing journey to 2.5 release in production. Would like to > share some insights on how

Engineering blog post on HBase/Phoenix major upgrade without downtime

Hello, We have completed major upgrade of HBase/Phoenix from 1.6/4.16 to 2.4/5.1 versions and continuing journey to 2.5 release in production. Would like to share some insights on how we achieved in-place rolling upgrade of major release without any downtime. Here is the Engineering Blog on

[ANNOUNCE] Phoenix Thirdparty 2.1.0 released

Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 2.1.0 release of the Phoenix Thirdparty project. This project is used by the Apache Phoenix project to encapsulate a number of core dependencies that Phoenix relies upon ensuring that they are

Re: [ANNOUNCE] New Phoenix PMC member Jacob Isaac

Congratulations Jacob Isaac! Well deserved! On Mon, Nov 6, 2023 at 6:12 PM rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote: > Congratulations Jacob Isaac!! > > Thanks, > Rajeshbabu. > > On Tue, Nov 7, 2023, 7:37 AM Viraj Jasani wrote: > > > On behalf of the Apache Phoenix PMC, I'm

Re: [ANNOUNCE] New Phoenix PMC member Jacob Isaac

Congratulations Jacob Isaac!! Thanks, Rajeshbabu. On Tue, Nov 7, 2023, 7:37 AM Viraj Jasani wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Jacob > Isaac has accepted the invitation to join the PMC. > > We appreciate all of the great contributions Jacob has made to

[ANNOUNCE] New Phoenix PMC member Jacob Isaac

On behalf of the Apache Phoenix PMC, I'm pleased to announce that Jacob Isaac has accepted the invitation to join the PMC. We appreciate all of the great contributions Jacob has made to the community thus far and we look forward to his continued involvement. Please join me in congratulating

Registration open for Community Over Code North America

Hello! Registration is still open for the upcoming Community Over Code NA event in Halifax, NS! We invite you to register for the event https://communityovercode.org/registration/ Apache Committers, note that you have a special discounted rate for the conference at US$250. To take advantage of

Re: [ANNOUNCE] Rushabh Shah as Phoenix Committer

Congratulations Rushabh !! On Wed, Aug 23, 2023 at 10:15 PM Istvan Toth wrote: > Congratulations Rushabh! > > > On Thu, Aug 24, 2023 at 2:11 AM rajeshb...@apache.org < > chrajeshbab...@gmail.com> wrote: > >> Congratulations Rushabh! >> >> Thanks, >> Rajeshbabu. >> >> On Thu, Aug 24, 2023, 5:37

Re: [ANNOUNCE] Rushabh Shah as Phoenix Committer

Congratulations Rushabh! On Thu, Aug 24, 2023 at 2:11 AM rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote: > Congratulations Rushabh! > > Thanks, > Rajeshbabu. > > On Thu, Aug 24, 2023, 5:37 AM rajeshb...@apache.org < > chrajeshbab...@gmail.com> wrote: > >> Congratulations Rushabh! >> >>

Re: [ANNOUNCE] Rushabh Shah as Phoenix Committer

Congratulations Rushabh! Thanks, Rajeshbabu. On Thu, Aug 24, 2023, 5:37 AM rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote: > Congratulations Rushabh! > > Thanks, > Rajeshbabu. > > On Thu, Aug 24, 2023, 4:35 AM Xinyi Yan wrote: > >> Congratulations Rushabh! >> >> Sent from my iPhone >>

Re: [ANNOUNCE] Rushabh Shah as Phoenix Committer

Congratulations Rushabh! Thanks, Rajeshbabu. On Thu, Aug 24, 2023, 4:35 AM Xinyi Yan wrote: > Congratulations Rushabh! > > Sent from my iPhone > > > On Aug 23, 2023, at 3:37 PM, Andrew Purtell > wrote: > > > > Congratulations and welcome, Rushabh! > > > >> On Aug 15, 2023, at 1:46 PM, Viraj

Re: [ANNOUNCE] Rushabh Shah as Phoenix Committer

Congratulations Rushabh! Sent from my iPhone > On Aug 23, 2023, at 3:37 PM, Andrew Purtell wrote: > > Congratulations and welcome, Rushabh! > >> On Aug 15, 2023, at 1:46 PM, Viraj Jasani wrote: >> >> On behalf of the Apache Phoenix PMC, I'm pleased to announce that Rushabh >> Shah has

Re: [ANNOUNCE] Rushabh Shah as Phoenix Committer

Congratulations and welcome, Rushabh! > On Aug 15, 2023, at 1:46 PM, Viraj Jasani wrote: > > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Rushabh > Shah has accepted the PMC's invitation to become a committer on Apache > Phoenix. > > We appreciate all of the great

Re: Problem with phoenix-queryserver (6.0.0)

You need to copy the appropriate phoenix-client-embdedded JAR to the lib directory. Also see https://github.com/apache/phoenix-queryserver/blob/6.0.0/BUILDING.md On Mon, Aug 21, 2023 at 6:35 AM Kal Stevens wrote: > I have installed the phoenix-queryserver (6.0.0), but I am getting this > error

Problem with phoenix-queryserver (6.0.0)

I have installed the phoenix-queryserver (6.0.0), but I am getting this error message /hadoop/phoenix/phoenix-queryserver-6.0.0/bin/queryserver.py:71: DeprecationWarning: 'pipes' is deprecated and slated for removal in Python 3.13 import pipes# pipes module isn't available on Windows

Re: Having Trouble with Phoenix + Hbase

Thanks that worked On Sat, Aug 19, 2023 at 4:54 PM rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote: > This could be because phoenix-server jar missing in HBase classpath. > > Could you please copy phoenix-server jar from phoenix into $HBASE_HOME/lib > path in all the nodes, restart HBase

Re: Having Trouble with Phoenix + Hbase

This could be because phoenix-server jar missing in HBase classpath. Could you please copy phoenix-server jar from phoenix into $HBASE_HOME/lib path in all the nodes, restart HBase and start sqlline. https://phoenix.apache.org/installation.html Thanks, Rajeshbabu. On Sun, Aug 20, 2023, 4:34

Having Trouble with Phoenix + Hbase

I am new to setting up a cluster, and I feel like I am doing something dumb. I get the following error message when I run sqlline to create a table, and I am not sure what I am doing wrong. I know that in on the classpath for SQLLine, but I think it is making an RPC call to hbase. But I am not

Re: [ANNOUNCE] Rushabh Shah as Phoenix Committer

Congrats, Rushabh! On Tue, Aug 15, 2023 at 3:28 PM Kadir Ozdemir wrote: > Congratulations Rushabh! > > On Tue, Aug 15, 2023 at 10:46 AM Viraj Jasani wrote: > > > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Rushabh > > Shah has accepted the PMC's invitation to become a

Re: [ANNOUNCE] Rushabh Shah as Phoenix Committer

Congratulations Rushabh! On Tue, Aug 15, 2023 at 10:46 AM Viraj Jasani wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Rushabh > Shah has accepted the PMC's invitation to become a committer on Apache > Phoenix. > > We appreciate all of the great contributions Rushabh

[ANNOUNCE] Rushabh Shah as Phoenix Committer

On behalf of the Apache Phoenix PMC, I'm pleased to announce that Rushabh Shah has accepted the PMC's invitation to become a committer on Apache Phoenix. We appreciate all of the great contributions Rushabh has made to the community thus far and we look forward to his continued involvement.

Re: Missing columns in SYSTEM.LOG after upgrading to 5.1.3

> If you can afford to lose the data in SYSTEM.LOG, then the easiest fix > is to drop SYSTEM.LOG. > Phoenix will re-create it with the correct columns on the next > connection. Thanks for advice! May be we will choose this way. > Please file a JIRA with this information. Ok! -- Андрей Хозов

Re: Missing columns in SYSTEM.LOG after upgrading to 5.1.3

What version did you upgrade from ? What columns do you have after the upgrade ? Have you started Phoenix at least once with HBase superuser privileges (RWXC) after the upgrade ? Please file a JIRA with this information. If you can afford to lose the data in SYSTEM.LOG, then the easiest fix is to

Missing columns in SYSTEM.LOG after upgrading to 5.1.3

Hi everyone! After upgrading to Phoenix 5.1.3 we started getting errors in log: ERROR 504 (42703): Undefined column. columnName=SYSTEM.LOG.CLIENT_METADATA_CACHE_MISS_COUNTER After that I found that we have no 8 columns in our SYSTEM.LOG table:

Apache Phoenix

H i S e n t f r o m M a i l f o r W i n d o w s

Re:

This is covered on the website: https://phoenix.apache.org/installation.html On Wed, Jul 26, 2023 at 1:52 PM Sravani Surapureddy < sravanisurapureddy...@gmail.com> wrote: > Can you provide installation steps for Phoenix >

[no subject]

Can you provide installation steps for Phoenix

Re: Not setting python major version in QS scripts

Hi. We have no plans to drop python2 support in the foreseeable future, unless it becomes too unwieldy to keep supporting it. You can set the default python version in RHEL easily, and as I have not seen this error on our RHEL 8 systems, this seems to be picked up by /usr/bin/env:

Not setting python major version in QS scripts

Hi all, We are building and distributing Phoenix in a stack derived from Apache Hadoop and Hbase. We are having a very minor issue with the QueryServer and I'm curious of your opinions. The provided `queryserver.py` script uses "#!/usr/bin/env python". However this does not resolve on our

TAC Applications for Community Over Code North America and Asia now open

Hi All, (This email goes out to all our user and dev project mailing lists, so you may receive this email more than once.) The Travel Assistance Committee has opened up applications to help get people to the following events: *Community Over Code Asia 2023 - * *August 18th to August 20th in

Re: How to access patch-unit-phoenix-core.txt file while tests are still running?

You need to have an account on the ASF Jenkins for that. Log in to https://ci-hadoop.apache.org/. Go to Phoenix/Phoenix-PreCommit-GitHub-PR/Pull Requests Click the link for the gitHub PR (PR-) Click the topmost, running job Click workspaces Drill down in the directories until you find

Re: How to issue query with filter on UUID ?

Thank you Istvan. Get Outlook for iOS From: Istvan Toth Sent: Monday, February 6, 2023 3:33:21 AM To: user@phoenix.apache.org Subject: Re: How to issue query with filter on UUID ? Phoenix has only added the ability to specify a binary

Re: How to issue query with filter on UUID ?

Phoenix has only added the ability to specify a binary literal in PHOENIX-6764 , but that is not available in any released version yet. Currently the only way to specify binary strings in a query is via PreparedStatment.setBytes() in JDBC. It is

How to issue query with filter on UUID ?

Hi Phoenix Experts, I've never sent an email to an alias like this, so hope I'm doing the right thing. I'm working on a more complex query, but have my problem reduced to something simple. I'm hoping someone can help me with. Given the following tables (see HOSTED_APPS_METADATA_UUID in yellow

[ANNOUNCE] Apache Phoenix 5.1.3 is now available for download

The Apache Phoenix team is pleased to announce the immediate availability of Phoenix 5.1.3. Apache Phoenix enables SQL-based OLTP and operational analytics for Apache Hadoop using Apache HBase as its backing store and provides integration with other projects in the Apache ecosystem such as Spark,

Re: [ANNOUNCE] New Phoenix PMC member Tanuj Khurana

Congratulations! On Tue, Jan 3, 2023 at 9:50 AM Kadir Ozdemir wrote: > Congratulations Tanuj! Well deserved. > > On Tue, Jan 3, 2023 at 9:17 AM Xinyi Yan wrote: > > > Congratulations! > > > > Sent from my iPhone > > > > > On Jan 3, 2023, at 8:50 AM, Rushabh Shah .invalid> > > wrote: > > > > >

Re: [ANNOUNCE] New Phoenix PMC member Tanuj Khurana

Congratulations Tanuj! Well deserved. On Tue, Jan 3, 2023 at 9:17 AM Xinyi Yan wrote: > Congratulations! > > Sent from my iPhone > > > On Jan 3, 2023, at 8:50 AM, Rushabh Shah > > > wrote: > > > > Congratulations Tanuj ! Well deserved. > > > > > >> On Mon, Jan 2, 2023 at 8:17 PM Viraj Jasani

Re: [ANNOUNCE] New Phoenix PMC member Tanuj Khurana

Congratulations! Sent from my iPhone > On Jan 3, 2023, at 8:50 AM, Rushabh Shah > wrote: > > Congratulations Tanuj ! Well deserved. > > >> On Mon, Jan 2, 2023 at 8:17 PM Viraj Jasani wrote: >> >> On behalf of the Apache Phoenix PMC, I'm pleased to announce that Tanuj >> Khurana has

Re: [ANNOUNCE] New Phoenix PMC member Tanuj Khurana

Congratulations Tanuj Khurana. Thanks, Rajeshbabu. On Tue, Jan 3, 2023, 9:47 AM Viraj Jasani wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Tanuj > Khurana has accepted the invitation to join the PMC. > > We appreciate all of the great contributions Tanuj has made

[ANNOUNCE] New Phoenix PMC member Tanuj Khurana

On behalf of the Apache Phoenix PMC, I'm pleased to announce that Tanuj Khurana has accepted the invitation to join the PMC. We appreciate all of the great contributions Tanuj has made to the community thus far and we look forward to his continued involvement. Please join me in congratulating

Always using client side timestamp

Hey guys, I'm using phoenix 5.1.2; When execute query 'upsert into ... values' on a table without any timestamp row, the cell timestamp in hbase will be set to the one on client side. ```sql create table students(id interger primary key, name varchar); upsert into students values(1, 'id1');

[ANNOUNCE] Python Driver for Apache Phoenix (phoenixdb) 1.2.1 released

Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 1.2.1 release of the Python Driver for Apache Phoenix. The Python Driver for Apache Phoenix implements the Python DB 2.0 API to access Phoenix via the Phoenix Query Server. This release includes the

[ANNOUNCE] Phoenix Omid 1.1.0 released

Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 1.1.0 release of the Phoenix Omid. Highlights of this release are: - Dropped support for HBase 1.x - Changed maven packaging and coordinates for the artifacts. See OMID-222 for details - Omid is

Re: [ANNOUNCE] Richard Antal joins Phoenix PMC

Many Congratulations Richard! On Thu, Sep 29, 2022 at 7:12 PM rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Richard > Antal > has accepted our invitation to join the PMC. > > We appreciate all of the great

Re: [ANNOUNCE] Richard Antal joins Phoenix PMC

Congratulations, Richard! On Fri, Sep 30, 2022 at 8:38 AM Geoffrey Jacoby wrote: > Congratulations, Richard! > > On Thu, Sep 29, 2022 at 10:12 PM rajeshb...@apache.org < > chrajeshbab...@gmail.com> wrote: > >> On behalf of the Apache Phoenix PMC, I'm pleased to announce that >> Richard Antal >>

Re: [ANNOUNCE] Richard Antal joins Phoenix PMC

Congratulations, Richard! On Thu, Sep 29, 2022 at 10:12 PM rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Richard > Antal > has accepted our invitation to join the PMC. > > We appreciate all of the great contributions

[ANNOUNCE] Richard Antal joins Phoenix PMC

On behalf of the Apache Phoenix PMC, I'm pleased to announce that Richard Antal has accepted our invitation to join the PMC. We appreciate all of the great contributions Richard has made to the community thus far and we look forward to his continued involvement. Please join me in congratulating

Re: Unable to do count(*) on hbase view

You need to increase phoenix.query.queueSize and/or phoenix.stats.guidepost.width. The number of guideposts in your table must not exceed phoenix.query.queueSize, otherwise full scans will fail. see https://phoenix.apache.org/tuning.html On Tue, Sep 20, 2022 at 8:02 PM KhajaAsmath Mohammed <

Timeout with Apache Phenonix

HI, I have set up below properties in hbase-site.xml but I stil get error with timeout. /usr/lib/phoenix/bin/sqlline-thin.py ip-10-120-1-129.qa.i-edo.net I have set this in hbase-site.xml of phoenix and hbase too. phoenix.query.timeoutMs 1800 phoenix.query.timeoutMs

Fwd: Unable to do count(*) on hbase view

> > > Hi, > > I am new to phoenix. I am doing simple count(*) on view and it throws me > exception. Select * from table limit 5 works though. Any suggestions on > this please? > > *select count(*) from "prewards_event";* > > Error: Error -1 (0) : Error while executing SQL "select count(*) from

Subscribe

Re: Unable to do count(*) on hbase view

On Tue, Sep 20, 2022 at 12:14 PM KhajaAsmath Mohammed < mdkhajaasm...@gmail.com> wrote: > Hi, > > I am new to phoenix. I am doing simple count(*) on view and it throws me > exception. Select * from table limit 5 works though. Any suggestions on > this please? > > *select count(*) from

Re: Phoenix Index tool deletes data from main table and does not populate local index

Hi, This list is for the Apache Phoenix releases. If you use a vendor version, please contact your vendor for support. regards Istvan On Mon, Aug 22, 2022 at 7:21 PM Pradheep Shanmugam via user < user@phoenix.apache.org> wrote: > HI, > > I am using CDP 7.3.1 > I am trying create a phoenix

Phoenix Index tool deletes data from main table and does not populate local index

HI, I am using CDP 7.3.1 I am trying create a phoenix local index for already existing table with ~14M rows. Following are the steps I did. 1. take snapshot of table from hbase (table is salted in phoenix) 2. clone the snapshot to new test table 3. create the table in phoenix to link the phoenix

Re: Is anyone using OMID or Tephra in production?

Hi! I'm unfortunately not the big hiding transactional user that we're looking for, but I'd like to add the following: - Omid is part of my employer's HBase / Phoenix offerings. We're supporting it, and have no plans to drop it. - We have limited visibility into its actual usage, I

Is anyone using OMID or Tephra in production?

At my employer we maintain a fork of Phoenix that we try to keep as close to open source as possible given our internal requirements. One issue we are facing in recent months is a tightening corporate policy on the presence of known software vulnerabilities in our dependencies. Of course, this

Re: Phoenix upgrade from 4.7.0(base 1.1.2) to 5.1.2(base 2.3.0) is failing with ColumnNotFoundException

Thanks a lot Istvan Toth for sharing this usefull information. I took this PHOENIX-6534 changes applied on release-5.1.2, built and used phoenix-core-5.1.2.jar. It worked. Phoenix clients connected succesfully. Thanks once again. On 25/07/22, 12:54 PM, "Istvan Toth" wrote: Yes, this is

Re: Phoenix upgrade from 4.7.0(base 1.1.2) to 5.1.2(base 2.3.0) is failing with ColumnNotFoundException

Yes, this is PHOENIX-6534. There is no released Apache version with the fix, you need to manually apply the fix to 5.1.2, or use the 5.1 branch head. regards István On Fri, Jul 22, 2022 at 10:35 PM Arshad, Mohammad wrote: > Hello All, > > > > Upgraded HBase from 1.1.2 to 2.3.0. After applying

Phoenix upgrade from 4.7.0(base 1.1.2) to 5.1.2(base 2.3.0) is failing with ColumnNotFoundException

Hello All, Upgraded HBase from 1.1.2 to 2.3.0. After applying HBASE-25902, hbase upgrade was successful. But phoenix upgrade from version 4.7.0(hbase version 1.1.2) to 5.1.2(hbase version 2.3,0) is failing with following error. 22/07/18 10:53:26 WARN query.ConnectionQueryServicesImpl:

Re: [ANNOUNCE] New VP Apache Phoenix

Thank you very much Ankit and the whole community for giving me this opportunity. Thanks, Rajeshbabu. On Wed, Jul 20, 2022 at 12:48 PM Viraj Jasani wrote: > Thank you Ankit, it was great to have you as our VP!! > Congratulations Rajeshbabu, really glad to have you as our new VP!! > > > On Mon,

Re: [ANNOUNCE] New VP Apache Phoenix

Thank you Ankit, it was great to have you as our VP!! Congratulations Rajeshbabu, really glad to have you as our new VP!! On Mon, Jul 18, 2022 at 3:50 PM Ankit Singhal wrote: > I am pleased to announce that we have a new PMC chair > and VP for Phoenix. ASF board approved the transition from >

[ANNOUNCE] New VP Apache Phoenix

I am pleased to announce that we have a new PMC chair and VP for Phoenix. ASF board approved the transition from me to Rajeshbabu post an agreement by the Phoenix PMC. This is a part of our tradition we adopted last year to change a VP every year, and we thank Rajeshbabu for volunteering to serve

[ANNOUNCE] Python Driver for Apache Phoenix (phoenixdb) 1.2.0 released

Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 1.2.0 release of the Python Driver for Apache Phoenix. The Python Driver for Apache Phoenix implements the Python DB 2.0 API to access Phoenix via the Phoenix Query Server. This release includes the

Re: [ANNOUNCE] Gokcen Iskender joins Phoenix PMC

Well deserved, many congratulations Gokcen! On Tue, Jul 5, 2022 at 12:22 PM Geoffrey Jacoby wrote: > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Gokcen > Iskender > has accepted our invitation to join the PMC. > > Please join me in congratulating Gokcen! > > Thanks, > >

[ANNOUNCE] Gokcen Iskender joins Phoenix PMC

On behalf of the Apache Phoenix PMC, I'm pleased to announce that Gokcen Iskender has accepted our invitation to join the PMC. Please join me in congratulating Gokcen! Thanks, Geoffrey Jacoby

[FINAL CALL] - Travel Assistance to ApacheCon New Orleans 2022

To all committers and non-committers. This is a final call to apply for travel/hotel assistance to get to and stay in New Orleans for ApacheCon 2022. Applications have been extended by one week and so the application deadline is now the 8th July 2022. The rest of this email is a copy of what

RE: MaxServerCacheSizeExceedException while Upsert in Phoenix Table

Hello Team, We are getting this error while Upsert into the table in phoenix in spark application. Caused by : org.apache.phoenix.join.MaxServerCacheSizeExceedException: size of hash cache (104857669 bute) exceeds the maximum allowed size (104857600). We are using Apache phoenix 5.0.0 Hbase 2.0

Re: [ANNOUNCE] End of Development for HBase 1.x Compatible Phoenix Versions

The 4.x and 4.16.x branches are going to stay, and if anyone volunteers to commit backports to them, or even make new releases from them, they are welcome to do so. Also, as the reason for avoiding using Java 8 features was to ease backporting to the 4.x branches, we no longer have to effectively

[ANNOUNCE] End of Development for HBase 1.x Compatible Phoenix Versions

The Apache Phoenix team announces the end of development of Apache Phoenix for Apache HBase 1.x versions. Since the release of Phoenix 5.0 in 2018, Phoenix has supported both the legacy HBase 1.x versions with its 4.x releases , and the current HBase 2.x versions with its 5.x releases. >From now

[ANNOUNCE] Retirement of the Apache Phoenix Tephra Sub-project

The Apache Phoenix team announces the retirement of the Apache Phoenix Tephra sub-project. Due to the lack of volunteers to maintain Tephra, The Apache Phoenix team ends all development on the Tephra sub-project. There are no new releases of Tephra planned, and Tephra support is going to be

Final reminder: ApacheCon North America call for presentations closing soon

[Note: You're receiving this because you are subscribed to one or more Apache Software Foundation project mailing lists.] This is your final reminder that the Call for Presetations for ApacheCon North America 2022 will close at 00:01 GMT on Monday, May 23rd, 2022. Please don't wait! Get your talk

REMINDER - Travel Assistance available for ApacheCon NA New Orleans 2022

Hi All Contributors and Committers, This is a first reminder email that travel assistance applications for ApacheCon NA 2022 are now open! We will be supporting ApacheCon North America in New Orleans, Louisiana, on October 3rd through 6th, 2022. TAC exists to help those that would like to

[ANNOUNCE] Phoenix Thirdparty 2.0.0 released

Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 2.0.0 release of the Phoenix Thirdparty project. This project is used by the Apache Phoenix project to encapsulate a number of core dependencies that Phoenix relies upon ensuring that they are

Re: Invitation: Apache Phoenix Tech Talk @ Thu Apr 7, 2022 9am - 10:30am (PDT) (d...@phoenix.apache.org)

The slides and recording have been uploaded at https://phoenix.apache.org/tech_talks.html. Thank you for your interest and patience. Kadir On Thu, Apr 7, 2022 at 8:52 PM Cong Luo wrote: > Hello, > > When will we upload the meeting record files? I can't wait any longer. > > On 2022/03/31

Tech Talk - JSON Support for Apache Phoenix

Hi All, We will have another very interesting tech talk session tomorrow. Gokcen Iskender will talk about upcoming JSON support in Phoenix at 9 am (PDT). You can join the meeting using this link . For more information

Invitation: Apache Phoenix Tech Talk @ Thu Apr 7, 2022 9am - 10:30am (PDT) (user@phoenix.apache.org)

BEGIN:VCALENDAR PRODID:-//Google Inc//Google Calendar 70.9054//EN VERSION:2.0 CALSCALE:GREGORIAN METHOD:REQUEST BEGIN:VEVENT DTSTART:20220407T16Z DTEND:20220407T173000Z DTSTAMP:20220331T190121Z ORGANIZER;CN=ka...@gsuite.cloud.apache.org:mailto:kadir@gsuite.cloud.apache .org

Call for Presentations now open, ApacheCon North America 2022

[You are receiving this because you are subscribed to one or more user or dev mailing list of an Apache Software Foundation project.] ApacheCon draws participants at all levels to explore “Tomorrow’s Technology Today” across 300+ Apache projects and their diverse communities. ApacheCon showcases

Re: Bugs with multiple LAST_VALUE aggregation on multiple columns

My bad, it's in the phoenixDB readme: https://github.com/apache/phoenix-queryserver/blob/master/python-phoenixdb/README.rst On Thu, Mar 17, 2022 at 9:38 PM Simon Mottram wrote: > Hi > > There's no README.md with testing instructions that I can find. > > This is the entire README.md for

Re: Bugs with multiple LAST_VALUE aggregation on multiple columns

Hi There's no README.md with testing instructions that I can find. This is the entire README.md for queryserver 6.0.1 . I've checked all .md files in hbase/phoenix/phoenix-queryserver Cheers S  [Apache

Re: Bugs with multiple LAST_VALUE aggregation on multiple columns

> > >1. The sqline thin.py is presumably a replacement for the sqlline.py >in the phoenix 520 project. So just run that? > > Yes, exactly (but don't use the one from phoenix 5.0) phoenix-server-hbase-2.4.jar is NOT the PQS jar, it is the JAR with the Phoenix Hbase server side components

Re: Bugs with multiple LAST_VALUE aggregation on multiple columns

Hi Thanks for the quick response, we can ignore Dbeaver from now on I was using the PQS version that was included in the latest Phoenix HEAD (5.2.0.SNAPSHOT) I've built the latest queryserver 6.0.1-SNAPSHOT and have updated the POM to user the phoenix 5.2.0-SNAPSHOT and it built correctly.

Re: Bugs with multiple LAST_VALUE aggregation on multiple columns

Thanks for the reports. The preferred way for repros is sandbox + sqlline.py. You say that you are also using dbeaver + sqlline-thin client jar. What version of queryserver are you using ? Please make sure that use for queryserver-6.0.0, or the latest HEAD, with the phoenix-client JAR built from

Certain Aggregates break if a GROUP BY clause results in single row with a NULL column value

Sorry for bug spam, just want to get feedback (if any) before I JIRA If you just create the first 10 rows in the scripts below, most functions work fine. If you create records that are in just one group, that contain any nulls, then exceptions are thrown: So try with first 10, confirm stuff

PERCENTILE_DISC has problems with DECIMAL columns that may have nulls in

Just checking here for workarounds, mistakes on my part before I create a JIRA bug -- Tested with both DBeaver and local new build of Phoenix -- Phoenix sandbox. HBase 2.4.9 Phoenix 5.2.0-SNAPSHOT pulled from master 13/3/2022 -- DBeaver driver version - phoenix-5.0.0-HBase-2.0-thin-client.jar

Bugs with multiple LAST_VALUE aggregation on multiple columns

Before I submit a JIRA, can someone point out if I made a mistake. Pretty sure the exceptions are a bug, but... -- Tested with both DBeaver and local new build of Phoenix -- Phoenix sandbox. HBase 2.4.9 Phoenix 5.2.0-SNAPSHOT pulled from master 13/3/2022 -- DBeaver driver version -

Re: [ANNOUNCE] Tanuj Khurana as Phoenix Committer

Tanuj, Thank you for your contributions! Congratulations! On Fri, Dec 17, 2021 at 1:57 AM Viraj Jasani wrote: > Congratulations Tanuj! Well deserved! > > > On Fri, 17 Dec 2021 at 12:47 AM, Geoffrey Jacoby > wrote: > > > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Tanuj >

  1   2   3   4   5   6   7   8   9   10   >