Return-Path: 
 <user-return-17324-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
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 8B99A11FC3
	for <apmail-hive-user-archive@www.apache.org>;
 Sun, 17 Aug 2014 12:10:16 +0000 (UTC)
Received: (qmail 92846 invoked by uid 500); 17 Aug 2014 12:10:14 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 92776 invoked by uid 500); 17 Aug 2014 12:10:14 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 92766 invoked by uid 99); 17 Aug 2014 12:10:13 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Aug 2014 12:10:13 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of torkale@gmail.com designates
 209.85.213.44 as permitted sender)
Received: from [209.85.213.44] (HELO mail-yh0-f44.google.com) (209.85.213.44)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Aug 2014 12:10:08 +0000
Received: by mail-yh0-f44.google.com with SMTP id f73so3676651yha.3
        for <user@hive.apache.org>; Sun, 17 Aug 2014 05:09:48 -0700 (PDT)
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=XWXAxvvvEnBMgESxuLpQ29GHaGt49CET78VTZ2HkiMc=;
        b=RrFqRiFOMOvJbY8Ps2qsHuADrXmYupwWoL/RlzqHACRzz4xMRD6aRgG65A8Dh0RP4B
         3LEqjYCkkK42FhS5R52lYOb5G1YrrUrYc6buFaN1s2z3zrlcNB1kAG0rZox0hB+pttEo
         kkuZAAfJhOVSUHKwtLYj0sCOyKjCaOIlHmcI78FXyYL5W79D130TPtP4qmg3uHEZ+A+G
         NuNV5Mvo8t0Fse+ReDpZrSbiOSPNpItS7Jh1c+2giMFfQoXmeEKmcZLW2wmaIL66Dq94
         MLaxj8Ep8x+OYla5saVunn1rZHWLqTgNy/SDBYqZT+spGxsH+bc4HwxiBBtfgT5s0v5I
         9noQ==
MIME-Version: 1.0
X-Received: by 10.236.29.7 with SMTP id h7mr43619907yha.42.1408277388030; Sun,
 17 Aug 2014 05:09:48 -0700 (PDT)
Received: by 10.170.45.140 with HTTP; Sun, 17 Aug 2014 05:09:47 -0700 (PDT)
Date: Sun, 17 Aug 2014 15:09:47 +0300
Message-ID: 
 <CAMTeNcRO2T4F7N=GEa8aheJdWZLeeA-dcLTOyYYMhyzb_gKvzA@mail.gmail.com>
Subject: Hive queries returning all NULL values.
From: Tor Ivry <torkale@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=089e0149be927579970500d2218b
X-Virus-Checked: Checked by ClamAV on apache.org

--089e0149be927579970500d2218b
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi



I have a hive (0.11) table with the following create syntax:



CREATE EXTERNAL TABLE events(

=E2=80=A6

)

PARTITIONED BY(dt string)

  ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe'

  STORED AS

    INPUTFORMAT "parquet.hive.DeprecatedParquetInputFormat"

    OUTPUTFORMAT "parquet.hive.DeprecatedParquetOutputFormat"

    LOCATION '/data-events/success=E2=80=99;



Query runs fine.


I add hdfs partitions (containing snappy.parquet files).



When I run

hive

> select count(*) from events where dt=3D=E2=80=9C20140815=E2=80=9D

I get the correct result



*Problem:*

When I run

hive

> select * from events where dt=3D=E2=80=9C20140815=E2=80=9D limit 1;

I get

OK

NULL NULL NULL NULL NULL NULL NULL 20140815



*The same query in Impala returns the correct values.*



Any idea what could be the issue?



Thanks

Tor

--089e0149be927579970500d2218b
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote"><div dir=3D"ltr"><p>Hi</p>
<p>=C2=A0</p>
<p>I have a hive (0.11) table with the following create syntax:</p>
<p>=C2=A0</p>
<p>CREATE EXTERNAL TABLE events(</p>
<p>=E2=80=A6</p>
<p>)</p>
<p>PARTITIONED BY(dt string)</p>
<p>=C2=A0 ROW FORMAT SERDE &#39;parquet.hive.serde.ParquetHiveSerDe&#39;</p=
>
<p>=C2=A0 STORED AS</p>
<p>=C2=A0 =C2=A0 INPUTFORMAT &quot;parquet.hive.DeprecatedParquetInputForma=
t&quot;</p>
<p>=C2=A0 =C2=A0 OUTPUTFORMAT &quot;parquet.hive.DeprecatedParquetOutputFor=
mat&quot;</p>
<p>=C2=A0 =C2=A0 LOCATION &#39;/data-events/success=E2=80=99;</p>
<p>=C2=A0</p>
<p>Query runs fine.</p>
<p><br></p><p>I=C2=A0add hdfs partitions (containing snappy.parquet files).=
<br></p>
<p>=C2=A0</p>
<p>When I run</p>
<p>hive=C2=A0</p>
<p>&gt; select count(*) from events where dt=3D=E2=80=9C20140815=E2=80=9D</=
p>
<p>I get the correct result</p>
<p>=C2=A0</p>
<p><b>Problem:</b></p>
<p>When I run=C2=A0</p>
<p>hive</p>
<p>&gt; select * from events where dt=3D=E2=80=9C20140815=E2=80=9D limit 1;=
</p>
<p>I get</p>
<p>OK</p>
<p>NULL=C2=A0NULL=C2=A0NULL=C2=A0NULL=C2=A0NULL=C2=A0NULL=C2=A0NULL=C2=A020=
140815</p>
<p>=C2=A0</p>
<p><b>The same query in Impala returns the correct values.</b></p>
<p>=C2=A0</p>
<p>Any idea what could be the issue?</p>
<p>=C2=A0</p>
<p>Thanks</p><span class=3D"HOEnZb"><font color=3D"#888888">
<p>Tor</p></font></span></div>
</div><br></div>

--089e0149be927579970500d2218b--