[jira] Commented: (HADOOP-3601) Hive as a contrib project

["qing yan (JIRA)" <ji...@apache.org>]

    [ 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.