-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/25625/
-----------------------------------------------------------

(Updated Sept. 15, 2014, 1:33 a.m.)


Review request for hive.


Bugs: HIVE-7325
    https://issues.apache.org/jira/browse/HIVE-7325


Repository: hive-git


Description
-------

Here is my sample:
{code}
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"); 
{code}
The following join statement doesn't work. 
{code}
SELECT a.*, b.* from KEY_RECORD a join RECORD b 
WHERE a.RecordId[b.RecordID] is not null;
{code}
FAILED: SemanticException 2:16 Non-constant expression for map indexes not 
supported. Error encountered near token 'RecordID' 


Diffs
-----

  ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java b3389cc 
  ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java c503bbb 
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java e44f5ae 
  ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFIndex.java 
5911f2c 
  ql/src/test/org/apache/hadoop/hive/ql/exec/TestFunctionRegistry.java d7d2a34 
  ql/src/test/queries/clientpositive/array_map_access_nonconstant.q 
PRE-CREATION 
  ql/src/test/queries/negative/invalid_list_index.q c40f079 
  ql/src/test/queries/negative/invalid_list_index2.q 99d0b3d 
  ql/src/test/queries/negative/invalid_map_index.q c2b9eab 
  ql/src/test/queries/negative/invalid_map_index2.q 5828f07 
  ql/src/test/results/clientpositive/array_map_access_nonconstant.q.out 
PRE-CREATION 
  ql/src/test/results/compiler/errors/invalid_list_index.q.out a4179cd 
  ql/src/test/results/compiler/errors/invalid_list_index2.q.out aaa9455 
  ql/src/test/results/compiler/errors/invalid_map_index.q.out 4eb7afa 
  ql/src/test/results/compiler/errors/invalid_map_index2.q.out edc9bda 

Diff: https://reviews.apache.org/r/25625/diff/


Testing
-------


Thanks,

Navis Ryu

Reply via email to