Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
From: Sharath Babu Basavaraja <sharathfeb12@gmail.com>
Date: Wed, 8 Jun 2016 16:13:19 -0700
Message-ID: <CAESzri+1SgBHSXqxd3eOeFvYH=b5WHpOH8phsu-Oy=Axq_Br7A@mail.gmail.com>
Subject: NPE while querying timestamp data type in ORC tables
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=089e01183dfe8a33680534cc73e8
archived-at: Wed, 08 Jun 2016 23:13:26 -0000

--089e01183dfe8a33680534cc73e8
Content-Type: text/plain; charset=UTF-8

Hi all,

I have a ORC Hive table with multiple columns. One of the column data type
(say column1) is of type timestamp. When I make a query 'select * from
table_name where column1 is null;', I get Null Pointer Exception.

Has anyone faced similar issue when you are making similar queries on
timestamp values checking if it is null?

Regards,
Sharath

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

<div dir=3D"ltr"><div><div><div><div>Hi all,<br><br></div>I have a ORC Hive=
 table with multiple columns. One of the column data type (say column1) is =
of type timestamp. When I make a query &#39;select * from table_name where =
column1 is null;&#39;, I get Null Pointer Exception. <br><br></div>Has anyo=
ne faced similar issue when you are making similar queries on timestamp val=
ues checking if it is null?<br><br></div>Regards,<br></div>Sharath<br></div=
>

--089e01183dfe8a33680534cc73e8--