[jira] [Updated] (IMPALA-728) HBase: NULL values not taken into account depending on the columns in SELECT

["Tim Armstrong (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Armstrong updated IMPALA-728:
---------------------------------
    Summary: HBase: NULL values not taken into account depending on the columns in SELECT  (was: NULL values not taken into account depending on the columns in SELECT)

> HBase: NULL values not taken into account depending on the columns in SELECT
> ----------------------------------------------------------------------------
>
>                 Key: IMPALA-728
>                 URL: https://issues.apache.org/jira/browse/IMPALA-728
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 1.1.1
>         Environment: IMPALA 1.1.1-1.p0.17
> CDH 4.4.0-1.cdh4.4.0.p0.39
>            Reporter: Christophe S
>            Priority: Minor
>              Labels: impala
>
> Data are in HBase:
> CREATE EXTERNAL TABLE ttt (
> id                      STRING,
> ...
> ...
> ...
> )STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" ="
> :key,
> ...
> ...
> ...
> ") TBLPROPERTIES("hbase.table.name" = "TTTT");
> select count(*) from TTT where ColA = 'ABCDE' 
> ==> 53 results
> select * from TTT where ColA = 'ABCDE' 
> ==> 178 results
> select ColA from TTT where ColA = 'ABCDE' 
> ==> 53 results
> Looks like sometimes the 'NULL' values are taken into account and sometimes not.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org