[
https://issues.apache.org/jira/browse/HIVE-16252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15935186#comment-15935186
]
Zoltan Haindrich commented on HIVE-16252:
-----------------------------------------
okay the 'Bug' type mislead me a bit :)
I'm trying to address this and HIVE-16253 with HIVE-16264 - but there are other
missing pieces to the puzzle...I'll link these tickets to relate to eachother
> Vectorization: Cannot vectorize: Aggregation Function UDF avg
> --------------------------------------------------------------
>
> Key: HIVE-16252
> URL: https://issues.apache.org/jira/browse/HIVE-16252
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Reporter: Rajesh Balamohan
>
> {noformat}
> select
> ss_store_sk, ss_item_sk, avg(ss_sales_price) as revenue
> from
> store_sales, date_dim
> where
> ss_sold_date_sk = d_date_sk
> and d_month_seq between 1212 and 1212 + 11
> group by ss_store_sk , ss_item_sk limit 100;
> 2017-03-20T00:59:49,526 INFO [680a4c08-1639-4bb9-8d6a-0bf0f30ef563 main]
> physical.Vectorizer: Validating ReduceWork...
> 2017-03-20T00:59:49,526 DEBUG [680a4c08-1639-4bb9-8d6a-0bf0f30ef563 main]
> physical.Vectorizer: Using reduce tag 0
> 2017-03-20T00:59:49,527 DEBUG [680a4c08-1639-4bb9-8d6a-0bf0f30ef563 main]
> lazybinary.LazyBinarySerDe: LazyBinarySerDe initialized with:
> columnNames=[_col0] columnTypes=[struct<count:bigint,sum:double,input:double>]
> 2017-03-20T00:59:49,527 DEBUG [680a4c08-1639-4bb9-8d6a-0bf0f30ef563 main]
> vector.VectorizationContext: Input Expression = Column[KEY._col0], Vectorized
> Expression = col 0
> ...
> ...
> 2017-03-20T00:59:49,528 INFO [680a4c08-1639-4bb9-8d6a-0bf0f30ef563 main]
> physical.Vectorizer: Cannot vectorize: Aggregation Function UDF avg parameter
> expression for GROUPBY operator: Data type
> struct<count:bigint,sum:double,input:double> of Column[VALUE._col0] not
> supported
> {noformat}
> Env: Hive build from: commit 71f4930d95475e7e63b5acc55af3809aefcc71e0 (march
> 16)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
