[ https://issues.apache.org/jira/browse/HIVE-4372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13640273#comment-13640273 ]
Yashaswy Andavilli commented on HIVE-4372: ------------------------------------------ This is the create command I am using to create the HBase-integrated table: CREATE EXTERNAL TABLE CALLCOUNTBYGENDER(Id STRING, Hour STRING, Gender String, Count String)STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:Hour,cf1:Gender,cf1:Count") TBLPROPERTIES ("hbase.table.name" = "hbase_cdr_summary_callcountbygender"); I am using the following hive statement to populate the above table: INSERT OVERWRITE TABLE CALLCOUNTBYGENDER SELECT concat(tod.hour,sd.SubscriberAgeGroup),tod.hour,sd.SubscriberAgeGroup,count(*) FROM FACT f JOIN TimeofDayD tod on f.timeofdaykey=tod.timeofdaykey JOIN SubscriberDemographicsD sd on f.SubscriberDemographicsKey=sd.SubscriberDemographicsKey GROUP BY tod.hour,sd.SubscriberAgeGroup; The table is getting populated correctly when I am viewing it in HBase, the third column 'Gender' is getting messed up. It is supposed to contain only male/female values but the Hour column values are also getting populated under Gender column. After repopulating the table again and again, it finally got populated correctly. I'm not sure what kind of a bug it is. > When trying to populate an external HBase table using a hive query involving > joins, the data is incorrectly getting mixed up inside the rows. > ---------------------------------------------------------------------------------------------------------------------------------------------- > > Key: HIVE-4372 > URL: https://issues.apache.org/jira/browse/HIVE-4372 > Project: Hive > Issue Type: Bug > Components: HBase Handler > Affects Versions: 0.10.0 > Reporter: Yashaswy Andavilli > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira