Rajesh Balamohan created HIVE-16252:
---------------------------------------
Summary: 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)
