Mala Chikka Kempanna created HIVE-7325: ------------------------------------------
Summary: Support non-constant expressions for MAP indexes. Key: HIVE-7325 URL: https://issues.apache.org/jira/browse/HIVE-7325 Project: Hive Issue Type: Bug Affects Versions: 0.13.1 Reporter: Mala Chikka Kempanna Fix For: 0.14.0 Here is my sample: CREATE TABLE RECORD(RecordID string, BatchDate string, Country string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,D:BatchDate,D:Country") TBLPROPERTIES ("hbase.table.name" = "RECORD"); CREATE TABLE KEY_RECORD(KeyValue String, RecordId map<string,string>) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key, K:") TBLPROPERTIES ("hbase.table.name" = "KEY_RECORD"); The following join statement doesn't work. SELECT a.*, b.* from KEY_RECORD a join RECORD b WHERE a.RecordId[b.RecordID] is not null; FAILED: SemanticException 2:16 Non-constant expression for map indexes not supported. Error encountered near token 'RecordID' -- This message was sent by Atlassian JIRA (v6.2#6252)