From issues-return-152561-archive-asf-public=cust-asf.ponee.io@hive.apache.org Tue Mar 12 21:13:49 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 4C4BB180600 for ; Tue, 12 Mar 2019 22:13:49 +0100 (CET) Received: (qmail 77410 invoked by uid 500); 12 Mar 2019 21:13:48 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 77401 invoked by uid 99); 12 Mar 2019 21:13:48 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Mar 2019 21:13:48 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 1B032C1B04 for ; Tue, 12 Mar 2019 21:13:48 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -110.301 X-Spam-Level: X-Spam-Status: No, score=-110.301 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id tPHhCO8e_8Qg for ; Tue, 12 Mar 2019 21:13:46 +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 2A5FB5F366 for ; Tue, 12 Mar 2019 21:04:02 +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 3C495E296C for ; Tue, 12 Mar 2019 21:04:01 +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 88659245A5 for ; Tue, 12 Mar 2019 21:04:00 +0000 (UTC) Date: Tue, 12 Mar 2019 21:04:00 +0000 (UTC) From: "Ashutosh Chauhan (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (HIVE-17061) Add Support for Column List in Insert Clause MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-17061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan resolved HIVE-17061. ------------------------------------- Resolution: Fixed Fix Version/s: 4.0.0 Resolved via HIVE-20590 > Add Support for Column List in Insert Clause > -------------------------------------------- > > Key: HIVE-17061 > URL: https://issues.apache.org/jira/browse/HIVE-17061 > Project: Hive > Issue Type: Improvement > Components: Transactions > Reporter: Shawn Weeks > Priority: Minor > Fix For: 4.0.0 > > > Include support for a list of columns in the insert clause of the merge statement. This helps when you may not know or care about the order of columns in the target table or if you don't want to have to insert values into all of the columns. > {code} > MERGE INTO target > USING source ON b = y > WHEN MATCHED AND c + 1 + z > 0 > THEN UPDATE SET a = 1, c = z > WHEN NOT MATCHED AND z IS NULL > THEN INSERT(a,b) VALUES(z, 7) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)