From notifications-return-158432-archive-asf-public=cust-asf.ponee.io@asterixdb.apache.org Fri Jun 25 22:18:05 2021 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mxout1-ec2-va.apache.org (mxout1-ec2-va.apache.org [3.227.148.255]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id E82C0180181 for ; Sat, 26 Jun 2021 00:18:04 +0200 (CEST) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-ec2-va.apache.org (ASF Mail Server at mxout1-ec2-va.apache.org) with SMTP id 2E0F43F2D2 for ; Fri, 25 Jun 2021 22:18:04 +0000 (UTC) Received: (qmail 49354 invoked by uid 500); 25 Jun 2021 22:18:04 -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 49313 invoked by uid 99); 25 Jun 2021 22:18:04 -0000 Received: from spamproc1-he-de.apache.org (HELO spamproc1-he-de.apache.org) (116.203.196.100) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 Jun 2021 22:18:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamproc1-he-de.apache.org (ASF Mail Server at spamproc1-he-de.apache.org) with ESMTP id 56DBD1FF3A1 for ; Fri, 25 Jun 2021 22:18:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamproc1-he-de.apache.org X-Spam-Flag: NO X-Spam-Score: -110.509 X-Spam-Level: X-Spam-Status: No, score=-110.509 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_HOSTKARMA_W=-2.5, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WELCOMELIST=-0.01, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-he-de.apache.org ([116.203.227.195]) by localhost (spamproc1-he-de.apache.org [116.203.196.100]) (amavisd-new, port 10024) with ESMTP id iSbyInvBGqya for ; Fri, 25 Jun 2021 22:18:03 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=95.216.194.37; helo=mxout1-he-de.apache.org; envelope-from=jira@apache.org; receiver= Received: from mxout1-he-de.apache.org (mxout1-he-de.apache.org [95.216.194.37]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id 02D357FE74 for ; Fri, 25 Jun 2021 22:18:02 +0000 (UTC) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-he-de.apache.org (ASF Mail Server at mxout1-he-de.apache.org) with SMTP id 50E575FEF6 for ; Fri, 25 Jun 2021 22:18:02 +0000 (UTC) Received: (qmail 49119 invoked by uid 99); 25 Jun 2021 22:18:01 -0000 Received: from ec2-52-204-25-47.compute-1.amazonaws.com (HELO mailrelay1-ec2-va.apache.org) (52.204.25.47) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 Jun 2021 22:18:01 +0000 Received: from jira2-he-de.apache.org (jira2-he-de.apache.org [168.119.33.54]) by mailrelay1-ec2-va.apache.org (ASF Mail Server at mailrelay1-ec2-va.apache.org) with ESMTPS id 1AE903E969 for ; Fri, 25 Jun 2021 22:18:01 +0000 (UTC) Received: from jira2-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira2-he-de.apache.org (ASF Mail Server at jira2-he-de.apache.org) with ESMTP id 20097C801FE for ; Fri, 25 Jun 2021 22:18:00 +0000 (UTC) Date: Fri, 25 Jun 2021 22:18:00 +0000 (UTC) From: "Glenn Justo Galvizo (Jira)" To: notifications@asterixdb.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Closed] (ASTERIXDB-2831) Use a More Selective Approach to Array Index UPSERTs MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/ASTERIXDB-2831?page=3Dcom.atla= ssian.jira.plugin.system.issuetabpanels:all-tabpanel ] Glenn Justo Galvizo closed ASTERIXDB-2831. ------------------------------------------ Resolution: Fixed > Use a More Selective Approach to Array Index UPSERTs > ---------------------------------------------------- > > Key: ASTERIXDB-2831 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2831 > Project: Apache AsterixDB > Issue Type: Improvement > Reporter: Glenn Justo Galvizo > Priority: Major > > Array indexes currently perform UPSERTs by unconditionally deleting the o= ld array contents and inserting the new array contents. A "merge-join" insp= ired approach could be used here instead, where we iterate through the alre= ady sorted old and new arrays, compare the elements at each step, and selec= tively perform an insert / delete.=C2=A0 > =C2=A0 -- This message was sent by Atlassian Jira (v8.3.4#803005)