Hibernate Exception -- ast Syntax Query Exception

Question

SELECT GROUP_CONCAT(VALUE) FROM store_variant_option_value  
WHERE store_variant_id = '1461' GROUP BY store_variant_id

I want to run this query in java code but getting java

dialect exception

Tried everything from native sql to hibernate named query and findByquery.