You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2014/05/11 00:05:59 UTC
[jira] [Commented] (HIVE-6772) Virtual columns when used with
Lateral View Explode results in SemanticException [Error 10004]
[ 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)