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 2667D200ACA for ; Thu, 9 Jun 2016 11:17:35 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 2519A160A58; Thu, 9 Jun 2016 09:17:35 +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 46ED9160A2B for ; Thu, 9 Jun 2016 11:17:34 +0200 (CEST) Received: (qmail 40032 invoked by uid 500); 9 Jun 2016 09:17:33 -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 40022 invoked by uid 99); 9 Jun 2016 09:17:33 -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; Thu, 09 Jun 2016 09:17:33 +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 94FBE1A090F for ; Thu, 9 Jun 2016 09:17:32 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 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_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id OE9fCh26-TKb for ; Thu, 9 Jun 2016 09:17:28 +0000 (UTC) Received: from mail-qg0-f52.google.com (mail-qg0-f52.google.com [209.85.192.52]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id D9AB15F3A0 for ; Thu, 9 Jun 2016 09:17:27 +0000 (UTC) Received: by mail-qg0-f52.google.com with SMTP id p34so17163927qgp.1 for ; Thu, 09 Jun 2016 02:17:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=Lv5LnrkUYC4aM9/3m+0OeNZgcxrXGltL1QjCDQudhvQ=; b=VQuOl8dQEbNQ8Ce+0cBcfhORALgT+0ay0Abn1e4ZGsQKYRNPSly9iZG/c+mcdRRtgV IT3PiCCvJ/XcwerC6oSCaEqOgDeQuBRkdVBjpFBoByzEH/cNuviBNl8QB90U8H2EcxlR l0dXymnZZGGUhTkp7b+k04k03Z8EauA9pRW/8zc7BLsK8+5NU8RDMdhn11YeMyLUSUob /Lq1ZC2QJN328fodNVybAz4JmsXmwmXPyyX4Yau0H0fq7sORT5hEN6Tyqn7czutw3y9i exRU7HZdLWgHCH5VMQPeIuwWACBYaBljU5KWOJNpMSuWGDHMAIZ4oAREz4nizL6IcYK9 ZB5g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=Lv5LnrkUYC4aM9/3m+0OeNZgcxrXGltL1QjCDQudhvQ=; b=IqKEMbaVhs8KWUBW1PFghsDB4lkgZupxrchyZg5aVr+K+kDGFPyt7Cvv9D5S1E+UMV qDFVuCYLfrFmyLJ4Tuzcd5aMxTJngNInlAvdXUhWz3ulCpT+ofqZLrFvMdwXTxS4/07E lJjc4U3AebXpt4pr2lFtVZiJbwp8NhDaYJE+m3XbE9cFL0O6COGtmIdJ+mNZyyv87UCN 0e9Zvnu2LcLBgHV/NPB1ElBxHX+AEd9lhXY3Lkb37PWG9eeSBz4aC5x5hCKSCO9jKP+x oEj70nQNJlQzak7yCxrfaeYJ0A0J7PZlnNmHu0d6n1J+cy+V7Ksc9tn9Ld2EQBJwN9/5 pMkg== X-Gm-Message-State: ALyK8tKIJUbCllWNLP25WvswnHdDFbYPkwxM3RfhLwqrt3SoZF5/0xVLy5prwWO0y6Q/aiy6Rtx3CtC3bL632w== X-Received: by 10.140.215.136 with SMTP id l130mr2164365qhb.1.1465463847032; Thu, 09 Jun 2016 02:17:27 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.126.131 with HTTP; Thu, 9 Jun 2016 02:17:26 -0700 (PDT) In-Reply-To: References: From: Mich Talebzadeh Date: Thu, 9 Jun 2016 10:17:26 +0100 Message-ID: Subject: Re: Using Hive table for twitter data To: user Content-Type: multipart/alternative; boundary=94eb2c09dc4a089bd10534d4e4a7 archived-at: Thu, 09 Jun 2016 09:17:35 -0000 --94eb2c09dc4a089bd10534d4e4a7 Content-Type: text/plain; charset=UTF-8 thanks Gopal that link 404 - OOPS! Looks like you wandered too far from the herd! LOL Any reason why that table in Hive cannot read data in? cheers Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 9 June 2016 at 10:09, Gopal Vijayaraghavan wrote: > > > Has anyone done recent load of twitter data into Hive table. > > Not anytime recently, but the twitter corpus was heavily used to demo Hive. > > Here's the original post on auto-learning schemas from an arbitrary > collection of JSON docs (like a MongoDB dump). > > http://hortonworks.com/blog/discovering-hive-schema-in-collections-of-json- > documents/ > > > Cheers, > Gopal > > > --94eb2c09dc4a089bd10534d4e4a7 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
thanks Gopal

that link
=

404 - OOPS!

Looks like you wandered too fa= r from the herd!

LOL

Any = reason why that table in Hive cannot read data in?

cheers


On 9 June 2016 at 10:09, Gopal Vijayaraghava= n <gopalv@apache.org> wrote:

> Has anyone done recent load of twitter data into Hive table.

Not anytime recently, but the twitter corpus was heavily used to dem= o Hive.

Here's the original post on auto-learning schemas from an arbitrary
collection of JSON docs (like a MongoDB dump).

http://hortonworks.com/blo= g/discovering-hive-schema-in-collections-of-json-
documents/



Cheers,
Gopal



--94eb2c09dc4a089bd10534d4e4a7--