Re: UDF in SELECT

Hi Kathiresan, Thanks for trying the UDFs. bq. 1.Will any function (UDF or built-in) in a SELECT be run only on client side in Phoenix? Yes. if we use a function in select clause it will be evaluated at client side. bq. 2.Is there an option, i c

[ANNOUNCE] Apache Phoenix 4.4-0-HBase-0.98 released

The Apache Phoenix team is pleased to announce the immediate availability of the 4.4.0-HBase-0.98 release compatible with HBase 0.98.x. Highlights include: - spark integration[1] - query server[2] - support for user defined functions[3] - pherf - load tester measures throughput[4] - support union

[ANNOUNCE] Apache Phoenix 4.4-0-HBase-1.0 released

The Apache Phoenix team is pleased to announce the immediate availability of the 4.4.0-HBase-1.0 release compatible with HBase 1.0.x(1.0.1+). The 4.4.0-HBase-1.0 release has feature parity with our 4.4.0-HBase-0.98 release. Extra features include: - support HBase HA Query(timeline-consistent regi

[ANNOUNCE] Apache Phoenix 4.4-0-HBase-1.1 released

The Apache Phoenix team is pleased to announce the immediate availability of the 4.4.0-HBase-1.1 release compatible with HBase 1.1.x. The 4.4.0-HBase-1.1 release has feature parity with our 4.4.0-HBase-1.0 release. The release is available through maven or may be downloaded here[1]. Thanks to al

Re: ClassNotFoundException for UDF class

Hi Anchal Agrawal, Have you place the jar in HDFS? and the path_to_jar in the create function is the URI for the jar in hdfs? Thanks, Rajeshbabu. On Sat, Jul 25, 2015 at 5:58 AM, James Taylor wrote: > Are you sure your hbase-site.xml is being picked up on the client-side? > I've seen this hap

Re: Getting errors in Phoenix queries with JOIN clause[Phoenix version 3.2.2]

Hi Samantha, You are facing this issue https://issues.apache.org/jira/browse/PHOENIX-2007 got fixed in latest code. You get the error when there is no data in the table so you can load some data and try. Thanks, Rajeshbabu. On Mon, Jul 27, 2015 at 5:50 PM, Sumanta Gh wrote: > Hello, > > I'm g

Re: ClassNotFoundException for UDF class

t the *fs.some_fs.impl* property? The latter shouldn't be a problem > for my setup. Does Phoenix write logs to HDFS? If it does, I can test > whether it is able to find my NFS setup or not. > > Related question: Is putting the UDF jar in the local filesystem not > supported by P

Re: Problem using more than one user defined functions in a query

Hi Anchal,Rajmund Sorry for late reply. I have found the root cause for the issue and uploaded the patch at PHOENIX-2151. I have verified it's working fine. You can also try and check things are fine or not. Thanks Anchal for following up. Thanks, Rajeshbabu. On Wed, Aug 19, 2015 at 10:32 PM,

Re: index creation partly succeeds if it times out

Hi James, You can drop the partially created index and try following steps 1) Add the following property to hbase-site.xml at phoenix client side. phoenix.query.timeoutMs double of default value 2) Export the HBASE_CONF_PATH with the configuration directory where hbase-site.xml present. 3) then

Re: index creation partly succeeds if it times out

ported it because it seemed to me to be a bug: Phoenix thinks that the > index is there, but it's not. It ought to get cleaned up after a timeout. > > James > > > On 11/09/15 11:32, rajeshb...@apache.org wrote: > > Hi James, > > You can drop the partially create

Re: Issues while running psql.py localhost command

You can try adding below property to hbase-site.xml and restart hbase. hbase.table.sanity.checks false Thanks, Rajeshbabu. On Mon, Sep 21, 2015 at 12:51 PM, Ashutosh Sharma < ashu.sharma.in...@gmail.com> wrote: > I am getting into issues while running phoenix psql.py command against my > local

Re: Issues while running psql.py localhost command

properties while creating the table. On Mon, Sep 21, 2015 at 2:15 PM, James Heather wrote: > I don't know for certain what that parameter does but it sounds a bit > scary to me... > > > On 21/09/15 09:41, rajeshb...@apache.org wrote: > > You can try adding below prop

Re: [ANNOUNCE] New Apache Phoenix committer - Jan Fernando

Congratulations Jan!!! Thanks, Rajeshbabu. On Sep 30, 2015 4:37 AM, "James Taylor" wrote: > Welcome, Jan. Great to have you onboard as a committer! > > James > > On Tuesday, September 29, 2015, Andrew Purtell > wrote: > >> Congratulations Jan, and welcome! >> >> >> On Tue, Sep 29, 2015 at 11:23

Re: mapreduce.LoadIncrementalHFiles: Trying to load hfile... hang till we set permission on the tmp file

Hi, You can set following configuration in hbase-site.xml and export HBASE_CONF_PATH or HBASE_CONF_DIR with the configuration directory before running the job. property> hbase.coprocessor.region.classes org.apache.hadoop.hbase.security.access.SecureBulkLoadEndpoint Thanks, R

Re: Custom Aggregator Functions

Hi Jaime, Currently User Defined Aggregate functions not supported. Thanks, Rajeshbabu. On Wed, Dec 2, 2015 at 10:45 PM, Jaime Solano wrote: > Hi guys, > > We're planning to upgrade Phoenix 4.2.0 to Phoenix 4.4. As part of this > process, we'll need to migrate our custom UDFs, with the new fea

Re: Two different UDFs called on same column return values from first UDF only

Hi Venu, There is no work around for the issue. Only thing is we need to upgrade to 4.6.0. 4.6.0 has couple of fixes in UDFs. Thanks, Rajeshbabu. On Thu, Dec 24, 2015 at 12:49 AM, Venu Madhav wrote: > I have two user defined functions which extends ScalarFunction taking same > column as parame

Re: Local index not used with non covered queries

Hi Jacobo, The local index will be used if you have any where condition on indexed column otherwise we need to scan index table and data table for each row. That's the reason why it's not using local indexes. There is no index merging currently in Phoenix. There is an improvement task raised for i

Re: Local index not used with non covered queries

1'; > explain select * from test_table where col2 = 'v1-2' and col1 = 'v1-1'; > ------ > > The first select is using the index, but the second is not. I don't know if I > am missing something. > > Thanks,

Re: Delete records

Hi Nanda, In 4.4.0 version we are creating indexes as mutable indexes even the table has immutable rows. So delete is not getting allowed. PHOENIX-2616 fixed to make indexes immutable when data table has immutable rows. As a work around you can create indexes also with IMMUTABLE_ROWS=true option t

Re: after server restart - getting exception - java.io.IOException: Timed out waiting for lock for row

+user@phoenix Hi Vishnu, Can you try restarting the region server where you are seeing the timeout on rowlocks. Would be helpful if you share RS logs. Can you provide the details like what kind of operations done before restart and would you like the share the schemas tables. Thanks, Rajeshbabu.

Re: dropping Phoenix local index is not dropping the local index table in HBase

Since we are storing all local indexes data in a single shared table that's why we are not dropping when we drop a local index. We can check for any local indexes or not and then we can drop it. Now as part of PHOENIX-1734 we have reimplemented local indexes and storing local indexes also in same

Re: CsvBulkLoadTool not populating Actual Table & Local Index Table when '-it' option specified

Hi Vamsi, There is a bug with local indexes in 4.4.0 which is fixed in 4.7.0 https://issues.apache.org/jira/browse/PHOENIX-2334 Thanks, Rajeshbabu. On Tue, Jul 5, 2016 at 6:21 PM, Vamsi Krishna wrote: > Team, > > I'm working on HDP 2.3.2 (Phoenix 4.4.0, HBase 1.1.2). > When I use '-it' option

Fwd: Issue in Bulkload when Table name contains '-' (hyphen)

This is a bug. You can raise an issue Dharmesh, Thanks, Rajeshbabu. -- Forwarded message -- From: Dharmesh Guna Date: Thu, Jul 14, 2016 at 2:57 PM Subject: RE: Issue in Bulkload when Table name contains '-' (hyphen) To: "rajeshb...@apache.org" Hi Rajesh,

Re: Join of multi index tables.

Hi William, Currently we are not supporting index merge optimizations. Here is the issue I have raised for the same thing. Would be better to share details there to show the interest. https://issues.apache.org/jira/browse/PHOENIX-1801 Can't you combine the columns in both indexes into a single i

Re: Phoenix custom UDF

Hi Akhil, There is no support for UDAFs in Phoenix at present. Thanks, Rajeshbabu. On Sun, Oct 2, 2016 at 6:57 PM, akhil jain wrote: > Thanks James. It worked. > > Can you please provide me pointers to write UDAFs in phoenix like we > have GenericUDAFEvaluator for writing Hive UDAFs. > I am lo

Re: Paged Queries Not Working

