[ 
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aihua Xu updated HIVE-10085:
----------------------------
    Attachment: HIVE-10085.patch

When the sizes RowSchema and the columns after pruning are the same, right now, 
we don't update SEL operator info in ColumnPrunerLateralViewForwardProc while 
the order of the columns may get reordered and require to update SEL operator 
as well in this issue. 

> Lateral view on top of a view throws RuntimeException
> -----------------------------------------------------
>
>                 Key: HIVE-10085
>                 URL: https://issues.apache.org/jira/browse/HIVE-10085
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 1.2.0
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>         Attachments: HIVE-10085.patch
>
>
> Following the following sqls to create table and view and execute a select 
> statement. It will throw the runtime exception:
> {noformat}
> FAILED: RuntimeException 
> org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: "map" or "list" is 
> expected at function SIZE, but "int" is found
> {noformat}
> {noformat} 
> CREATE TABLE t1( symptom STRING,  pattern ARRAY<INT>,  occurrence INT, index 
> INT);
> CREATE OR REPLACE VIEW v1 AS
> SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
> pd.occurrence as cnt from t1 pd;
> SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
> pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
> pattern.pattern_id
> FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to