[HIVE-7325] Support non-constant expressions for ARRAY/MAP type indices.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.1
• Fix Version/s: 0.14.0
• Release Note: Supports negative and non-constant expressions for ARRAY/MAP type indices.
• Assignee: Navis Ryu
• Reporter: Mala Chikka Kempanna
• Created: 01/Jul/14 20:33
• Updated: 29/Dec/14 02:33
• Resolved: 16/Sep/14 21:51

Description

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'

Issue Links

• contains: HIVE-1955 Support non-constant expressions for array indexes.
• is related to: HIVE-1955 Support non-constant expressions for array indexes.
• links to: review board