Steve Ogden created HIVE-6772:
---------------------------------
Summary: 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)
