hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6772) Virtual columns when used with Lateral View Explode results in SemanticException [Error 10004]
Date Sat, 10 May 2014 22:05:59 GMT

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

Navis commented on HIVE-6772:
-----------------------------

I think this is fixed by HIVE-3226 and others.

> Virtual columns when used with Lateral View Explode results in SemanticException [Error
10004]
> ----------------------------------------------------------------------------------------------
>
>                 Key: HIVE-6772
>                 URL: https://issues.apache.org/jira/browse/HIVE-6772
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.9.0
>         Environment: Red Hat Enterprise Linux Server release 6.3 (Santiago)
> Hadoop 2.0.0-cdh4.1.2
> Hive 0.9.0
>            Reporter: Steve Ogden
>            Priority: Minor
>
> When using the virtual columns with 'lateral view explode', I get the following error:
> FAILED: SemanticException [Error 10004]: Line 3:22 Invalid table alias or column reference
'INPUT__FILE__NAME': (possible column names are: _col0, _col1, _col2, _col3, _col4, _col5,
_col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17,
_col18, _col19, _col20, _col21, _col22)
> Here is the query:
> select
>   newMd5(concat(INPUT__FILE__NAME,BLOCK__OFFSET__INSIDE__FILE)) ukey,
>   flat_ric_cd as ric_cd
> from edwpoc.ts_rtd_gs_stg
> lateral view explode(split(ric_cd,',')) subView as flat_ric_cd



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message