Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 100A818060 for ; Thu, 22 Oct 2015 18:45:08 +0000 (UTC) Received: (qmail 58283 invoked by uid 500); 22 Oct 2015 18:45:00 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 58214 invoked by uid 500); 22 Oct 2015 18:45:00 -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 58203 invoked by uid 99); 22 Oct 2015 18:45:00 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2015 18:45:00 +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 8FCFBC0B1C for ; Thu, 22 Oct 2015 18:44:59 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3 X-Spam-Level: *** X-Spam-Status: No, score=3 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_IMAGE_ONLY_32=0.001, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=teamaol_com.20150623.gappssmtp.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id uIM3h5SuMAxH for ; Thu, 22 Oct 2015 18:44:54 +0000 (UTC) Received: from mail-io0-f175.google.com (mail-io0-f175.google.com [209.85.223.175]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 0A3D442B35 for ; Thu, 22 Oct 2015 18:44:54 +0000 (UTC) Received: by iodv82 with SMTP id v82so100912502iod.0 for ; Thu, 22 Oct 2015 11:44:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=teamaol_com.20150623.gappssmtp.com; s=20150623; h=mime-version:date:message-id:subject:from:to:content-type; bh=b1UMl2Y29BpeOjikQCdc11SzbknF2g4aam6jfA57m7Y=; b=rWwdCPOQBF4LLWBhoGTRbSmzdC3au5YeXHSr9BayIBxH33Om0GdJ/wVaac5C+3lCys dsWip2vUEbjN5Ji7Tj7Rh2P83TU6xnCbJjXZ6PAGt0uGCmwwNkNQoKjpDTzfZYDyWJ+H lkjZ6hQZWwKO9K5GydNc02ddr3GzqAvF2NMJZho5gHWLQqZogd3djWQMazyVVemGJPZ3 bckukiwAhFZUulm3BNTBXdv2uHAPptY2JrTgSLsEf5wy5PUs5HI6ivEq1mt6NmQQywRL AIB/rEQQUy60AGEvEYNNIvb1mBgQlZp/KHP7B5vwql8+jYF77UnmLFqX3U3Z167PKYoA WZVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to :content-type; bh=b1UMl2Y29BpeOjikQCdc11SzbknF2g4aam6jfA57m7Y=; b=Z7B7gQRqewjZoZ/UAIlka0vfkAz1EYYbT8FNlwm6gyLo51uCe3Z1SArkMfC0WiSjav e7s9VIxunq6o3m5D2HLfeg30A0a8rzb/rEyxMoRUKYyYCiJFslzolb1HKcRzlQ1VhTlC K7Pz1wRMgqQadyZbAx00Ctuvlk1zeD/Fj4fAloEDTEwJ5GpRbo0S1+0OpPDSb0NZvtAO Xe9nc4QQIWpLyzfu5v7R/El7d/6Oe/GcSkw/IUjF1Mn7HxT9Sw7i3fUGjdPsDpmtRwPe pL+FlBoRO62jXp3ZeemZWNb5nl5fZrO8jzDBhYB6lo9nwB5cBM2vepCzrHXu72xnseby bz/Q== X-Gm-Message-State: ALoCoQk8ZDkKgNUF3xqKvW05D458LsMgWicVtLSIxOqCTjmgP40YQSGA3j8lNRjleBprxYj4noLx MIME-Version: 1.0 X-Received: by 10.107.135.204 with SMTP id r73mr16006852ioi.164.1445539493569; Thu, 22 Oct 2015 11:44:53 -0700 (PDT) Received: by 10.64.62.202 with HTTP; Thu, 22 Oct 2015 11:44:53 -0700 (PDT) Date: Thu, 22 Oct 2015 14:44:53 -0400 Message-ID: Subject: Hive function to convert numeric IP address to "dot" format? From: Mark Sunderlin To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a113eca120607730522b5e4ac --001a113eca120607730522b5e4ac Content-Type: text/plain; charset=UTF-8 Does hive have a built in function to return a dotted-quad representation of an IP address given a network address as an integer as input? If not, does anyone have SQL they would be willing to share that does this? What I am looking for: My data is in the below "raw" format, I want it in the "dot" format. raw_formatdot_format166136010699.6.87.234162645867796.241.202.53 -- Mark E. Sunderlin Data Architect // Data Solutions P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way, Dulles, VA 20166 AIM: MESunderlin // Slack: @Mark.Sunderlin --001a113eca120607730522b5e4ac Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Does hive have a built in = function to return a dotted-quad representation of an IP address =C2=A0given a network address = as an integer as input?

If not, does an= yone have SQL they wou= ld be willing to share that does this?

What I am looking = for: My data is in the below "raw" format, I =C2=A0want it in the= "dot" format.

raw_formatdot_format
= 166136010699.6.87.234
162645867796.241.2= 02.53

--
Mark= E. Sunderlin
Data = Architect // Data Solutions
P: 703-265-6935 // C: 540-327-6222 // 22000 = AOL Way,=C2=A0 Dulles, VA=C2=A0 20166
AIM: MESunderlin // Slack: @Mark.Sunderlin
3D""

=
--001a113eca120607730522b5e4ac--