Dynamic VDB named attributes in mapping statement are not automatically mapped to the corresponding column in the table definition

Solution Verified - Updated -

Issue

  • Dynamic VDB View model - named attributes in mapping statement are not automatically mapped to the corresponding column in the table definition
  • Unexpected sequential dependency between virtual table column order and mapping column sequence.
The statement to create a virtual table:

CREATE VIEW TargetModelViewName (
ColumnA …                           
ColumnB …                           
ColumnC …) …                        
AS SELECT 
SourceModel.SourceTable.ColX AS ColumnA,            
SourceModel.SourceTable.ColY AS ColumnC,            
SourceModel.SourceTable.ColZ AS ColumnB;            
  • DV doesn't map ColY to ColumnC, it maps ColZ because of the order.

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.2

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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.