David Ross created HIVE-13775:
---------------------------------
Summary: Predicates with trailing whitespace broken on PARQUET/ORC
Key: HIVE-13775
URL: https://issues.apache.org/jira/browse/HIVE-13775
Project: Hive
Issue Type: Bug
Affects Versions: 1.2.1
Reporter: David Ross
The following sequence works as expected:
{code}
drop table if exists test_text;
create table test_text stored as textfile as select 'M ';
select *, hex(`_c0`) from test_text;
select *, hex(`_c0`) from test_text where `_c0` = 'M ';
{code}
The last {{select}} correctly shows the single row. Note that the {{hex}} is
only for clarity.
However, on {{ORC}} and {{PARQUET}}, the predicate misses the single row:
{code}
drop table if exists test_parquet;
create table test_parquet stored as parquet as select 'M ';
select *, hex(`_c0`) from test_parquet;
select *, hex(`_c0`) from test_parquet where `_c0` = 'M ';
drop table if exists test_orc;
create table test_orc stored as orc as select 'M ';
select *, hex(`_c0`) from test_orc;
select *, hex(`_c0`) from test_orc where `_c0` = 'M ';
{code}
Similar tests against {{1.0.1}} work as expected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
