hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Ross (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13775) Predicates with trailing whitespace broken on PARQUET/ORC
Date Tue, 17 May 2016 17:44:12 GMT
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)

Mime
View raw message