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 45D82200B6F for ; Wed, 24 Aug 2016 15:50:18 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 444E4160AB1; Wed, 24 Aug 2016 13:50:18 +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 66194160AA4 for ; Wed, 24 Aug 2016 15:50:17 +0200 (CEST) Received: (qmail 52786 invoked by uid 500); 24 Aug 2016 13:50:16 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 52775 invoked by uid 99); 24 Aug 2016 13:50:16 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2016 13:50:16 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id B12FC1A0750 for ; Wed, 24 Aug 2016 13:50:15 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.978 X-Spam-Level: * X-Spam-Status: No, score=1.978 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H4=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=iwinjit.onmicrosoft.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id SE8S3FcF_dYO for ; Wed, 24 Aug 2016 13:50:13 +0000 (UTC) Received: from APC01-SG2-obe.outbound.protection.outlook.com (mail-sg2apc01on0117.outbound.protection.outlook.com [104.47.125.117]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id A75865FD1B for ; Wed, 24 Aug 2016 13:50:12 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iwinjit.onmicrosoft.com; s=selector1-winjit-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=WgAQOmf/ZdkOLVsCpijOxCiQxMsVITJygzauVESORgk=; b=Y9a2+iO3p9cBcMZHbQR49ByEj0onb4aEd2TbIpNPLnQTjaopRKGiwyO40vsnqZBSdNwkUOhk+x/XQ7nPSll+yDXUT7rzewKjxYDOT/5wZVNDXyeR9Svgb1OzashHbShZckinXX2qGB0LUjhh+n8RZAljLjj738lXOeemlTt4clc= Received: from PS1PR04MB1050.apcprd04.prod.outlook.com (10.165.37.22) by PS1PR04MB1050.apcprd04.prod.outlook.com (10.165.37.22) with Microsoft SMTP Server (version=TLS1_0, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA_P384) id 15.1.557.21; Wed, 24 Aug 2016 13:50:02 +0000 Received: from PS1PR04MB1050.apcprd04.prod.outlook.com ([10.165.37.22]) by PS1PR04MB1050.apcprd04.prod.outlook.com ([10.165.37.22]) with mapi id 15.01.0557.027; Wed, 24 Aug 2016 13:50:02 +0000 From: "Priyanka Raghuvanshi" To: "user@hive.apache.org" Subject: Fw: Hive update operation Thread-Topic: Hive update operation Thread-Index: AQHR/gxVv7b/qeSg1kaOw4/0WOVLsKBYIKWw Date: Wed, 24 Aug 2016 13:50:01 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-IN, en-US Content-Language: en-IN X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=PriyankaR@winjit.com; x-originating-ip: [25.169.60.4] x-ms-office365-filtering-correlation-id: a9dbe1b5-f9f4-4616-0f8a-08d3cc258bdc x-microsoft-exchange-diagnostics: 1;PS1PR04MB1050;6:WnaSHspvjwzstOC/LJ+aYNqA21Q/K7+OC7RqRfoDBI5PfFoyCFyo+GKXT4dVDcCPHH/c0o46JRq0w2f+wwDyr/MZfGKurmfj6ZGY5Q7q2PkgIIHm42uC2i+jF9OPtGn8FwoxNuLFymIIvxD6j8U8vvh85ONBoJ7zf8WRjhc5TT3KYXTZ/l2oH3MroaEEYRR2m/9sCulfZh7+8mu3GZu6s9n3iRwfOMrHWaZzSUUQ99oeRiotdTHICQnlo+dFtpP5vPhzIzUKfdKpN0PL3MLJhhd9XsjErwUaIIGiwoK0ItA=;5:abpt8P1Gv8/j+VjXevReihN1BQmCP7tBuIzs2Vw5ly2engLBRRyGPJTOenvRPo6lTPoGmexn67I/EFprNOwXdoBDVF2LmY9SPBN1v7lixfG3ZTDF0l2NHFbOnOTd1xOQMwUfWakgZ6RrhFXFf1mpGg==;24:5XRaa2KgsLdZzjwVTgr1rpcN13F1aBQDXurie4bxMCKpIAnAvbm8y830nNSmuNkULPf4hbZN3ubi7JGzD2gC1f3dWTqYmVKdS611fOH2Mvo=;7:PNf2YxWEYHwO5tBr9ojQl+ZYpIqfSUL0cUXF4McMcXME0yo4Bnr2+ZMwiaXCRCYYG16eVa7lNY+pxSe4ThF0419AiXZnkqCMaRpq1omGx9MWWDXSq/ccJoCBzZzt81lXlC/g/k07gn7mSBuQlgWMA1WAtzb1eUGq14GopsdT0HPpjhYZezIbnb6KVimfDLq68lsaK+hup+/T+MLHynrKJWfiXvF3Kl9G/PkTgXm8wauC7oxM53ykIpNStMUI4g5+ x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:PS1PR04MB1050; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040176)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046);SRVR:PS1PR04MB1050;BCL:0;PCL:0;RULEID:;SRVR:PS1PR04MB1050; x-forefront-prvs: 0044C17179 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(979002)(6009001)(7916002)(189002)(71364002)(199003)(80792005)(76576001)(19627405001)(33656002)(558084003)(3900700001)(450100001)(2950100001)(16236675004)(2351001)(2900100001)(7696003)(66066001)(102836003)(3846002)(7116003)(7846002)(5660300001)(68736007)(586003)(7736002)(97736004)(106116001)(189998001)(107886002)(110136002)(6116002)(11100500001)(87936001)(86362001)(122556002)(9686002)(1730700003)(81156014)(81166006)(8676002)(92566002)(8936002)(105586002)(77096005)(3660700001)(5002640100001)(10400500002)(19580405001)(99946001)(2501003)(101416001)(74316002)(54356999)(3280700002)(76176999)(15650500001)(19625215002)(2906002)(19580395003)(50986999)(106356001)(969003)(989001)(999001)(1009001)(1019001);DIR:OUT;SFP:1102;SCL:1;SRVR:PS1PR04MB1050;H:PS1PR04MB1050.apcprd04.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; received-spf: None (protection.outlook.com: winjit.com does not designate permitted sender hosts) spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_PS1PR04MB1050DB848E1F0A2AE523BA67D7EA0PS1PR04MB1050apcp_" MIME-Version: 1.0 X-OriginatorOrg: winjit.com X-MS-Exchange-CrossTenant-originalarrivaltime: 24 Aug 2016 13:50:01.8009 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 44738343-a364-4d50-ae42-2ab9b0724b4d X-MS-Exchange-Transport-CrossTenantHeadersStamped: PS1PR04MB1050 archived-at: Wed, 24 Aug 2016 13:50:18 -0000 --_000_PS1PR04MB1050DB848E1F0A2AE523BA67D7EA0PS1PR04MB1050apcp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ________________________________ From: Priyanka Raghuvanshi Sent: 24 August 2016 19:12 To: user@hive.apache.org Subject: Hive update operation Hi, Is it possible to update a table(ORC) using join or column of another table= (ORC)? Kind Regards, Priyanka Raghuvanshi --_000_PS1PR04MB1050DB848E1F0A2AE523BA67D7EA0PS1PR04MB1050apcp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable




From: Priyanka Raghuvanshi<= br> Sent: 24 August 2016 19:12
To: user@hive.apache.org
Subject: Hive update operation
 

Hi,


Is it possible to update a table(ORC) using join or = column of another table(ORC)?


Kind Regards,

Priyanka Raghuvanshi

--_000_PS1PR04MB1050DB848E1F0A2AE523BA67D7EA0PS1PR04MB1050apcp_--