I am getting following error message:
Select array_get(cst_mdl.overview.tags, 1) from overview
- org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate array_get(cst_mdl.overview.tags, 1): TEIID30384 Error while evaluating function array_get
Can yo attach the JSON document that is part of this View? May be along with you can attach the VDB you are using.
Using the latest Teiid 10.2 version I see the result fine, granted it can be better in detecting the data type of the array column. What version are you using?
Could you please let me know the steps to see the result for array
datatype. Screenshots will be really helpful to replicate the same in my
I am using 9.0.0 version of teiid designer.
Tata Consultancy Services
Looks like the Designer does not support the Array Type columns, see [TEIIDDES-2621] Support for array datatype - JBoss Issue Tracker
However, if you convert the data type of "tags" column to "string", you will see the data through Designer. If you are using Dynamic VDB, then you can convert the column type as "string" then you should be able to able query as
select array_get(tags,1) from mytable.
once you deploy the VDB to server and query through any SQL client. Sorry, I was assuming you were not using the Designer before. If you are a customer please raise an issue with RedHat support, otherwise, you need to wait for above JIRA or switch using to Dynamic VDB.
I said to change that in the Dynamic VDB, which nothing but an XML/DDL based text file NOT in Designer.
When you create the VDB, on VDB explorer page, there is a button to export VDB as Dynamic VDB, using that edit, then deploy the edited file to Teiid server. Then connect with your JDBC client tool like SquirreL and issue commands.