[JBoss JIRA] (TEIIDDES-1556) In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1556?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1556:
----------------------------------------
I think we can accomplish this in a couple ways. I vote for OPTION A since the first part is already in the tooling (aka product) even though it will be more work up front.
OPTION A:
* Source/Pushdown functions defined as procedures with FUNCTION = TRUE in Source models
** NOTE: This is already the paradigm in the 7.7.x branch & product
* UDF's defined as procedures with FUNCTION = TRUE in View models
** Requires logic to : "not require a transformation and to perform the same validations (only in parameters and a scalar result) as with the source function."
OPTION B:
* Use Source model procedures to define Pushdown AND UDFs
* Requires adding extension boolean property of PUSHDOWN
* We had decided earlier to use "Source Function" instead of "Pushdown Function", but if we add this property, then PUSHDOWN would be more descriptive than "Make Source Function" or something weird like that.
> In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1556
> URL: https://issues.jboss.org/browse/TEIIDDES-1556
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dialogs, Usability
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 8.1
>
>
> When selecting New Model Wizard, the Model Class drop down should indicate the Function Model is "Deprecated".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-1556) In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1556?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-1556:
------------------------------------------
> add validation for this use-case and error/warning if JAVA CLASS and/or JAVA METHOD are null
That's where there is some grey area in design. You would have an error only if the function were not marked as pushdown required. Also, if we want to change pushdown to a boolean pushdown_allowed metadata property that would be fine by me as there is little value in having the pushdown optional vs. no pushdown since translators have to declare support for a pushdown to happen.
> In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1556
> URL: https://issues.jboss.org/browse/TEIIDDES-1556
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dialogs, Usability
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 8.1
>
>
> When selecting New Model Wizard, the Model Class drop down should indicate the Function Model is "Deprecated".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-1556) In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1556?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1556:
----------------------------------------
* So our relational.mxd needs to add java-class and java-method properties.
* RelationalModelExtensionAssistant needs to relax the isPhysical() checks to allow properties to apply to virtual procedures also
** native-query and non-prepared properties will NOT apply to virtual procedures
** add validation for this use-case and error/warning if JAVA CLASS and/or JAVA METHOD are null
> In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1556
> URL: https://issues.jboss.org/browse/TEIIDDES-1556
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dialogs, Usability
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 8.1
>
>
> When selecting New Model Wizard, the Model Class drop down should indicate the Function Model is "Deprecated".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-1556) In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1556?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-1556:
------------------------------------------
> IMO, intuitively, FUNCTION=TRUE makes for sense for java code related functions that are run in the VM, not for something that's pushed down to the server for execution.
This discussion is about what makes sense for minimizing metamodels. The metadata of a Teiid procedure is a superset of the metadata needed to represent a function (see also pg sql that only has the notion of defining functions - there is no explicit create procedure). Designer can choose to do quite a bit presentational work if desired to make a procedure marked as a function look more intuitive to a MMX/legacy user.
> add Extension properties to the virtual Procedure (function) to account for the necessary properties
Correct me if I'm wrong, but some of those should be applicable already anyway since were already supposed to be defined by a general relational extension (varargs, null-on-null, category, etc.).
The JAVA_CLASS, JAVA_METHOD, etc. would similarly need to be added.
> Do the Aggregate Function Options apply here too? if( aggregate == TRUE) ??
Yes anything that would have related to a function would relate to a procedure representing a function.
> In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1556
> URL: https://issues.jboss.org/browse/TEIIDDES-1556
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dialogs, Usability
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 8.1
>
>
> When selecting New Model Wizard, the Model Class drop down should indicate the Function Model is "Deprecated".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-1556) In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1556?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1556:
----------------------------------------
[~blafond] Yes, those should be it. All the options are defined on the link you posted.
[~van.halbert] I think you are missed the "on source" model text. Also, we should not mix relational semantics with java, how it is implemented is not important. A function on view model is implemented currently in Java and on source model is pushdown to source.
> In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1556
> URL: https://issues.jboss.org/browse/TEIIDDES-1556
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dialogs, Usability
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 8.1
>
>
> When selecting New Model Wizard, the Model Class drop down should indicate the Function Model is "Deprecated".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-1556) In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1556?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-1556:
---------------------------------------
IMO, intuitively, FUNCTION=TRUE makes for sense for java code related functions that are run in the VM, not for something that's pushed down to the server for execution.
> In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1556
> URL: https://issues.jboss.org/browse/TEIIDDES-1556
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dialogs, Usability
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 8.1
>
>
> When selecting New Model Wizard, the Model Class drop down should indicate the Function Model is "Deprecated".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-1556) In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1556?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1556:
----------------------------------------
Looking at your FUNCTION OPTIONS section of your 8.3 docs, https://docs.jboss.org/author/display/TEIID/DDL+Metadata it would appear that we would need to add Extension properties to the virtual Procedure (function) to account for the necessary properties:
CATEGORY
DETERMINISM (NONDETERMINISTIC, COMMAND_DETERMINISTIC, SESSION_DETERMINISTIC, USER_DETERMINISTIC, VDB_DETERMINISTIC, DETERMINISTIC)
NULL-ON-NULL
JAVA_CLASS
JAVA_METHOD
VARARGS
AGGREGATE
Are there any more? and what will the extension "keys" be for these?
(i.e. : category, determinism, null-on-null, java-class, java-method, varargs, aggregate)
Do the Aggregate Function Options apply here too? if( aggregate == TRUE) ??
> In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1556
> URL: https://issues.jboss.org/browse/TEIIDDES-1556
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dialogs, Usability
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 8.1
>
>
> When selecting New Model Wizard, the Model Class drop down should indicate the Function Model is "Deprecated".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years
[JBoss JIRA] (TEIIDDES-1556) In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1556?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-1556:
------------------------------------------
> Currently any source Procedures marked with "FUNCTION == TRUE" are treated as source/pushdown functions by Teiid, correct?
Yes
> Does Teiid support that today?
Today no, but that's just because Designer does not support that path. It's a trivial change on our side to allow the virtual case as well.
On the Designer side you would just need to not require a transformation and to perform the same validations (only in parameters and a scalar result) as with the source function.
> In 8.0, the function metamodel has been deprecated, can the new model wizard drop down indicate as such
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1556
> URL: https://issues.jboss.org/browse/TEIIDDES-1556
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Dialogs, Usability
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 8.1
>
>
> When selecting New Model Wizard, the Model Class drop down should indicate the Function Model is "Deprecated".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years