DV Error "org.teiid.core.TeiidRuntimeException: Planning error. Could not find symbol"

Solution Verified - Updated -

Issue

  • Running Select on view containing Concat on columns gives "Could not find symbol" error

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.3
  • View transformation containing Concat:
CREATE VIEW TEST_VIEW
AS
SELECT 'L'||C.COLUMN1||C.COLUMN2 AS ORG_ID,
       'L'||C.COLUMN1 AS BNDRY_ID,
....

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In