[jira] [Updated] (HIVE-24446) Materialized View plan alters explicit cast type in query

["Krisztian Kasa (Jira)" <ji...@apache.org>]

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

Krisztian Kasa updated HIVE-24446:
----------------------------------
    Summary: Materialized View plan alters explicit cast type in query  (was: Materialized View plan remove explicit cast from query)

> Materialized View plan alters explicit cast type in query
> ---------------------------------------------------------
>
>                 Key: HIVE-24446
>                 URL: https://issues.apache.org/jira/browse/HIVE-24446
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Major
>
> {code}
> create materialized view mv_tv_view_data_av2 stored as orc TBLPROPERTIES ('transactional'='true') as
> select
>   total_views `total_views`,
>   sum(cast(1.5 as decimal(9,4))) over (order by total_views) as quartile,
>   program
> from tv_view_data;
> {code}
> {code}
> LogicalProject(quartile=[CAST($0):DECIMAL(12, 1)], total=[$1])
>   HiveTableScan(table=[[arc_view, mv_tv_view_data_av1]], table:alias=[mv_tv_view_data_av1])
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)