DV RAND() function in a column mask expression fails

Solution Verified - Updated -


  • Using RAND() function in a column mask expression to randomly generate a number for the mask value of an id column


  • Red Hat JBoss Data Virtualization (DV) 6.4
  • Dynamic VDB with mask expression:
<mask order="1">convert(RAND()*100000,integer)</mask>
  • Gives error:
ERROR [org.teiid.PROCESSOR] (Worker20_QueryProcessorQueue88) TEIID30019 Unexpected exception for request IAgYDrdYXFRm.30: org.teiid.core.TeiidComponentException: TEIID30091 org.teiid.api.exception.query.QueryResolverException: TEIID30091 Cannot create group 'sec AS sec__1' with multiple columns named 'expr'

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In