david created HIVE-12844: ---------------------------- Summary: hive-1.2.1 doesn't return correct value when run select count query Key: HIVE-12844 URL: https://issues.apache.org/jira/browse/HIVE-12844 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 1.2.1 Reporter: david Priority: Critical
in hbase 1.0.2,I created a table 'test1',it has below rows and values: hbase(main):027:0> scan 'test1' ROW COLUMN+CELL a1 column=df1:a2, timestamp=1452505991743, value=ddd a1 column=df1:a3, timestamp=1452506082723, value=eee a1 column=df1:c2, timestamp=1452505705391, value=bbb b1 column=df1:a2, timestamp=1452505838737, value=ccc b1 column=df1:a3, timestamp=1452506149461, value=fff r1 column=df1:a, timestamp=1452507261849, value=hhh r1 column=df1:a1, timestamp=1452507100774, value=ggg r1 column=df1:c1, timestamp=1451221711588, value=aaa then I created hive-1.2.1 table: create external table test3( key string, coll string, col2 string, col3 string, col4 string, col5 string, col6 string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,df1:a,df1:1,df1:a2,df1:a3,df1:c1,df1:c2") TBLPROPERTIES("hbase.table.name" = "test1"); when I run query in hive: hive> select * from test3; OK a1 NULL NULL ddd eee NULL bbb b1 NULL NULL ccc fff NULL NULL r1 hhh NULL NULL NULL aaa NULL the result is correct,but when I run: select count(1) from test3; Total MapReduce CPU Time Spent: 6 seconds 770 msec OK 1 it returns "1",I find that it doesn't count the rows where the first column is null, Could you help to analyze this? by the way the hadoop version is 2.6.0 -- This message was sent by Atlassian JIRA (v6.3.4#6332)