You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2020/11/30 14:29:00 UTC
[jira] [Assigned] (HIVE-24446) Materialized View plan remove
explicit cast from query
[ https://issues.apache.org/jira/browse/HIVE-24446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa reassigned HIVE-24446:
-------------------------------------
> Materialized View plan remove explicit cast from 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)