Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id C3F3B200D34 for ; Fri, 3 Nov 2017 19:52:04 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id C2646160BFC; Fri, 3 Nov 2017 18:52:04 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 12970160BFB for ; Fri, 3 Nov 2017 19:52:03 +0100 (CET) Received: (qmail 60880 invoked by uid 500); 3 Nov 2017 18:52:03 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 60869 invoked by uid 99); 3 Nov 2017 18:52:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Nov 2017 18:52:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 4BEAFDF183 for ; Fri, 3 Nov 2017 18:52:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.202 X-Spam-Level: X-Spam-Status: No, score=-99.202 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id ffMV3CRzHlTM for ; Fri, 3 Nov 2017 18:52:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 6C77C5FB57 for ; Fri, 3 Nov 2017 18:52:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id F0D95E0F07 for ; Fri, 3 Nov 2017 18:52:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 602DE241A8 for ; Fri, 3 Nov 2017 18:52:00 +0000 (UTC) Date: Fri, 3 Nov 2017 18:52:00 +0000 (UTC) From: "Hudson (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (PHOENIX-4237) Allow sorting on (Java) collation keys for non-English locales MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Fri, 03 Nov 2017 18:52:04 -0000 [ https://issues.apache.org/jira/browse/PHOENIX-4237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16238173#comment-16238173 ] Hudson commented on PHOENIX-4237: --------------------------------- SUCCESS: Integrated in Jenkins build Phoenix-master #1865 (See [https://builds.apache.org/job/Phoenix-master/1865/]) PHOENIX-4237 Allow sorting on (Java) collation keys for non-English (jtaylor: rev ee4355791acf3f31568fcd8c43367947d25a1386) * (add) phoenix-core/src/it/java/org/apache/phoenix/end2end/CollationKeyFunctionIT.java * (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/ExpressionType.java * (add) phoenix-core/src/test/java/org/apache/phoenix/expression/function/CollationKeyFunctionTest.java * (edit) phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixConnection.java * (add) phoenix-core/src/main/java/org/apache/phoenix/util/VarBinaryFormatter.java * (edit) LICENSE * (edit) phoenix-server/pom.xml * (add) phoenix-core/src/main/java/org/apache/phoenix/expression/function/CollationKeyFunction.java * (edit) phoenix-core/pom.xml > Allow sorting on (Java) collation keys for non-English locales > -------------------------------------------------------------- > > Key: PHOENIX-4237 > URL: https://issues.apache.org/jira/browse/PHOENIX-4237 > Project: Phoenix > Issue Type: Improvement > Reporter: Shehzaad Nakhoda > Assignee: Shehzaad Nakhoda > Priority: Major > Fix For: 4.13.0 > > Attachments: PHOENIX-4237_v1.patch, PHOENIX-4237_v2.patch, PHOENIX-4237_v3.patch > > > Strings stored via Phoenix can be composed from a subset of the entire set of Unicode characters. The natural sort order for strings for different languages often differs from the order dictated by the binary representation of the characters of these strings. Java provides the idea of a Collator which given an input string and a (language) locale can generate a Collation Key which can then be used to compare strings in that natural order. > Salesforce has recently open-sourced grammaticus. IBM has open-sourced ICU4J some time ago. These technologies can be combined to provide a robust new Phoenix function that can be used in an ORDER BY clause to sort strings according to the user's locale. -- This message was sent by Atlassian JIRA (v6.4.14#64029)