[JBoss JIRA] (TEIIDDES-1667) Ability to define UDF with vararg to be used in a static VDB
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1667?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1667:
----------------------------------------
Correct Steve... did not add that comment here that Teiid runtime does not load Function Model Indexes so any extension data (aka VARARGS="TRUE") will not get picked up. For this release a user will need to be use a source model procedure as a function instead.
We'll need to cover this in the release notes
> Ability to define UDF with vararg to be used in a static VDB
> ------------------------------------------------------------
>
> Key: TEIIDDES-1667
> URL: https://issues.jboss.org/browse/TEIIDDES-1667
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 8.0
> Environment: JBoss AS 7.1.1
> Teiid 8.3.0
> Teiid Designer 8.0.0
> Reporter: Shakir Shaik
> Assignee: Mark Drilling
> Fix For: 8.2
>
> Attachments: FunctionMethodDescriptor.patch, FunctionPlugin.patch, MyMathFunctions.jar, MyMathFunctions.java, RelationalPlugin.patch, UdfManager.patch
>
>
> I am not able to use a UDF with vararg and deploy the same in a static VDB.
> Please see the details in the following thread of Teiid Designer User forum discussions:
> https://community.jboss.org/thread/223823?tstart=0
--
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
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1667) Ability to define UDF with vararg to be used in a static VDB
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1667?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-1667:
------------------------------------------
Using a function model will not work at runtime as we have no mechanism for associating extension metadata. Otherwise if you are using a relational model, then we'll need to validate that the appropriate extension properties have been set in the index metadata.
> Ability to define UDF with vararg to be used in a static VDB
> ------------------------------------------------------------
>
> Key: TEIIDDES-1667
> URL: https://issues.jboss.org/browse/TEIIDDES-1667
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 8.0
> Environment: JBoss AS 7.1.1
> Teiid 8.3.0
> Teiid Designer 8.0.0
> Reporter: Shakir Shaik
> Assignee: Mark Drilling
> Fix For: 8.2
>
> Attachments: FunctionMethodDescriptor.patch, FunctionPlugin.patch, MyMathFunctions.jar, MyMathFunctions.java, RelationalPlugin.patch, UdfManager.patch
>
>
> I am not able to use a UDF with vararg and deploy the same in a static VDB.
> Please see the details in the following thread of Teiid Designer User forum discussions:
> https://community.jboss.org/thread/223823?tstart=0
--
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
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1667) Ability to define UDF with vararg to be used in a static VDB
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1667?page=com.atlassian.jira.plu... ]
Mark Drilling commented on TEIIDDES-1667:
-----------------------------------------
Barry,
I applied the patches. It did require a couple more changes to get the function procedures to validate (I test 'both ways': ScalarFunction in a Function Model and a function procedure in a Relational Model). Once I got everything to validate, I attempted to run a preview and also deploy a VDB with the models. I'm getting the following exception. This was against a 8.3 (CR2) Teiid Server...
----------------------------------------------
16:53:36,865 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB PREVIEW_788ae101-13e9-447a-85cf-c3487c52f8fc_TEIIDDES1667_FuncTestMdl.1 model "FuncTestMdl" metadata is currently being loaded. Start Time: 5/10/13 4:53 PM
16:53:36,871 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB PREVIEW_788ae101-13e9-447a-85cf-c3487c52f8fc_TEIIDDES1667_FuncTestMdl.1 model "FuncTestMdl" metadata loaded. End Time: 5/10/13 4:53 PM
16:53:36,885 ERROR [org.jboss.threads.executor] (teiid-async-threads - 4) Task execution failed for task org.teiid.jboss.VDBService$6@566749c5: org.teiid.metadata.MetadataException: TEIID30388 UDF "MakeList(object items) : object result" could not be loaded, since no method on class "org.me.functions.MyMathFunctions" with name "makeList" has a matching type signature.
at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:326) [teiid-engine-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:225) [teiid-engine-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:99) [teiid-engine-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:86) [teiid-runtime-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:254) [teiid-runtime-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:289) [teiid-runtime-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:180) [teiid-runtime-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.jboss.VDBService.access$900(VDBService.java:93) [teiid-jboss-integration-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.jboss.VDBService$6.run(VDBService.java:398) [teiid-jboss-integration-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:801)
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:842)
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: java.lang.NoSuchMethodException: makeList Args: [class org.teiid.query.util.CommandContext, class java.lang.Object]
at org.teiid.core.util.ReflectionHelper.findBestMethodWithSignature(ReflectionHelper.java:191) [teiid-common-core-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:320) [teiid-engine-8.3.0.CR2-SNAPSHOT.jar:8.3.0.CR2-SNAPSHOT]
... 14 more
> Ability to define UDF with vararg to be used in a static VDB
> ------------------------------------------------------------
>
> Key: TEIIDDES-1667
> URL: https://issues.jboss.org/browse/TEIIDDES-1667
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 8.0
> Environment: JBoss AS 7.1.1
> Teiid 8.3.0
> Teiid Designer 8.0.0
> Reporter: Shakir Shaik
> Assignee: Mark Drilling
> Fix For: 8.2
>
> Attachments: FunctionMethodDescriptor.patch, FunctionPlugin.patch, MyMathFunctions.jar, MyMathFunctions.java, RelationalPlugin.patch, UdfManager.patch
>
>
> I am not able to use a UDF with vararg and deploy the same in a static VDB.
> Please see the details in the following thread of Teiid Designer User forum discussions:
> https://community.jboss.org/thread/223823?tstart=0
--
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
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1713) Display Flashes and yields stack overflow - after creating a View Table
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1713?page=com.atlassian.jira.plu... ]
Mark Drilling updated TEIIDDES-1713:
------------------------------------
Summary: Display Flashes and yields stack overflow - after creating a View Table (was: Display Focus Issue when created View Table)
> Display Flashes and yields stack overflow - after creating a View Table
> -----------------------------------------------------------------------
>
> Key: TEIIDDES-1713
> URL: https://issues.jboss.org/browse/TEIIDDES-1713
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 8.1
> Reporter: Mark Drilling
> Fix For: 8.2
>
> Attachments: DisplayFocusLoop.log
>
>
> I created a new project, then created a view table via the Create Table dialog.
> When I clicked 'finish', the designer display started flashing. Eventually it stopped with no noticeable side-effect. Looking at the log though, it appears to be some sort of focus issue. Attaching the designer log snippet.
--
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
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1722) Flat File Importer - selection of directory with pdfs causes designer to freeze.
by Mark Drilling (JIRA)
Mark Drilling created TEIIDDES-1722:
---------------------------------------
Summary: Flat File Importer - selection of directory with pdfs causes designer to freeze.
Key: TEIIDDES-1722
URL: https://issues.jboss.org/browse/TEIIDDES-1722
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.1
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 8.2
In the Flat File Import Wizard, if a user selects a directory with mixed file types - this can cause Designer to freeze.
I created a connection profile with a directory containing about 60 files of various types. On the source selection page of the wizard, I selected the profile - then Designer hung.
The problem seems to be in TeiidMetadataFileInfo - the loadHeader method. The assumption is that the files being read are all text files - we need to detect and skip files of incompatible type.
--
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
11 years, 1 month
[JBoss JIRA] (TEIIDDES-1717) Flat File Importer should allow alternate file extensions
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1717?page=com.atlassian.jira.plu... ]
Mark Drilling resolved TEIIDDES-1717.
-------------------------------------
Resolution: Done
- Added file filter box on FlatFile source selection page. This eliminates the hard-coded allowed file extensions and allows user to select other extensions.
- Added radio toggle on wizard SQL page to allow user to select the filter or the specific file.
- corrects several issues with bad wizard behavior going back and forth between pages.
pull request https://github.com/Teiid-Designer/teiid-designer/pull/152
> Flat File Importer should allow alternate file extensions
> ---------------------------------------------------------
>
> Key: TEIIDDES-1717
> URL: https://issues.jboss.org/browse/TEIIDDES-1717
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Affects Versions: 8.1
> Reporter: Mark Drilling
> Assignee: Mark Drilling
> Fix For: 8.2
>
>
> In the Flat File Importer (on the TeiidMetadataImportSourcePage) the user selects a folder, then the 'available' files in the folder are shown for selection.
>
> Currently, files of form .txt, .csv and (no ext) are shown - and this is hard-coded. I would recommend adding a filter drop down (or ?) to show the assumed defaults, but then allow the user to change the filter to "*.*" so that all files are shown.
> We should not force the user to name their data files a certain way. For example if they have .dat files, there is no way to see them currently.
--
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
11 years, 1 month