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 2E32C200B88 for ; Thu, 22 Sep 2016 19:05:19 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 2CCCD160AAD; Thu, 22 Sep 2016 17:05:19 +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 70CA3160AA9 for ; Thu, 22 Sep 2016 19:05:18 +0200 (CEST) Received: (qmail 99963 invoked by uid 500); 22 Sep 2016 17:05:17 -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 99953 invoked by uid 99); 22 Sep 2016 17:05:17 -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; Thu, 22 Sep 2016 17:05:17 +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 B505EC0D72 for ; Thu, 22 Sep 2016 17:05:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com 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 3ZZWU3n6JcJH for ; Thu, 22 Sep 2016 17:05:14 +0000 (UTC) Received: from mail-oi0-f41.google.com (mail-oi0-f41.google.com [209.85.218.41]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 96FDC5F296 for ; Thu, 22 Sep 2016 17:05:14 +0000 (UTC) Received: by mail-oi0-f41.google.com with SMTP id r126so105017987oib.0 for ; Thu, 22 Sep 2016 10:05:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to; bh=frmZTzDbyhW6u3aZR/79uFILo7Cu3AY38CGS3yyP68o=; b=Cr+vQAA52ms1JIR4nRLGvESXcRgorkoEz0+1vuayQLLaBRF2JzJ5O41Iqo7AkJQEuN i5pPgQxmA7LwOni2etn8cU5v1BKrFwZRD8V+OWTCeVJoEhz79O9SRXhnwY++I66DQnde u9SU/o7LQ/rqahzw0C4cHG+aXfc3+cYlnSEcun312chfpQQ14e9xmEFPtcQmgODSoQVY efEDU70UNYpBI97ShhwQP61QbbvXdUZXnsYQV73SjPsuKBD9YdkpZ30/u5KTdbIo5UNz +GkwEOQ/mc43AWvTjyv3Ar1UeMHJ+QkzXeiOlBfIUj1SurSqc/fD+EYT2weOmRWFTSZL aTtg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=frmZTzDbyhW6u3aZR/79uFILo7Cu3AY38CGS3yyP68o=; b=bjcTyerh0Fd3oc6muij6k/zi9U/YJZEMyI1LBnVGfTeFWxnxsGzOR/DxQUC76sCBpf syu2NyLanTXeT7pD1ttGKgpaNq4FTVZZlZhYui0IULpdC8qGapdynEKv9gzh9ClaWtDO WSGEnRLicGIDsudQOZUZhwA9VgVnjHszk9WAp2kuT90Q0KNV5fEnV7kJfuZRrWqW1AWC SkfeNQbXi/B2yuwT3W6PIbpXZHiOz19erC4P1MOQ8mJttPO7bbJ1CtvckatMqDEPBrug NBUe/AAbP0/72vdydNqSmNRVZ2ogCOI2roBvsgbDq/4zl8eOjOfJAlFellvhWWEv6adC PVYA== X-Gm-Message-State: AE9vXwNjrUogXP9LqXFVsRKqf88Pw/Wc2hJ9eqnqLZG9xGt/mgPpd+KXlaVnQWrGQ2okNkl15CbQTWcTCabzaw== X-Received: by 10.202.89.66 with SMTP id n63mr4110592oib.90.1474563909367; Thu, 22 Sep 2016 10:05:09 -0700 (PDT) MIME-Version: 1.0 Received: by 10.202.188.84 with HTTP; Thu, 22 Sep 2016 10:05:07 -0700 (PDT) From: Manish R Date: Thu, 22 Sep 2016 22:35:07 +0530 Message-ID: Subject: iso 8601 to utc with timezone conversion To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a113d597c043de3053d1baa02 archived-at: Thu, 22 Sep 2016 17:05:19 -0000 --001a113d597c043de3053d1baa02 Content-Type: text/plain; charset=UTF-8 Hi Guys, There is a scenario here that I am trying to implement I have a table say table1 which contains aid and request_date in ISO 8601 format. I have one more table say table2 which contains aid and timezone details. Now I want to convert request_date from table1 to UTC and apply the timezone that is in table2 format for that corresponding aid. Table 1 example data *2016-09-15T23:45:22.943762Z abs123* *2016-09-16T22:48:12.943762Z erty456* Table 2 example data *abs123 Asia/Kolkata* *erty456 Europe/Amsterdam* --001a113d597c043de3053d1baa02 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Guys,

There is a = scenario here that I am trying to implement

I have a table say table1 w= hich contains aid and request_date in ISO 8601 format. I have one more tabl= e say table2 which contains aid and timezone details. Now I want to convert= request_date from table1 to UTC and apply the timezone that is in table2 f= ormat for that corresponding aid.

=
Table 1 example data
2016-09-15T23:45:22.943762Z abs1= 23
2016-09-1= 6T22:48:12.943762Z erty456

Table 2 example data
abs123 =C2=A0 Asia/Kolka= ta
erty456 = =C2=A0Europe/Amsterdam
--001a113d597c043de3053d1baa02--