James Taylor 2013-05-16, 19:29
anil gupta 2013-05-16, 21:02
James Taylor 2013-05-16, 23:15
Is this implementation present in the GitHub repo of Phoenix? If yes, can
you provide me the package name/classes?
I haven't got the opportunity to try out Phoenix yet but i would like to
have a look at the implementation.
On Thu, May 16, 2013 at 4:15 PM, James Taylor <[EMAIL PROTECTED]>wrote:
> Hi Anil,
> No HBase changes were required. We're already leveraging coprocessors in
> HBase which is a key enabler. The other pieces needed are:
> - a type system
> - a means to evaluate an ORDER BY expression on the server
> - memory tracking/throttling (the topN for each region are held in memory
> until the client does a merge sort)
> Phoenix has all these, so it was just a matter of packaging them up to
> support this.
> On 05/16/2013 02:02 PM, anil gupta wrote:
>> Hi James,
>> You have mentioned support for TopN query. Can you provide me HBase Jira
>> ticket for that. I am also doing similar stuff in
>> I am interested in
>> knowing the details about that implementation.
>> Anil Gupta
>> On Thu, May 16, 2013 at 12:29 PM, James Taylor <[EMAIL PROTECTED]
>> We are pleased to announce the immediate availability of Phoenix 1.2 (
>>> Here are some of the release highlights:
>>> * Improve performance of multi-point and multi-range queries (20x plus)
>>> using new skip scan
>>> * Support TopN queries (3-70x faster than Hive)
>>> * Control row key order when defining primary key columns
>>> * Salt tables declaratively to prevent hot spotting
>>> * Specify columns dynamically at query time
>>> * Write Phoenix-compliant HFiles from Pig scripts and Map/Reduce jobs
>>> * Support SELECT DISTINCT
>>> * Leverage essential column family feature
>>> * Bundle command line terminal interface
>>> * Specify scale and precision on decimal type
>>> * Support fixed length binary type
>>> * Add TO_CHAR, TO_NUMBER, COALESCE, UPPER, LOWER, and REVERSE built-in
>>> HBase 0.94.4 or above is required with HBase 0.94.7 being recommended.
>>> more detail, please see our announcement: http://phoenix-hbase.blogspot.
>>> http://phoenix-hbase.blogspot.****com/ <http://phoenix-hbase.**
>>> blogspot.com/ <http://phoenix-hbase.blogspot.com/>>
Thanks & Regards,
James Taylor 2013-05-17, 16:14
Azuryy Yu 2013-05-20, 11:07
James Taylor 2013-05-20, 15:56