Unable to create Domain based on Virtual Data Source

While creating a Domain based on the Virtual data source customer was facing the below error :

Caused by: org.teiid.api.exception.query.QueryValidatorException: TEIID30492 Non-comparable expression of type object cannot be used in comparison

Virtual data sources use TEIID, hence is a different implementation than a normal JDBC data source and TEIID does not support UUID-type fields. For Virtual Data Source, SQL queries are validated against TEIID SQL and TEIID sees UUID fields as Objects.

You can try creating a view in your database first with the SQL and then create a Virtual Data source based on this view. The view should cast the UUID to string (ie text).

Here is an example using Postgres where store_id is a UUID type field :

 CREATE VIEW "vw_temp_store" AS

 SELECT

 CAST("temp_store"."store_id" as text) AS "store_id_cast",

 FROM "temp_store"