[
https://issues.apache.org/jira/browse/HIVE-14026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15334988#comment-15334988
]
Sergey Shelukhin commented on HIVE-14026:
-----------------------------------------
This particular case seems to be by design for HBase because all rows have the
same key.
> data can not be retrieved
> -------------------------
>
> Key: HIVE-14026
> URL: https://issues.apache.org/jira/browse/HIVE-14026
> Project: Hive
> Issue Type: Sub-task
> Reporter: Pengcheng Xiong
>
> {code}
> DROP TABLE users;
> CREATE TABLE users(key string, state string, country string, country_id int)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES (
> "hbase.columns.mapping" = "info:state,info:country,info:country_id"
> );
> INSERT OVERWRITE TABLE users SELECT 'user1', 'IA', 'USA', 0 FROM src;
> select * from users;
> {code}
> The result is only one row:
> {code}
> user1 IA USA 0
> {code}
> should be 500 rows.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
