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