Skip to Content
0

Issue with "CONTAINS OR" query in SAP HANA query

Nov 02, 2016 at 02:06 PM

47

avatar image

Hi,

I am using HANA query with "CONTAINS OR" for searing the more than one OR condition for like search.

This is my query.

SELECT * FROM table WHERE DELETE_FLAG=0 AND ( CONTAINS(table.NAME,'%Ascendas Magyarorszag Kereskedelmi Korlatolt Felelossegu Tarsasag% OR %Ascendas (MALAYSIA) SDN BHD%')).

If I use that entire input, I could not get the records.But If I reduce the input length like below query, I can get the records. It seems like there is a data length issue on CONTAINS OR query.

SELECT * FROM table WHERE DELETE_FLAG=0 AND ( CONTAINS(table.NAME,'%Ascendas Magyarorszag% OR %Ascendas (MALAYSIA) SDN BHD%')).

How to achieve that CONTAINS OR query for larger input?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers