Re: [ANNOUNCE] Apache Phoenix 4.8.1 is available for download

2016-09-29 Thread James Taylor
Apache Phoenix enables OLTP and operational analytics for Hadoop through
SQL support using HBase as it's backing store and integrates with other
projects in the ecosystem such as Spark, Hive, Pig, Flume, and MapReduce.

On Tue, Sep 27, 2016 at 10:27 PM,  wrote:

> The Phoenix Team is pleased to announce the immediate release of Apache
> Phoenix 4.8.1.
> Download it from your favorite Apache mirror [1].
>
> Apache Phoenix 4.8.1 a bug fix release for the Phoenix 4.8 release line,
> compatible with Apache HBase 0.98, 1.0, 1.1 & 1.2.
>
> This release fixes the following 43 issues:
> [PHOENIX-1367] - VIEW derived from another VIEW doesn't use parent
> VIEW indexes
> [PHOENIX-3195] - Slight safety improvement for using
> DistinctPrefixFilter
> [PHOENIX-3228] - Index tables should not be configured with a
> custom/smaller MAX_FILESIZE
> [PHOENIX-930] - duplicated columns cause query exception and drop
> table exception
> [PHOENIX-1647] - Correctly return that Phoenix supports schema name
> references in DatabaseMetaData
> [PHOENIX-2336] - Queries with small case column-names return empty
> result-set when working with Spark Datasource Plugin
> [PHOENIX-2474] - Cannot round to a negative precision (to the left of
> the decimal)
> [PHOENIX-2641] - Implicit wildcard in LIKE predicate search pattern
> [PHOENIX-2645] - Wildcard characters do not match newline characters
> [PHOENIX-2853] - Delete Immutable rows from View does not work if
> immutable index(secondary index) exists
> [PHOENIX-2944] - DATE Comparison Broken
> [PHOENIX-2946] - Projected comparison between date and timestamp
> columns always returns true
> [PHOENIX-2995] - Write performance severely degrades with large number
> of views
> [PHOENIX-3046] - NOT LIKE with wildcard unexpectedly returns results
> [PHOENIX-3054] - Counting zero null rows returns an empty result set
> [PHOENIX-3072] - Deadlock on region opening with secondary index
> recovery
> [PHOENIX-3148] - Reduce size of PTable so that more tables can be
> cached in the metada cache.
> [PHOENIX-3162] - TableNotFoundException might be thrown when an index
> dropped while upserting.
> [PHOENIX-3164] - PhoenixConnection leak in PQS with security enabled
> [PHOENIX-3170] - Remove the futuretask from the list if
> StaleRegionBoundaryCacheException is thrown while initializing the
> scanners
> [PHOENIX-3175] - Unnecessary UGI proxy user impersonation check
> [PHOENIX-3185] - Error: ERROR 514 (42892): A duplicate column name was
> detected in the object definition or ALTER TABLE statement.
> columnName=TEST_TABLE.C1 (state=42892,code=514)
> [PHOENIX-3189] - HBase/ZooKeeper connection leaks when providing
> principal/keytab in JDBC url
> [PHOENIX-3203] - Tenant cache lookup in Global Cache fails in certain
> conditions
> [PHOENIX-3207] - Fix compilation failure on 4.8-HBase-1.2,
> 4.8-HBase-1.1 and 4.8-HBase-1.0 branches after PHOENIX-3148
> [PHOENIX-3210] - Exception trying to cast Double to BigDecimal in
> UpsertCompiler
> [PHOENIX-3223] - Add hadoop classpath to PQS classpath
> [PHOENIX-3230] - Upgrade code running concurrently on different JVMs
> could make clients unusuable
> [PHOENIX-3237] - Automatic rebuild of disabled index will fail if
> indexes of two tables are disabled at the same time
> [PHOENIX-3246] - U+2002 (En Space) not handled as whitespace in grammar
> [PHOENIX-3260] - MetadataRegionObserver.postOpen() can prevent region
> server from shutting down for a long duration
> [PHOENIX-3268] - Upgrade to Tephra 0.9.0
> [PHOENIX-3280] - Automatic attempt to rebuild all disabled index
> [PHOENIX-3291] - Do not throw return value of Throwables#propagate call
> [PHOENIX-3307] - Backward compatibility fails for tables with index
> (4.7.0 client - 4.8.1 server)
> [PHOENIX-3323] - make_rc script fails to build the RC
> [PHOENIX-2785] - Do not store NULLs for immutable tables
> [PHOENIX-3081] - MIsleading exception on async stats update after
> major compaction
> [PHOENIX-3116] - Support incompatible HBase 1.1.5 and HBase 1.2.2
> [PHOENIX-808] - Create snapshot of SYSTEM.CATALOG prior to upgrade and
> restore on any failure
> [PHOENIX-2990] - Ensure documentation on "time/date"
> datatypes/functions acknowledge lack of JDBC compliance
> [PHOENIX-2991] - Add missing documentation for functions
> [PHOENIX-3255] - Increase test coverage for TIMESTAMP
>
> See also the full release notes [2].
>
> Yours,
> The Apache Phoenix Team
>
> [1] http://www.apache.org/dyn/closer.lua/phoenix/
> [2] https://issues.apache.org/jira/secure/ReleaseNote.jspa?
> projectId=12315120&version=12337964
>
>


[ANNOUNCE] Apache Phoenix 4.9 released

2016-12-01 Thread James Taylor
Apache Phoenix enables OLTP and operational analytics for Apache Hadoop
through SQL support using Apache HBase as its backing store and providing
integration with other projects in the ecosystem such as Apache Spark,
Apache Hive, Apache Pig, Apache Flume, and Apache MapReduce.

We're pleased to announce our 4.9.0 release which includes:
- Atomic UPSERT through new ON DUPLICATE KEY syntax [1]
- Support for DEFAULT declaration in DDL statements [2]
- Specify guidepost width per table [3]
- Over 40 bugs fixed [4]

The release is available in source or binary form here [5].

Thanks,
The Apache Phoenix Team

[1] https://phoenix.apache.org/atomic_upsert.html
[2] https://phoenix.apache.org/language/index.html#column_def
[3] https://phoenix.apache.org/update_statistics.html
[4]
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12315120&version=12335845
[5] https://phoenix.apache.org/download.html


[ANNOUNCE] PhoenixCon 2017 is a go!

2017-03-15 Thread James Taylor
I'm excited to announce that the 2nd Annual Apache Phoenix conference,
PhoenixCon 2017 will take place the day after HBaseCon in San Francisco on
Tuesday, June 13th from 10:30am-6pm. For more details, including to RSVP
and submit a talk proposal, click here:
https://www.eventbrite.com/e/phoenixcon-2017-tickets-32872245772

Hope you can make it.

James


[ANNOUNCE] Apache Phoenix 4.10 released

2017-03-23 Thread James Taylor
The Apache Phoenix team is pleased to announce the immediate availability
of the 4.10.0 release. Apache Phoenix enables SQL-based OLTP and
operational analytics for Hadoop using Apache HBase as its backing store
and providing integration with other projects in the ecosystem such as
Spark, Hive, Pig, Flume, and MapReduce. The 4.x releases are compatible
with HBase 0.98/1.1/1.2.

Highlights of the release include:

* Reduce on disk footprint through column encoding and optimized storage
format for write-once data [1]
* Support Apache Spark 2.0 in Phoenix/Spark integration [2]
* Consume Apache Kafka messages through Phoenix [3]
* Improve UPSERT SELECT performance by distributing execution across
cluster [4]
* Improve Hive integration [5]
* 40+ bug fixes [6]

Source and binary downloads are available here [7].

Thanks,
The Apache Phoenix Team

[1] https://blogs.apache.org/phoenix/entry/column-mapping-and-immutable-data
[2] https://phoenix.apache.org/phoenix_spark.html
[3] https://phoenix.apache.org/kafka.html
[4] https://issues.apache.org/jira/browse/PHOENIX-3271
[5] https://issues.apache.org/jira/browse/PHOENIX-3346
[6]
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12315120&version=12338126
[7] http://phoenix.apache.org/download.html


[ANNOUNCE] Apache Phoenix 4.11 released

2017-07-07 Thread James Taylor
The Apache Phoenix team is pleased to announce the immediate availability
of the 4.11.0 release. 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 ecosystem
such as Spark, Hive, Pig, Flume, and MapReduce. The 4.x releases are
compatible with HBase 0.98/1.1/1.2/1.3.

Highlights of the release include:

* Support for HBase 1.3.1 and above
* Local index hardening and performance improvements [1]
* Atomic update of data and local index rows (HBase 1.3 only) [2]
* Use of snapshots for MR-based queries and async index building [3][4]
* Support for forward moving cursors [5]
* Chunk commit data from client based on byte size and row count [6]
* Reduce load on region server hosting SYSTEM.CATALOG [7]
* 50+ bug fixes [8]

Source and binary downloads are available here [9].

Thanks,
The Apache Phoenix Team

[1]
https://issues.apache.org/jira/issues/?jql=project%20%3D%20PHOENIX%20and%20fixVersion%3D4.11.0%20and%20labels%3DlocalIndex
[2] https://issues.apache.org/jira/browse/PHOENIX-3827
[3] https://issues.apache.org/jira/browse/PHOENIX-3744
[4] https://issues.apache.org/jira/browse/PHOENIX-3812
[5] https://issues.apache.org/jira/browse/PHOENIX-3572
[6] https://issues.apache.org/jira/browse/PHOENIX-3784
[7] https://issues.apache.org/jira/browse/PHOENIX-3819
[8]
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12315120&version=12339764
[9] http://phoenix.apache.org/download.html


[ANNOUNCE] Apache Phoenix 4.12 released

2017-10-11 Thread James Taylor
The Apache Phoenix team is pleased to announce the immediate availability
of the 4.12.0 release [1]. 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 ecosystem
such as Spark, Hive, Pig, Flume, and MapReduce. The 4.x releases are
compatible with HBase 0.98/1.1/1.2/1.3.

Highlights of the release include:

* Improved scalability and reliability of global mutable secondary indexes
[2]
* Implemented index scrutiny tool to validate consistency between index and
data table [3]
* Introduced support for table sampling [4]
* Added support for APPROX_COUNT_DISTINCT aggregate function [5]
* Stabilized unit test runs
* Fixed 100+ issues [6]

Source and binary downloads are available here [1].

[1] http://phoenix.apache.org/download.html
[2]
https://issues.apache.org/jira/issues/?jql=project%20%3D%20PHOENIX%20AND%20status%3DResolved%20AND%20fixVersion%3D%224.12.0%22%20and%20labels%3D%22secondary_index%22
[3] http://phoenix.apache.org/secondary_indexing.html#Index_Scrutiny_Tool
[4] https://phoenix.apache.org/tablesample.html
[5] https://phoenix.apache.org/language/functions.html#approx_count_distinct
[6]
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12315120&version=12340844


[ANNOUNCE] Apache Phoenix 4.13 released

2017-11-11 Thread James Taylor
The Apache Phoenix team is pleased to announce the immediate availability
of the 4.13.0 release. 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 ecosystem
such as Spark, Hive, Pig, Flume, and MapReduce. The 4.x releases are
compatible with HBase 0.98 and 1.3.

Highlights of the release include:

* Critical bug fix to prevent snapshot creation of SYSTEM.CATALOG when
connecting [1]
* Numerous bug fixes around handling of row deletion [2]
* Improvements to statistics collection [3]
* New COLLATION_KEY built-in function for linguistic sort [4]

Source and binary downloads are available here [5].

[1] https://issues.apache.org/jira/browse/PHOENIX-4335
[2] https://issues.apache.org/jira/issues/?jql=labels%20%3D%20rowDeletion
[3]
https://issues.apache.org/jira/issues/?jql=labels%20%3D%20statsCollection
[4] https://phoenix.apache.org/language/functions.html#collation_key
[5] http://phoenix.apache.org/download.html


[ANNOUNCE] Apache Phoenix 4.13.1 released

2017-12-09 Thread James Taylor
The Apache Phoenix team is pleased to announce the immediate availability
of the 4.13.1 release. 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 ecosystem
such as Spark, Hive, Pig, Flume, and MapReduce. This releases is compatible
with HBase 0.98, 1.1, 1.2 and 1.3.

Highlights of the release include:

* Support again for HBase 1.1 and 1.2 due to community ask
* Inclusion of required server-side jars for new COLLATION_KEY function [1]

Source and binary downloads are available here [2]. Note that in the
future, releases will be done separately for each branches by dedicated
release managers. I'll send out an email on this soon.

Thanks,
James (on behalf of the Apache Phoenix team)

[1] https://issues.apache.org/jira/browse/PHOENIX-4384
[2] http://phoenix.apache.org/download.html


[ANNOUNCE] Apache Phoenix 4.7 released

2016-03-11 Thread James Taylor
Apache Phoenix enables OLTP and operational analytics for Hadoop through
SQL support and integration with other projects in the ecosystem such as
Spark, HBase, Pig, Flume, and MapReduce.

We're pleased to announce our 4.7.0 release which includes:
- ACID transaction support (beta) [1]
- Enhanced secondary index consistency guarantees [2]
- Statistics improvements [3][4][5]
- Performance enhancements [6][7][8][9]
- 150+ bug fixes [10]

The release is available in source or binary form here [11].

Thanks,
The Apache Phoenix Team

[1] https://phoenix.apache.org/transactions.html
[2] https://phoenix.apache.org/secondary_indexing.html#Consistency
[3] https://issues.apache.org/jira/browse/PHOENIX-2430
[4] https://issues.apache.org/jira/browse/PHOENIX-2702
[5] https://issues.apache.org/jira/browse/PHOENIX-2692
[6] https://issues.apache.org/jira/browse/PHOENIX-1428
[7] https://issues.apache.org/jira/browse/PHOENIX-2377
[8] https://issues.apache.org/jira/browse/PHOENIX-2520
[9] https://issues.apache.org/jira/browse/PHOENIX-1973
[10]
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12315120&version=12333998
[11] https://phoenix.apache.org/download.html