[
https://issues.apache.org/jira/browse/HIVE-24446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa updated HIVE-24446:
----------------------------------
Description:
{code:java}
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:java}
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}
Some constant decimal values are not padded in the result set.
{code}
select
POSTHOOK: query: select
t.quartile,
t.quartile,
max(t.total_views) total
max(t.total_views) total
from wealth t2,
from wealth t2,
(select
(select
total_views `total_views`,
total_views `total_views`,
sum(cast(1.5 as decimal(9,4))) over (order by total_views) as quartile,
sum(cast(1.5 as decimal(9,4))) over (order by total_views) as quartile,
program
program
from tv_view_data) t
from tv_view_data) t
where t.program=t2.watches
where t.program=t2.watches
group by quartile
group by quartile
order by quartile
{code}
{code}
1.5 1300000
4.5 15000000
6.0 20000000
{code}
was:
{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}
> 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:java}
> 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:java}
> 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}
> Some constant decimal values are not padded in the result set.
> {code}
> select
> POSTHOOK: query: select
> t.quartile,
> t.quartile,
> max(t.total_views) total
> max(t.total_views) total
> from wealth t2,
> from wealth t2,
> (select
> (select
> total_views `total_views`,
> total_views `total_views`,
> sum(cast(1.5 as decimal(9,4))) over (order by total_views) as quartile,
> sum(cast(1.5 as decimal(9,4))) over (order by total_views) as quartile,
> program
> program
> from tv_view_data) t
> from tv_view_data) t
> where t.program=t2.watches
> where t.program=t2.watches
> group by quartile
> group by quartile
> order by quartile
> {code}
> {code}
> 1.5 1300000
> 4.5 15000000
> 6.0 20000000
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
