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 85D32200D5D for ; Wed, 20 Dec 2017 23:33:08 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 84278160BF9; Wed, 20 Dec 2017 22:33:08 +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 CB2FF160C15 for ; Wed, 20 Dec 2017 23:33:07 +0100 (CET) Received: (qmail 14494 invoked by uid 500); 20 Dec 2017 22:33:07 -0000 Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list notifications@asterixdb.apache.org Received: (qmail 14455 invoked by uid 99); 20 Dec 2017 22:33:07 -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; Wed, 20 Dec 2017 22:33:07 +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 68855C4E72 for ; Wed, 20 Dec 2017 22:33:06 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.21 X-Spam-Level: X-Spam-Status: No, score=-99.21 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01, URIBL_BLOCKED=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 mtMjdI3wNF08 for ; Wed, 20 Dec 2017 22:33:05 +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 80A7D5F5C6 for ; Wed, 20 Dec 2017 22:33:05 +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 DF3ACE01A8 for ; Wed, 20 Dec 2017 22:33:03 +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 3B504212F8 for ; Wed, 20 Dec 2017 22:33:00 +0000 (UTC) Date: Wed, 20 Dec 2017 22:33:00 +0000 (UTC) From: "ASF subversion and git services (JIRA)" To: notifications@asterixdb.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (ASTERIXDB-2203) Secondary Primary index shouldn't sort with existing dataset MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 20 Dec 2017 22:33:08 -0000 [ https://issues.apache.org/jira/browse/ASTERIXDB-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16299190#comment-16299190 ] ASF subversion and git services commented on ASTERIXDB-2203: ------------------------------------------------------------ Commit 4c5fb5c313b60c6b8b0fb0812cec8cc98c0289a0 in asterixdb's branch refs/heads/master from [~alsuliman] [ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=4c5fb5c ] [ASTERIXDB-2203][IDX] Eliminate sort operator for secondary primary index - user model changes: no - storage format changes: no - interface changes: no details: This change is intended to remove the sort operator when creating a secondary primary index. The secondary primary index DDL statement uses the same code as the one for creating general secondary BTree indexes which has the sort operator since it needs to sort by SK. The sort operator is not needed for secondary primary index since there is no SK and PK is already sorted. Change-Id: I2287c355204355b7ce306388c85d58d69a1bb64a Reviewed-on: https://asterix-gerrit.ics.uci.edu/2240 Sonar-Qube: Jenkins Integration-Tests: Jenkins Tested-by: Jenkins Contrib: Jenkins Reviewed-by: Dmitry Lychagin > Secondary Primary index shouldn't sort with existing dataset > ------------------------------------------------------------ > > Key: ASTERIXDB-2203 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2203 > Project: Apache AsterixDB > Issue Type: Improvement > Reporter: Ian Maxon > > Right now creating a secondary primary index causes it to sort, like other secondary indices, however there's no need to sort because the data is of course already in primary order. -- This message was sent by Atlassian JIRA (v6.4.14#64029)