[JBoss JIRA] (TEIIDDES-2466) Create Preview VDB for only the model containing the table that is being preview
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2466?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2466:
----------------------------------------
initial commit to master: https://github.com/Teiid-Designer/teiid-designer/commit/d5fc29d2f6ac31804...
* Removed all legacy Preview VDB, Preview DS logic including
preferences for server view
* Replaced with Preview Data functionality that assumes source models
have JNDI names (references to deployed data sources)
* PreviewDataWorker/PreviewManager utilize the TeiidModelToDdlGenerator
to help construct a dynamic VDB containing the selected table/view in
it's model and any dependent source models containing only the dependent
tables/views/procedures. Call these model fragments
* Added panels and pages for JDBC, File (CSV, XML) and WS importers to
supply a JNDI name with option to auto-deploy a data source during the
import. This will enable Preview Data to be performed immediately after
import
* Preview Data will create the vdb-xml file, depoy it, execute the same
SQL against the vdb, then undeploy the vdb
> Create Preview VDB for only the model containing the table that is being preview
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2466
> URL: https://issues.jboss.org/browse/TEIIDDES-2466
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Data Preview, Patch Release
> Affects Versions: 9.0
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Fix For: 10.0.1
>
>
> RFE
> Currently once you preview one table a Preview VDB is created for all the models in the project, request that the Preview VDB only be created for the model containing the table that is being previewed.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years
[JBoss JIRA] (TEIIDDES-2811) Running a User-Defined Function uses the wrong syntax
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2811?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2811:
------------------------------------------
What source is your target? Generally exec would indicate a procedure not a function.
> Running a User-Defined Function uses the wrong syntax
> -----------------------------------------------------
>
> Key: TEIIDDES-2811
> URL: https://issues.jboss.org/browse/TEIIDDES-2811
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.3
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Barry LaFond
> Priority: Minor
> Attachments: Capture.PNG
>
>
> After deploying my VDB, and viewing it inside the Datasource Explorer inside of JBDS, running a User-Defined Function through the GUI does not work because it's executing the wrong query.
> Here's what JDV is doing.
> {code}
> 17:17:29,178 INFO [org.teiid.PLANNER] (Worker0_QueryProcessorQueue46)
> ============================================================================
> USER COMMAND:
> EXEC datasource.PGT('XPO')
> ----------------------------------------------------------------------------
> OPTIMIZE:
> EXEC datasource.PGT('XPO')
> ----------------------------------------------------------------------------
> GENERATE CANONICAL:
> EXEC datasource.PGT('XPO')
> CANONICAL PLAN:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING PlaceAccess
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING RaiseAccess
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING AssignOutputElements
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> ============================================================================
> EXECUTING CalculateCost
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_COL_STATS={datasource.PGT.AUDIT_CODE=[-1.0, -1.0], datasource.PGT.CLIENT_NBR=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
> ============================================================================
> EXECUTING PlanSorts
> AFTER:
> Project(groups=[datasource.PGT])
> Access(groups=[datasource.PGT])
> Source(groups=[datasource.PGT])
> ============================================================================
> EXECUTING CollapseSource
> AFTER:
> Project(groups=[datasource.PGT])
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=EXEC datasource.PGT('XPO')})
> ============================================================================
> CONVERTING PLAN TREE TO PROCESS TREE
> PROCESS PLAN =
> ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
> AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
> ============================================================================
> ----------------------------------------------------------------------------
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
> AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
> ============================================================================
> {code}
> And here's the query that actually gets run.
> {code}
> select ServiceTier.datasource.PGT ('ABC')
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'ServiceTier.datasource.PGT('ABC')' is an unknown form. Check that the function name and number of arguments is correct.
> Elapsed Time: 0 hr, 0 min, 0 sec, 18 ms.
> {code}
> The problem is "select ServiceTier.datasource.PGT ('ABC')" should be "exec ServiceTier.datasource.PGT ('ABC')".
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years
[JBoss JIRA] (TEIIDDES-2811) Running a User-Defined Function uses the wrong syntax
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2811?page=com.atlassian.jira.plu... ]
Steve Tran updated TEIIDDES-2811:
---------------------------------
Attachment: Capture.PNG
> Running a User-Defined Function uses the wrong syntax
> -----------------------------------------------------
>
> Key: TEIIDDES-2811
> URL: https://issues.jboss.org/browse/TEIIDDES-2811
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.3
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Barry LaFond
> Priority: Minor
> Attachments: Capture.PNG
>
>
> After deploying my VDB, and viewing it inside the Datasource Explorer inside of JBDS, running a User-Defined Function through the GUI does not work because it's executing the wrong query.
> Here's what JDV is doing.
> {code}
> 17:17:29,178 INFO [org.teiid.PLANNER] (Worker0_QueryProcessorQueue46)
> ============================================================================
> USER COMMAND:
> EXEC datasource.PGT('XPO')
> ----------------------------------------------------------------------------
> OPTIMIZE:
> EXEC datasource.PGT('XPO')
> ----------------------------------------------------------------------------
> GENERATE CANONICAL:
> EXEC datasource.PGT('XPO')
> CANONICAL PLAN:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING PlaceAccess
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING RaiseAccess
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING AssignOutputElements
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> ============================================================================
> EXECUTING CalculateCost
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_COL_STATS={datasource.PGT.AUDIT_CODE=[-1.0, -1.0], datasource.PGT.CLIENT_NBR=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
> ============================================================================
> EXECUTING PlanSorts
> AFTER:
> Project(groups=[datasource.PGT])
> Access(groups=[datasource.PGT])
> Source(groups=[datasource.PGT])
> ============================================================================
> EXECUTING CollapseSource
> AFTER:
> Project(groups=[datasource.PGT])
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=EXEC datasource.PGT('XPO')})
> ============================================================================
> CONVERTING PLAN TREE TO PROCESS TREE
> PROCESS PLAN =
> ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
> AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
> ============================================================================
> ----------------------------------------------------------------------------
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
> AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
> ============================================================================
> {code}
> And here's the query that actually gets run.
> {code}
> select ServiceTier.datasource.PGT ('ABC')
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'ServiceTier.datasource.PGT('ABC')' is an unknown form. Check that the function name and number of arguments is correct.
> Elapsed Time: 0 hr, 0 min, 0 sec, 18 ms.
> {code}
> The problem is "select ServiceTier.datasource.PGT ('ABC')" should be "exec ServiceTier.datasource.PGT ('ABC')".
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years
[JBoss JIRA] (TEIIDDES-2811) Running a User-Defined Function uses the wrong syntax
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2811?page=com.atlassian.jira.plu... ]
Steve Tran updated TEIIDDES-2811:
---------------------------------
Description:
After deploying my VDB, and viewing it inside the Datasource Explorer inside of JBDS, running a User-Defined Function through the GUI does not work because it's executing the wrong query.
Here's what JDV is doing.
{code}
17:17:29,178 INFO [org.teiid.PLANNER] (Worker0_QueryProcessorQueue46)
============================================================================
USER COMMAND:
EXEC datasource.PGT('XPO')
----------------------------------------------------------------------------
OPTIMIZE:
EXEC datasource.PGT('XPO')
----------------------------------------------------------------------------
GENERATE CANONICAL:
EXEC datasource.PGT('XPO')
CANONICAL PLAN:
Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
============================================================================
EXECUTING PlaceAccess
AFTER:
Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
============================================================================
EXECUTING RaiseAccess
AFTER:
Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
============================================================================
EXECUTING AssignOutputElements
AFTER:
Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
============================================================================
EXECUTING CalculateCost
AFTER:
Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_COL_STATS={datasource.PGT.AUDIT_CODE=[-1.0, -1.0], datasource.PGT.CLIENT_NBR=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PlanSorts
AFTER:
Project(groups=[datasource.PGT])
Access(groups=[datasource.PGT])
Source(groups=[datasource.PGT])
============================================================================
EXECUTING CollapseSource
AFTER:
Project(groups=[datasource.PGT])
Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=EXEC datasource.PGT('XPO')})
============================================================================
CONVERTING PLAN TREE TO PROCESS TREE
PROCESS PLAN =
ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
============================================================================
----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
============================================================================
{code}
And here's the query that actually gets run.
{code}
select ServiceTier.datasource.PGT ('ABC')
org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'ServiceTier.datasource.PGT('ABC')' is an unknown form. Check that the function name and number of arguments is correct.
Elapsed Time: 0 hr, 0 min, 0 sec, 18 ms.
{code}
The problem is "select ServiceTier.datasource.PGT ('ABC')" should be "exec ServiceTier.datasource.PGT ('ABC')".
was:It would be nice if changes in meta models would automatically propagate to dependent layers. For example, I update my datasource XMI so that a column has been added. In my base layer, the select query was "select * from XYZ". The meta model is not updated with the new column from the datasource XMI until I trigger JBDS to rebuild the workspace by adding a random space character in the "select * from XYZ" statement and pressing save. In cases where the select statement is not select *, it should do nothing since the user has explicitly defined the select.
> Running a User-Defined Function uses the wrong syntax
> -----------------------------------------------------
>
> Key: TEIIDDES-2811
> URL: https://issues.jboss.org/browse/TEIIDDES-2811
> Project: Teiid Designer
> Issue Type: Feature Request
> Affects Versions: 9.0.3
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Barry LaFond
> Priority: Minor
>
> After deploying my VDB, and viewing it inside the Datasource Explorer inside of JBDS, running a User-Defined Function through the GUI does not work because it's executing the wrong query.
> Here's what JDV is doing.
> {code}
> 17:17:29,178 INFO [org.teiid.PLANNER] (Worker0_QueryProcessorQueue46)
> ============================================================================
> USER COMMAND:
> EXEC datasource.PGT('XPO')
> ----------------------------------------------------------------------------
> OPTIMIZE:
> EXEC datasource.PGT('XPO')
> ----------------------------------------------------------------------------
> GENERATE CANONICAL:
> EXEC datasource.PGT('XPO')
> CANONICAL PLAN:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING PlaceAccess
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING RaiseAccess
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING AssignOutputElements
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> ============================================================================
> EXECUTING CalculateCost
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_COL_STATS={datasource.PGT.AUDIT_CODE=[-1.0, -1.0], datasource.PGT.CLIENT_NBR=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
> ============================================================================
> EXECUTING PlanSorts
> AFTER:
> Project(groups=[datasource.PGT])
> Access(groups=[datasource.PGT])
> Source(groups=[datasource.PGT])
> ============================================================================
> EXECUTING CollapseSource
> AFTER:
> Project(groups=[datasource.PGT])
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=EXEC datasource.PGT('XPO')})
> ============================================================================
> CONVERTING PLAN TREE TO PROCESS TREE
> PROCESS PLAN =
> ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
> AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
> ============================================================================
> ----------------------------------------------------------------------------
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
> AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
> ============================================================================
> {code}
> And here's the query that actually gets run.
> {code}
> select ServiceTier.datasource.PGT ('ABC')
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'ServiceTier.datasource.PGT('ABC')' is an unknown form. Check that the function name and number of arguments is correct.
> Elapsed Time: 0 hr, 0 min, 0 sec, 18 ms.
> {code}
> The problem is "select ServiceTier.datasource.PGT ('ABC')" should be "exec ServiceTier.datasource.PGT ('ABC')".
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years
[JBoss JIRA] (TEIIDDES-2811) Running a User-Defined Function uses the wrong syntax
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2811?page=com.atlassian.jira.plu... ]
Steve Tran updated TEIIDDES-2811:
---------------------------------
Issue Type: Bug (was: Feature Request)
> Running a User-Defined Function uses the wrong syntax
> -----------------------------------------------------
>
> Key: TEIIDDES-2811
> URL: https://issues.jboss.org/browse/TEIIDDES-2811
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.3
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Barry LaFond
> Priority: Minor
>
> After deploying my VDB, and viewing it inside the Datasource Explorer inside of JBDS, running a User-Defined Function through the GUI does not work because it's executing the wrong query.
> Here's what JDV is doing.
> {code}
> 17:17:29,178 INFO [org.teiid.PLANNER] (Worker0_QueryProcessorQueue46)
> ============================================================================
> USER COMMAND:
> EXEC datasource.PGT('XPO')
> ----------------------------------------------------------------------------
> OPTIMIZE:
> EXEC datasource.PGT('XPO')
> ----------------------------------------------------------------------------
> GENERATE CANONICAL:
> EXEC datasource.PGT('XPO')
> CANONICAL PLAN:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING PlaceAccess
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING RaiseAccess
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO')})
> ============================================================================
> EXECUTING AssignOutputElements
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]})
> ============================================================================
> EXECUTING CalculateCost
> AFTER:
> Project(groups=[datasource.PGT], props={PROJECT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0})
> Source(groups=[datasource.PGT], props={VIRTUAL_COMMAND=EXEC datasource.PGT('XPO'), OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_COL_STATS={datasource.PGT.AUDIT_CODE=[-1.0, -1.0], datasource.PGT.CLIENT_NBR=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
> ============================================================================
> EXECUTING PlanSorts
> AFTER:
> Project(groups=[datasource.PGT])
> Access(groups=[datasource.PGT])
> Source(groups=[datasource.PGT])
> ============================================================================
> EXECUTING CollapseSource
> AFTER:
> Project(groups=[datasource.PGT])
> Access(groups=[datasource.PGT], props={SOURCE_HINT=null, MODEL_ID=Schema name=datasource, nameInSource=null, uuid=mmuuid:a521401c-37c6-4d3c-909d-55599421a456, OUTPUT_COLS=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=EXEC datasource.PGT('XPO')})
> ============================================================================
> CONVERTING PLAN TREE TO PROCESS TREE
> PROCESS PLAN =
> ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
> AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
> ============================================================================
> ----------------------------------------------------------------------------
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> ProjectNode(0) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] [datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR]
> AccessNode(1) output=[datasource.PGT.AUDIT_CODE, datasource.PGT.CLIENT_NBR] EXEC datasource.PGT('XPO')
> ============================================================================
> {code}
> And here's the query that actually gets run.
> {code}
> select ServiceTier.datasource.PGT ('ABC')
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'ServiceTier.datasource.PGT('ABC')' is an unknown form. Check that the function name and number of arguments is correct.
> Elapsed Time: 0 hr, 0 min, 0 sec, 18 ms.
> {code}
> The problem is "select ServiceTier.datasource.PGT ('ABC')" should be "exec ServiceTier.datasource.PGT ('ABC')".
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years
[JBoss JIRA] (TEIIDDES-2811) Running a User-Defined Function uses the wrong syntax
by Steve Tran (JIRA)
Steve Tran created TEIIDDES-2811:
------------------------------------
Summary: Running a User-Defined Function uses the wrong syntax
Key: TEIIDDES-2811
URL: https://issues.jboss.org/browse/TEIIDDES-2811
Project: Teiid Designer
Issue Type: Feature Request
Affects Versions: 9.0.3
Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
64-bit Windows 7 environment
Reporter: Steve Tran
Assignee: Barry LaFond
Priority: Minor
It would be nice if changes in meta models would automatically propagate to dependent layers. For example, I update my datasource XMI so that a column has been added. In my base layer, the select query was "select * from XYZ". The meta model is not updated with the new column from the datasource XMI until I trigger JBDS to rebuild the workspace by adding a random space character in the "select * from XYZ" statement and pressing save. In cases where the select statement is not select *, it should do nothing since the user has explicitly defined the select.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years
[JBoss JIRA] (TEIIDDES-2811) Running a User-Defined Function uses the wrong syntax
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2811?page=com.atlassian.jira.plu... ]
Steve Tran updated TEIIDDES-2811:
---------------------------------
Environment:
Red Hat JBoss Data Virtualization 6.2.2 on EAP patched to version 6.4.5,
JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
64-bit Windows 7 environment
was:
Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
64-bit Windows 7 environment
> Running a User-Defined Function uses the wrong syntax
> -----------------------------------------------------
>
> Key: TEIIDDES-2811
> URL: https://issues.jboss.org/browse/TEIIDDES-2811
> Project: Teiid Designer
> Issue Type: Feature Request
> Affects Versions: 9.0.3
> Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP patched to version 6.4.5,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Barry LaFond
> Priority: Minor
>
> It would be nice if changes in meta models would automatically propagate to dependent layers. For example, I update my datasource XMI so that a column has been added. In my base layer, the select query was "select * from XYZ". The meta model is not updated with the new column from the datasource XMI until I trigger JBDS to rebuild the workspace by adding a random space character in the "select * from XYZ" statement and pressing save. In cases where the select statement is not select *, it should do nothing since the user has explicitly defined the select.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years