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)