Re: Build queryserver with hbase 2.2.3 and phoenix 5.1.0-SNAPSHOT

Hi Guanghao Zhang, The phoenix version that you specify is only used during tests, so it has no effect on the server or client JAR built. That said, it should compile with any recent phoenix branch, so thank you for the patch. I've already merged it. Istvan On Fri, Mar 13, 2020 at 3:52 PM

Re: Latest supported HBase version

The Apache Phoenix master branch works with all supported (i.e. not EOL) HBase 2.x branches ( 2.1 and 2.2, and for now even 2.0, though it's EOL), and we aim to keep it that way. The plan is to support all active HBase 2.x branches at the time of release of Phoenix 5.1. No comment on dates.

Re: timestamp and pre-existing HBase tables

Hi! Look into PHOENIX-5629 . Note that is not available in any released version yet. Istvan On Wed, Mar 18, 2020 at 10:26 PM anil gupta wrote: > AFAIK, Phoenix cannot surface the cell level timestamps that hbase stores > for each cell. Row

Re: Phoenix DB Operation Success, but record missing in Hbase

There are some known data loss bugs related to indexing and region splits in 4.14.0, that are fixed in later 4.14 patch releases, though those events are generally quite noisy with WARNINGs in the logs. However, AFAICT 4.14.1 and later dropped HBase 1.2 and CDH5 support, so I don't think you'll

Re: Phoenix Client Backwards Compatibility

A bit more context: Older Phoenix clients are somewhat forward-compatible with newer servers, but newer clients are definitely not backwards compatible with older servers. see https://phoenix.apache.org/upgrading.html You also need to make sure that you do not try to use a client that includes a

Re: Current version of Spark connector

Hello! The code in the phoenix-connectors repo was taken from the 4.14 branch. The code in 5.0.0 was the code for the master branch, but it is not available elsewhere, and has since been removed from the master branch. If you are using Phoenix 5.x, then you are probably better off taking the

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

- Added SQLAlchemy dialect - Implemented Avatica Metadata API - Misc fixes - Licensing cleanup Download source here [1], or install via pip [2]. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] https://phoenix.apache.org/download.html <http://phoenix.apache.org/download.html&

[ANNOUNCE] Phoenix Thirdparty 1.0.0 released

that they are properly isolated from Phoenix downstream and upstream users. As of this release, Google Guava is the only encapsulated library. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] https://phoenix.apache.org/download.html

Re: Unable to find parent table to determine USE_STATS_FOR_PARALLELIZATION

Hi! The version you are using is delivered by Cloudera. The Apache Community cannot support a vendor delivered version, as they do not have access to the source code. Please contact Cloudera support. regrards Istvan On Fri, Aug 7, 2020 at 11:32 AM Zhou Zach wrote: > Hi all, > > phoenix

Re: Unable to connect to HBase 2.2.4

Phoenix 5.0 doesn't work with HBase 2.2. There is no released Phoenix version that works with Hbase 2.2, only the development version (master branch) does. On Wed, Jun 17, 2020 at 12:40 PM Arun J wrote: > After installing Phoenix 5.0 with HBase 2.2.4, I am unable to connect > using

Re: how to connect phoenix cluster enabled with Kerberos using Java JDBC

The code looks OK. Check that you can resolve the name of, and have IP connectivity to *each *HBase host (master/regionserver) in the cluster. regards Istvan On Wed, Jul 22, 2020 at 3:01 PM 黄乐平 <18702515...@163.com> wrote: > My code is like this: > > public class PhoenixDemo { > > public

Re: expected release dates for 5.0.x / 5.1.x

There is no plan for 5.0.1 that I know of. The next release to support Hbase 2 will be 5.1.0. We are actively working towards it, but I cannot give you a specific time frame. regards Istvan On Mon, Jul 27, 2020 at 12:49 PM wrote: > We are using Phoenix 4.7 in production. We are currently

[ANNOUNCE] Phoenix Tephra 0.16.0 released

Hello Everyone, The Apache Phoenix team is pleased to announce the immediate availability of the 0.16.0 release of Phoenix Tephra. This is the first release of the project by the Apache Phoenix team, and includes the following improvements: - Added support for HBase 1.5, 1.6, 2.1, 2.2, 2.3

[ANNOUNCE] Phoenix Omid 1.0.2 released

version from Phoenix Thirdparty to improve compatibility. - Switched the default timestampType setting to WORLD_TIME - Minor fixes and build system improvements. Download source from [1]. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] https://phoenix.apache.org/download.html

Re: [Discuss] Dropping support for older HBase version

ee that it is good to remain pro-active for these consensuses to > avoid last-minute > surprise for the user who has been waiting for a long on the release. > > Regards, > Ankit Singhal > > > > On Fri, Jan 29, 2021 at 10:59 PM Istvan Toth wrote: > >> I'm not sure I understand

