-3

Below is the code failing in Hive:

(Alias at 6:5 (END) is not recognized)

INSERT INTO WRKT_REGULATORY_COMPONE_RECLASS
select
case
when WRKT_REGULATORY_COMPONENT_FINAL.REVENUE_FLAG != 'Y'
AND WRKT_REGULATORY_COMPONENT_FINAL.EXCLUDED_FLAG = 'Y'
THEN WRKT_REGULATORY_COMPONE_RECLASS.EXECUTION_ORDER = '1'
END
FROM WRKT_REGULATORY_COMPONENT_FINAL
Jacob H
  • 2,455
  • 1
  • 12
  • 29
Ankit Soni
  • 1
  • 1
  • Does Hive require a column alias? Try like `END AS EXECUTION_ORDER` or something. – Jacob H Nov 07 '19 at 18:33
  • Also, you probably want an `ELSE` in there somewhere. `ELSE 0` perhaps? – Jacob H Nov 07 '19 at 18:35
  • Thanks Jacob, I tried both the things but no success. I will update once it get resolved. – Ankit Soni Nov 07 '19 at 18:41
  • Do you want to insert a new row or update an existing one? – forpas Nov 07 '19 at 18:54
  • Code is running now:INSERT INTO WRKT_REGULATORY_COMPONE_RECLASS(EXECUTION_ORDER) select (case when WRKT_REGULATORY_COMPONENT_FINAL.REVENUE_FLAG != 'Y' AND WRKT_REGULATORY_COMPONENT_FINAL.EXCLUDED_FLAG = 'Y' THEN '1' END) AS EXECUTION_ORDER FROM WRKT_REGULATORY_COMPONENT_FINAL – Ankit Soni Nov 07 '19 at 19:00

1 Answers1

1

this one: THEN WRKT_REGULATORY_COMPONE_RECLASS.EXECUTION_ORDER = '1' is wrong after THEN it should be literal 1 or column

leftjoin
  • 36,950
  • 8
  • 57
  • 116