[HIVE-857] Transform should produce objects in the same type as specified at runtime

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.4.1
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Zheng Shao
• Reporter: Zheng Shao
• Created: 25/Sep/09 21:03
• Updated: 17/Dec/11 00:06
• Resolved: 30/Sep/09 05:17

Description

The following code fails at runtime, because the "clicked" field produced by "transform" is actually of type String at runtime, instead of boolean.

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;