Offset is supported from Phoenix 4.8.0+ onwards. https://issues.apache.org/jira/browse/PHOENIX-2722 Thanks, Rajeshbabu. On Fri, Mar 24, 2017 at 1:13 PM, Bernard Quizon < bernard.qui...@stellarloyalty.com> wrote: > Hi, > > I was using versions phoenix-4.4.0-hbase-1.1 and phoenix-4.7.0-hbase-1.1

Re: UDF doesn't work with Sort Merge Join Hint

It's a bug and already fixed https://issues.apache.org/jira/browse/PHOENIX-2841. On Fri, Apr 7, 2017 at 1:18 PM, Bernard Quizon < bernard.qui...@stellarloyalty.com> wrote: > HI, > > I'm using Phoenix-4.4-hbase-1.1 and whenever I run a statement that has a > UDF in the SELECT clause with the sort

Re: How do local indexes work?

9,10 slides gives details how read path works. https://www.slideshare.net/rajeshbabuchintaguntla/local-secondary-indexes-in-apache-phoenix Let's know if you need more information. Thanks, Rajeshbabu. On Fri, Jun 30, 2017 at 4:20 AM, Neelesh wrote: > Hi, >The documentation says - "From 4.

Re: How do local indexes work?

s for the slides, Rajesh Babu. > > Does this mean any read path will have to scan all regions of a table? Is > there an optimization available if the primary key and the index share a > common prefix, thus reducing the number of regions to look at? > > Thanks again! > > >

Re: Forward: Re: local index turn disable when region split

Hi Vergil, Thanks for sharing the information. Can you please share the complete logs from where you have collected the info? Thanks, Rajeshbabu. On Mon, Nov 6, 2017 at 10:08 AM, vergil wrote: > Thank for your reply. > > Here is My test environment： > hbase:1.2.5 > phoenix:4.12 > > Phoenix tabl

[ANNOUNCE] Apache Phoenix 5.0.0 released

The Apache Phoenix team is pleased to announce release of it's next major version 5.0.0 compatible with HBase 2.0+. Apache Phoenix enables SQL-based OLTP and operational analytics for Apache Hadoop using Apache HBase as its backing store and providing integration with other projects in the Apache e

Re: New committer: Istvan Toth

Congratulations Istvan!! Thanks, Rajeshbabu. On Tue, Dec 3, 2019, 10:06 PM Josh Elser wrote: > Everyone, > > On behalf of the PMC, I'm pleased to announce Apache Phoenix's newest > committer: Istvan Toth. > > Please join me in extending a warm welcome to Istvan -- congratulations > on this reco

Re: [ANNOUNCE] New Phoenix committer Viraj Jasani

Congratulations Viraj!! On Wed, Feb 10, 2021, 2:01 PM Viraj Jasani wrote: > Thanks for warm wishes! Looking forward to continued involvement. > > > On Wed, 10 Feb 2021 at 6:57 AM, Kadir Ozdemir > wrote: > >> Congratulations, Viraj! >> >> On Tue, Feb 9, 2021 at 3:25 PM Ankit Singhal wrote: >> >

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,

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

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 to

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 AM

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 J

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 R

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 th

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

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 ha

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

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

Re: [ANNOUNCE] Palash Chauhan as Phoenix Committer

Congratulations Palash!! On Wed, Jun 12, 2024, 4:30 PM Kadir Ozdemir wrote: > Congratulations Palash! > > On Tue, Jun 11, 2024 at 9:53 PM Viraj Jasani wrote: > > > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Palash > > Chauhan has accepted the PMC's invitation to become a

[ANNOUNCE] New VP Apache Phoenix

Hi, I am pleased to announce that we have a new PMC chair and VP for Phoenix. ASF board approved the transition from me to Istvan Toth post an agreement by the Phoenix PMC. We thank Istvan Toth for volunteering to serve in this role. Please join me in congratulating Istvan Toth! Thank you all

Re: [ANNOUNCE] Sanjeet Malhotra as Phoenix Committer

Congratulations Sanjeet! Thanks, Rajeshbabu. On Thu, 24 Apr, 2025, 12:57 pm Istvan Toth, wrote: > Congratulations Sanjeet! > > On Fri, Apr 18, 2025 at 2:00 AM Viraj Jasani wrote: > > > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Sanjeet > > Malhotra has accepted the PMC's

Re: [ANNOUNCE] Hari Krishna Dara as Phoenix Committer

Congratulations Hari! On Thu, 24 Apr, 2025, 12:56 pm Istvan Toth, wrote: > Congratulations Hari! > > On Tue, Apr 22, 2025 at 6:44 AM Viraj Jasani wrote: > > > On behalf of the Apache Phoenix PMC, I'm pleased to announce that Hari > > Krishna Dara has accepted the PMC's invitation to become a co