hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4116) Can't use views using map datatype.
Date Tue, 12 Nov 2013 20:18:17 GMT

    [ https://issues.apache.org/jira/browse/HIVE-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13820405#comment-13820405
] 

Hive QA commented on HIVE-4116:
-------------------------------



{color:green}Overall{color}: +1 all checks pass

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12613330/HIVE-4116.2.patch.txt

{color:green}SUCCESS:{color} +1 4602 tests passed

Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/246/testReport
Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/246/console

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12613330

> Can't use views using map datatype.
> -----------------------------------
>
>                 Key: HIVE-4116
>                 URL: https://issues.apache.org/jira/browse/HIVE-4116
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.8.1, 0.10.0, 0.11.0
>            Reporter: Karel Vervaeke
>            Assignee: Navis
>         Attachments: D12975.1.patch, HIVE-4116.2.patch.txt
>
>
> Executing the following 
> {noformat}
> DROP TABLE IF EXISTS `items`;
> CREATE TABLE IF NOT EXISTS `items` (id INT, name STRING, info MAP<STRING,STRING>)
PARTITIONED BY (ds STRING);
> DROP VIEW IF EXISTS `priceview`;
> CREATE VIEW `priceview` AS
>     SELECT
>         `items`.`id`,
>         `items`.info['price']
>     FROM
>         `items`
> ;
> select * from `priceview`;
> {noformat}
> Produces the following error:
> {noformat}
> karel@tomato:~/tmp$ $HIVE_HOME/bin/hive -f hivebug.sql
> WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter
in all the log4j.properties files.
> Logging initialized using configuration in jar:file:/home/karel/opt/hive-0.10.0-bin/lib/hive-common-0.10.0.jar!/hive-log4j.properties
> Hive history file=/tmp/karel/hive_job_log_karel_201303051117_945318761.txt
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in [jar:file:/home/karel/opt/hadoop-2.0.0-mr1-cdh4.0.0/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in [jar:file:/home/karel/opt/hive-0.10.0-bin/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
> OK
> Time taken: 5.449 seconds
> OK
> Time taken: 0.303 seconds
> OK
> Time taken: 0.131 seconds
> OK
> Time taken: 0.206 seconds
> FAILED: SemanticException line 3:22 mismatched input '.' expecting FROM near '`items`'
in from clause
>  in definition of VIEW priceview [
> SELECT
>         `items`.`id`,
>         `items``items`.`info`info['price']
>     FROM
>         `default`.`items`
> ] used as priceview at Line 3:14
> {noformat}
> Unless I'm not using the right syntax, I would expect this simple example to work. I
have tried some variations (quotes, no quotes, ...), to no avail.



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message