[
https://issues.apache.org/jira/browse/HADOOP-3601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12627424#action_12627424
]
qing yan commented on HADOOP-3601:
----------------------------------
Hi guys,
I am playing with the Hive binary right now and run into a problem : how to
reference an entry in a MAP type?
According to the example given in the PDF :
...
SELECT pv.userid, pv.properties['page type'];
but it doesn't work and is conflicting with the source code
org/apache/hive/ql/parse/SemanticAnalyzer.java
...
if (funcText.equals("[")){
// "[]" : LSQUARE/INDEX Expression
assert(children.size() == 2);
// Only allow constant integer index for now
if (!(children.get(1) instanceof exprNodeConstantDesc)
|| !(((exprNodeConstantDesc)children.get(1)).getValue()
instanceof Integer)) {
throw new
SemanticException(ErrorMsg.INVALID_ARRAYINDEX_CONSTANT.getMsg(expr));
}
My question is is MAP type supported in the current version and what is the
correct syntax for it?
Thank you!
> Hive as a contrib project
> -------------------------
>
> Key: HADOOP-3601
> URL: https://issues.apache.org/jira/browse/HADOOP-3601
> Project: Hadoop Core
> Issue Type: Wish
> Components: contrib/hive
> Affects Versions: 0.19.0
> Environment: N/A
> Reporter: Joydeep Sen Sarma
> Assignee: Ashish Thusoo
> Priority: Minor
> Fix For: 0.19.0
>
> Attachments: hive.tgz, hive.tgz, hive.tgz, HiveTutorial.pdf
>
> Original Estimate: 1080h
> Remaining Estimate: 1080h
>
> Hive is a data warehouse built on top of flat files (stored primarily in
> HDFS). It includes:
> - Data Organization into Tables with logical and hash partitioning
> - A Metastore to store metadata about Tables/Partitions etc
> - A SQL like query language over object data stored in Tables
> - DDL commands to define and load external data into tables
> Hive's query language is executed using Hadoop map-reduce as the execution
> engine. Queries can use either single stage or multi-stage map-reduce. Hive
> has a native format for tables - but can handle any data set (for example
> json/thrift/xml) using an IO library framework.
> Hive uses Antlr for query parsing, Apache JEXL for expression evaluation and
> may use Apache Derby as an embedded database for MetaStore. Antlr has a BSD
> license and should be compatible with Apache license.
> We are currently thinking of contributing to the 0.17 branch as a contrib
> project (since that is the version under which it will get tested internally)
> - but looking for advice on the best release path.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