Re: Setting hbase.rpc.timeout for Phoenix queries on AWS EMR

The client XML file is the hbase-site.xml that is on the classpath of the Phoenix client application. You have to add it to the client classpath, and keep the hbase-site.xml on the server/AWS side and the hbase-site.xml in sync. I have no experience with Phoenix on AWS, but the above is generally

Re: Setting hbase.rpc.timeout for Phoenix queries on AWS EMR

nix Query > Server, or my own application. > > I'm using the Phoenix thin client jar, so do I need a copy of the server > hbase-site.xml in my own app classpath? > > Cheers > > S > ------ > *From:* Istvan Toth > *Sent:* 12 May 2021 11:45 PM &g

Re: Setting hbase.rpc.timeout for Phoenix queries on AWS EMR

Though you may not have control over that in AWS. On Thu, May 13, 2021 at 8:51 AM Istvan Toth wrote: > You don't need hbase-site.xml for the thin client. > But you do need to keep the hbase-site.xml on the classpath of the Phoenix > Query Server in sync with the HBase cluster. > &

[DISCUSS] Unbundling Sqlline and slf4j backend from phoenix-client and phoenix-client embedded

Hi! The current purpose of the phoenix-client JAR is twofold: - It servers as a generic JDBC driver for embedding in applications - It also contains the sqlline library used by the sqlline.py script, as well as the slf4j log4j backend. - (It also contains a some Phoenix code and HBase libraries

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

the following improvements: - Use HTTP sessions to enable sticky load balancers (PHOENIX-6459) - Revert default GSSAPI OID to SPNEGO to improve compatibility (PHOENIX-6414) Download source here [1], or install via pip [2]. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] https

Re: [DISCUSS] Unbundling Sqlline and slf4j backend from phoenix-client and phoenix-client embedded

es. I imagine most folks haven't yet realized that > it's even an option that's available. > > On 5/26/21 1:16 PM, la...@apache.org wrote: > > Will sqlline still be part of the Phoenix "distribution"? Or will it > become a separate package to install? > > >

Re: [ANNOUNCE] Apache Phoenix 5.1.0 released

implementation - Support for multi-region SYSTEM.CATALOG - Omid integration with Phoenix - Orphan view tool - Separation of the Phoenix-Connectors and Phoenix-Queryserver projects - 350+ bug fixes and much more Download source and binaries here [1]. Thanks, Istvan Toth (on behalf of the Apache Phoenix

[ANNOUNCE] Phoenix Thirdparty 1.1.0 released

that they are properly isolated from Phoenix downstream and upstream users. This release adds a pre-shaded commons-cli, with a fix for CLI-254. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] https://phoenix.apache.org/download.html

[ANNOUNCE] Apache Phoenix 5.1.1 released

fixes Download source and binaries here [1]. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] http://phoenix.apache.org/download.html

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

() (PHOENIX-6410) - Fixed empty array column handling in result set (PHOENIX-6484) - Added check for missing/extra query parameters (PHOENIX-6407) Download source here [1], or install via pip [2]. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] https://phoenix.apache.org/download.html

Re: phoenix due to regionserver OutOfMemory

Either your RSs have very little Heap configured, and adding the Phoenix overhead causes them to OOM, or you have some other problem with your cluster setup or your HBase data. I suggest that you contact Cloudera support. Istvan On Thu, Sep 9, 2021 at 2:45 AM igyu wrote: > CDH 6.3.2 > >

[ANNOUNCE] Apache Phoenix Query Server 6.0.0 released

updated to 1.18.0 - Wrapper scripts now work Python 3.0 Download source and binaries here [1]. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] http://phoenix.apache.org/download.html

Re: Not able to insert data in phoenix table from RDD

This is not enough information to diagnose the problem. However, I suggest building and using the HEAD revision from the phoenix-connectors repo. On Mon, Sep 27, 2021 at 8:51 AM Ankit Joshi wrote: > Hello Team, > > I am using phoenix 5.0.0-HBase-2.0 as dependency and in cluster we have > 5.1.0

Re: Urgent problem with Phoenix function LAST_VALUE and joins

Please try to reproduce with the latest released Phoenix version, or git master HEAD before opening the JIRA. You can use bin/phoenix_sandbox.py in the source repo/distribution to quickly start a test environment without installing Phoenix in a real cluster. On Wed, Sep 29, 2021 at 12:36 AM

Re: Urgent problem with Phoenix function LAST_VALUE and joins

oenix dev > channel is the place to ask questions. > > Cheers > > Simon > ------ > *From:* Istvan Toth > *Sent:* 29 September 2021 7:37 PM > *To:* user@phoenix.apache.org > *Subject:* Re: Urgent problem with Phoenix function LAST_VALU

Re: Urgent problem with Phoenix function LAST_VALUE and joins

SUCCESS [07:03 > min] > [INFO] Phoenix Hbase 2.4.0 compatibility .. SUCCESS [ > 37.760 s] > [INFO] Phoenix Hbase 2.3.0 compatibility .. SUCCESS [01:40 > min] > [INFO] Phoenix Hbase 2.2.5 compatibility .. SUCCESS [01:03 > min] > [INFO] Phoenix Hbase 2.1.6 compatibility .. SUCCESS [ > 39.114 s] > [INFO] Phoen

Re: Reference Documentation Disappearance

Fixed. On Thu, Sep 30, 2021 at 1:31 PM Istvan Toth wrote: > Thanks for reporting this. > I'm working on fixing it. > > On Thu, Sep 30, 2021 at 9:37 AM Gustafson, Nicholas < > nicholas.gustaf...@rakuten.com> wrote: > >> Hi, >> It seems like some time

Re: Reference Documentation Disappearance

Thanks for reporting this. I'm working on fixing it. On Thu, Sep 30, 2021 at 9:37 AM Gustafson, Nicholas < nicholas.gustaf...@rakuten.com> wrote: > Hi, > It seems like some time this morning (JST) the documentation for Grammar, > Functions, and Datatypes was replaced with a single line:

Re: Experience building Hbase and Phoenix for the first time

This topic is fine for the user list, others may have similar problems, hence copying there. I don't think we should link to the archives. If you do a fresh install, you should use the latest HBase patch releases. If you have an existing cluster, you should generally still build with that latest

Re: more salt buckets than regions

It's a known issue. A region may only have rows from a single bucket in it, and it is not hard to get into the state that you describe. We have at least one JIRA open for it. Phoenix will automatically pre-split according to the salt buckets if you don't explicitly specify the splits in the create

Re: more salt buckets than regions

t; ticket? I found PHOENIX-4906 but I'm not sure if that's the most relevant > one. > > Jan > > On Tue, 2 Nov 2021 at 22:47, Istvan Toth wrote: > >> It's a known issue. >> A region may only have rows from a single bucket in it, and it is not >> hard to get into the

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

Re: Bugs with multiple LAST_VALUE aggregation on multiple columns

sources > phoenix-server-hbase-2.4-5.2.0-SNAPSHOT-sources.jar > phoenix-server-hbase-2.4.jar test-classes > maven-archiver original-phoenix-server-hbase-2.4-5.2.0-SNAPSHOT.jar > phoenix-server-hbase-2.4-5.2.0-SNAPSHOT.jar pom.xml > > Does sandbox load from this folder

Re: Bugs with multiple LAST_VALUE aggregation on multiple columns

he Python driver is maintained by the Phoenix project, and is available > in the python-phoenixdb > directory of the phoenix-queryserver repository. > -- > *From:* Istvan Toth > *Sent:* 17 March 2022 5:40 PM > *To:* user@phoenix.apache.org

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

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

[ANNOUNCE] Phoenix Thirdparty 2.0.0 released

requires using a different API to activate the fix for CLI-254 than the previous patched version included in Phoenix Thirdparty 1.1.0. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] https://phoenix.apache.org/download.html

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

to be removed from future Phoenix releases. The ACID transaction feature in Apache Phoenix is still going to be supported and developed, but instead of a choice of Tephra and Omid transaction engines, only Omid is going to be supported in the future. Thanks Istvan Toth (on behalf of the Apache Phoenix team)

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

target Java 7 in the Phoenix code base. On Tue, May 31, 2022 at 8:27 AM Istvan Toth wrote: > 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 > l

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

ers still on Hbase 1.x upgrade to the latest HBase GA version (currently 2.4), and to the latest Phoenix 5.x release (currently 5.1.2) Thanks, Istvan Toth (on behalf of the Apache Phoenix team)

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

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

with protoc 3.19 from the Avatica 1.21 descriptors (PHOENIX-6731) - Dropped support for Python 3.4 (PHOENIX-6731) Download source here [1], or install via pip [2]. Thanks, Istvan Toth (on behalf of the Apache Phoenix team) [1] https://phoenix.apache.org/download.html <http://phoenix.apache.

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

[ANNOUNCE] Phoenix Omid 1.1.0 released

is now Built with HBase2 rebuilt with Hadoop 3.x. SeeOMID-231 for details - Switched default logging backend to Log4j2 - Migrated from Netty 3 to Netty 4 - Kerberos-related fixes - Various dependency version updates Download source from [1]. Thanks, Istvan Toth (on behalf of the Apache Phoenix

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 <

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

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

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

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 >

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

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