[ https://issues.apache.org/jira/browse/IMPALA-8152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16758329#comment-16758329 ]
Tim Armstrong commented on IMPALA-8152: --------------------------------------- Probably the same as IMPALA-283 > Aggregate Commands on HBase Table Omit Null Values > -------------------------------------------------- > > Key: IMPALA-8152 > URL: https://issues.apache.org/jira/browse/IMPALA-8152 > Project: IMPALA > Issue Type: Bug > Affects Versions: Impala 2.12.0 > Reporter: Alan Jackoway > Priority: Major > > We have an HBase-backed impala table, which has a string column (for the > purpose of this jira, {{sCol}}) > There are records where that column is null, which we can observe with > queries like {{select * from table where sCol is null limit 1}} > However, when we run these commands, we get bad results: > {code:sql} > -- Returns 0 > select count(*) from table where sCol is null; > -- Returns only rows for string values (we only have a few options in this > case), no row for null > select sCol, count(*) from table group by sCol > {code} > These commands work as expected on parquet-backed tables. They also do not > work in Hive, where I will file a jira shortly. > -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org