INSERT OVERWRITE TABLE record PARTITION(dated='03-08-2013')
SELECT id, f_name, marks, CASE WHEN id=224 THEN 'KUMAR' ELSE l_name END AS l_name
FROM record;
INSERT OVERWRITE TABLE record PARTITION(dated='03-08-2013')
SELECT id, f_name, marks, CASE WHEN id=224 THEN 'KUMAR' ELSE l_name END AS l_name
FROM record WHERE [_whereClause_];
1条答案
按热度按时间sf6xfgos1#
使用以下查询:
有关更多说明,请参见此链接: