Transform should produce objects in the same type as specified at runtime
-------------------------------------------------------------------------
Key: HIVE-857
URL: https://issues.apache.org/jira/browse/HIVE-857
Project: Hadoop Hive
Issue Type: Bug
Affects Versions: 0.4.1, 0.5.0
Reporter: Zheng Shao
The following code fails at runtime, because the "clicked" field produced by
"transform" is actually of type String at runtime, instead of boolean.
{code}
INSERT OVERWRITE TABLE feature_index
SELECT
temp.feature,
temp.ad_id,
sum(if(temp.clicked, 1, 0)) / cast(count(temp.clicked) as DOUBLE) as
clicked_percent
FROM (
SELECT concat('ua:', trim(lower(ua.feature))) as feature, ua.ad_id, ua.clicked
FROM (
MAP raw_logs.user_agent, raw_logs.ad_id, raw_logs.clicked
USING 'my.py' as (feature STRING, ad_id STRING, clicked BOOLEAN)
FROM raw_logs
) ua
) temp
GROUP BY temp.feature, temp.ad_id;
{code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
