hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Ogden (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-6772) Virtual columns when used with Lateral View Explode results in SemanticException [Error 10004]
Date Fri, 28 Mar 2014 16:28:32 GMT
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)

Mime
View raw message