Same Select Query with Timestamp Column Returns Different Results in Hive Shell and Impala (Doc ID 2035328.1)

Last updated on OCTOBER 11, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.1.0 and later
Linux x86-64

Symptoms

On Oracle Big Data Appliance 4.1/CDH 5.3.0 release same select query returns different results in Hive Shell and Impala. The select query has timestamp columns in join and where clause.

join .... activated_at between '2015-02-09' and '2015-02-10' ...
where .... dt between activated_at and date_add(activated_at,14)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms