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 EB96318A15 for ; Thu, 14 Jan 2016 17:59:27 +0000 (UTC) Received: (qmail 36207 invoked by uid 500); 14 Jan 2016 17:59:25 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 36139 invoked by uid 500); 14 Jan 2016 17:59:25 -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 36129 invoked by uid 99); 14 Jan 2016 17:59:25 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Jan 2016 17:59:25 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 6235BC0554 for ; Thu, 14 Jan 2016 17:59:25 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.102 X-Spam-Level: X-Spam-Status: No, score=-0.102 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id y5MGVWmdF3bn for ; Thu, 14 Jan 2016 17:59:25 +0000 (UTC) Received: from mail-ob0-f172.google.com (mail-ob0-f172.google.com [209.85.214.172]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id C1B2020546 for ; Thu, 14 Jan 2016 17:59:24 +0000 (UTC) Received: by mail-ob0-f172.google.com with SMTP id ba1so499812667obb.3 for ; Thu, 14 Jan 2016 09:59:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=rHwVuGeic3WjCi0W9RfC6gMyrRdODwk/d1lye3ZSUSY=; b=E3dITOhotflmK9N9LYfBGv9RYR5VAnGk5Cy52iKssif2atc+0uyrPUNCA3PSZXkvY1 HVlwkO0aP2R50xBVJm9dbKZyqs9ai9Wah7ug7umLcNPbUD+XXSW9RFFaCVBdB5FFtJYJ D5qjIdK0EOWmucdZ9XSaNc/UwZ9tZPtuPP2ReRYpV+o6FvJYI2C0ugAZl2ScjF328Lmi /6zv7bxRWboUFU8BNedmSZupNQTsq+b8EQKycZQcVpukRzBcmLoWg6mRGBthVk//plP5 0/GBTpvp9Lk+gyEWBSMs1lC9sdUuQyImYk585UCt2cOv3UJD+KG5YM1Du3ZjXYuOV+aU wDLA== 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=rHwVuGeic3WjCi0W9RfC6gMyrRdODwk/d1lye3ZSUSY=; b=dVLddEKZbr9L6SHs6ZGj55nYfaUqwAJavygXQ9ipIHSUqrahi7mvfhS3Oj3DTTXqqq uhsAeLErI4H9ZwpoBu7x3x4mRjgHuyNJ2e9f+2qPLPgq/bY2n8gxi+P+qawAxAQ+ddN3 UbzX0INbsgjuMOgVWgm9we3EfFiX63WxJYVqce+KVoj2TTPwBJHGsfp3Os9fmkFWSgj/ jxiHjeBpUCpJdMNDVJ4kO+lb95quWXkgVMUHBw8oz5bFjC2mwF4rPDCdwSjGMVKhIver 1aJRrnSKKvl0q2ikr++6msxf2QYXCeF7FeN/FNfWgoTabrwlcOdXblSPiG1mWW7lAcMI MrgQ== X-Gm-Message-State: ALoCoQmpp8aaRrBC6swi/5Rn/NBxsiJ8Zy4DratC2/2AOl/7jyI4zQMHoiSskvvOTHnw4L5DyjEVj4RMAjhhBkb5r04tOHThFg== MIME-Version: 1.0 X-Received: by 10.60.233.132 with SMTP id tw4mr4694896oec.35.1452794358413; Thu, 14 Jan 2016 09:59:18 -0800 (PST) Received: by 10.202.229.18 with HTTP; Thu, 14 Jan 2016 09:59:18 -0800 (PST) Date: Thu, 14 Jan 2016 23:29:18 +0530 Message-ID: Subject: simple jason file analysing in Hive-0.14 using serde From: sri sowj To: user@hive.apache.org Content-Type: text/plain; charset=UTF-8 Hi All, I am trying to execute hive commands on json file using jsonserde's,but I am always getting null values ,but not actual data. I have used serde's provided in "code.google.com/p/hive-json-serde/downloads/list" link. I have tried multiple ways but all of the attempts were not successful. Please can some one help me with the exact steps to be followed and serde's to be used in order to work with json files in apache hive latest version (0.14) BR, San