You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "S, Iswarya" <is...@intel.com> on 2017/04/12 10:23:41 UTC

Question on HIVE CASE statement

Hi All,

I am trying to use a case statement in HQL script, but I get below error.

'Cannot recognize input near 'case'  'when'.

INSERT OVERWRITE TABLE tableA PARTITION (version= 107)
CASE WHEN $var == 'ABC' THEN
SELECT * FROM (
SELECT * FROM TableB
UNION ALL
SELECT * FROM TableC
UNION ALL
SELECT * FROM TableD
UNION ALL
SELECT * FROM TableE
UNION ALL
SELECT * FROM TableF
) MERGE;
ELSE
SELECT * FROM TableB
END

Any suggestions/ideas?

Regards,
Iswarya