Krisztian Kasa created HIVE-24446:
-------------------------------------
Summary: 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
{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)
