Hi Experts,
My HANA DB RELEASE : 1.00.122.22..
As per the note tying to add hint
WITH HINT (NO_CS_PROJECT, NO_USE_HEX_PLAN);
but getting an error as Invalid Hint when using NO_USE_HEX_PLAN .
NO_CS_PROJECT is working well if I give in the individual select statement but not in the union statement as shown below and it is giving the same message Numeric Overflow: Search Table Error: [6944] , please advise.
select fields from tabl1 innerjoin tab12
union
select * from tabl3 innerjoin tabl4
union
select from tabl5 innerjoin tabl6 on ....
and ...
with hint(no_cs_project);