[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3959?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3959.
-----------------------------------
Resolution: Rejected
The lib property should be a child of the vdb, not the model: https://docs.jboss.org/author/display/TEIID/VDB+Definition
> So is there any way of hot config this information ? so that We don't need to restart the TEIID server .
You shouldn't need a config change for UDFs. You can also use a .vdb zip deployment …
[View More]and include the dependency directly in a lib folder in the vdb if you don't want to use a full module.
> dynamic VDB, Not loading UDF , Showing class Not Found .
> -----------------------------------------------------------
>
> Key: TEIID-3959
> URL: https://issues.jboss.org/browse/TEIID-3959
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12.2
> Environment: Windows 7, 64 bit
> Reporter: Durgadatta Sahu
> Assignee: Steven Hawkins
>
> Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR at run time .
> It is showing following exception:-
> 10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
> ===============================
> I have crated a dynamic VDB and define UDF details as follows
> <?xml version="1.0" encoding="utf-8"?>
> <vdb name="DDS_TEST_VDB" version="1">
> <model name="modelsource" type='VIRTUAL' >
> <property name ="lib" value ="com.my.app"></property>
> <metadata type="DDL">
> <![CDATA[
> create virtual function getDouble(key Long) returns Double
> options (
> java_class 'com.my.app.Demo',
> java_method 'getValue'
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> And I have deployed my jar file and module.xml in following path,
> \teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
> module.xml :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <module xmlns="urn:jboss:module:1.1" name="com.my.app">
>
> <resources>
> <resource-root path="myapp.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> </dependencies>
> </module>
> Thanks,
> Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 2 months
[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Durgadatta Sahu (JIRA)
[ https://issues.jboss.org/browse/TEIID-3959?page=com.atlassian.jira.plugin... ]
Durgadatta Sahu edited comment on TEIID-3959 at 2/8/16 4:28 AM:
----------------------------------------------------------------
Hi,
After adding the following module information in standalone-teiid.xml file, the above problem got resolved.
<subsystem xmlns="urn:jboss:domain:ee:1.2">
<global-modules>
<module name="com.my.app" slot="1.0"/>
</global-…
[View More]modules>
<spec-descriptor-property-replacement>false</spec-descriptor-property-replacement>
<jboss-descriptor-property-replacement>true</jboss-descriptor-property-replacement>
<annotation-property-replacement>false</annotation-property-replacement>
</subsystem>
But in this case I have to restart the teiid server ,
So is there any way of hot config this information ? so that We don't need to restart the TEIID server .
I mean to say, suppose at run time we update the module version or add any new module info in standalone-teiid.xml ,then it will pick update info and no need to restart the TEIID server??
or Is there any other way to achieve this using dynamic vdb ?
Thanks,
Durga
was (Author: durgadatta):
Hi,
After adding the module information in standalone-teiid.xml file, the above problem got resolved
<subsystem xmlns="urn:jboss:domain:ee:1.2">
<global-modules>
<module name="com.my.app" slot="1.0"/>
</global-modules>
<spec-descriptor-property-replacement>false</spec-descriptor-property-replacement>
<jboss-descriptor-property-replacement>true</jboss-descriptor-property-replacement>
<annotation-property-replacement>false</annotation-property-replacement>
</subsystem>
But in this case I have to restart the teiid server ,
So is there any way of hot config this information ? so that We don't need to restart the TEIID server .
I mean to say, suppose at run time we update the module version or add any new module info in standalone-teiid.xml ,then it will pick update info and no need to restart the TEIID server??
or Is there any other way to achieve this using dynamic vdb ?
Thanks,
Durga
> dynamic VDB, Not loading UDF , Showing class Not Found .
> -----------------------------------------------------------
>
> Key: TEIID-3959
> URL: https://issues.jboss.org/browse/TEIID-3959
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12.2
> Environment: Windows 7, 64 bit
> Reporter: Durgadatta Sahu
> Assignee: Steven Hawkins
>
> Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR at run time .
> It is showing following exception:-
> 10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
> ===============================
> I have crated a dynamic VDB and define UDF details as follows
> <?xml version="1.0" encoding="utf-8"?>
> <vdb name="DDS_TEST_VDB" version="1">
> <model name="modelsource" type='VIRTUAL' >
> <property name ="lib" value ="com.my.app"></property>
> <metadata type="DDL">
> <![CDATA[
> create virtual function getDouble(key Long) returns Double
> options (
> java_class 'com.my.app.Demo',
> java_method 'getValue'
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> And I have deployed my jar file and module.xml in following path,
> \teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
> module.xml :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <module xmlns="urn:jboss:module:1.1" name="com.my.app">
>
> <resources>
> <resource-root path="myapp.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> </dependencies>
> </module>
> Thanks,
> Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 2 months
[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Durgadatta Sahu (JIRA)
[ https://issues.jboss.org/browse/TEIID-3959?page=com.atlassian.jira.plugin... ]
Durgadatta Sahu commented on TEIID-3959:
----------------------------------------
Hi,
After adding the module information in standalone-teiid.xml file, the above problem got resolved
<subsystem xmlns="urn:jboss:domain:ee:1.2">
<global-modules>
<module name="com.my.app" slot="1.0"/>
</global-modules>
<spec-descriptor-property-…
[View More]replacement>false</spec-descriptor-property-replacement>
<jboss-descriptor-property-replacement>true</jboss-descriptor-property-replacement>
<annotation-property-replacement>false</annotation-property-replacement>
</subsystem>
But in this case I have to restart the teiid server ,
So is there any way of hot config this information ? so that We don't need to restart the TEIID server .
I mean to say, suppose at run time we update the module version or add any new module info in standalone-teiid.xml ,then it will pick update info and no need to restart the TEIID server??
or Is there any other way to achieve this using dynamic vdb ?
Thanks,
Durga
> dynamic VDB, Not loading UDF , Showing class Not Found .
> -----------------------------------------------------------
>
> Key: TEIID-3959
> URL: https://issues.jboss.org/browse/TEIID-3959
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.12.2
> Environment: Windows 7, 64 bit
> Reporter: Durgadatta Sahu
> Assignee: Steven Hawkins
>
> Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR at run time .
> It is showing following exception:-
> 10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
> ===============================
> I have crated a dynamic VDB and define UDF details as follows
> <?xml version="1.0" encoding="utf-8"?>
> <vdb name="DDS_TEST_VDB" version="1">
> <model name="modelsource" type='VIRTUAL' >
> <property name ="lib" value ="com.my.app"></property>
> <metadata type="DDL">
> <![CDATA[
> create virtual function getDouble(key Long) returns Double
> options (
> java_class 'com.my.app.Demo',
> java_method 'getValue'
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> And I have deployed my jar file and module.xml in following path,
> \teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
> module.xml :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <module xmlns="urn:jboss:module:1.1" name="com.my.app">
>
> <resources>
> <resource-root path="myapp.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> </dependencies>
> </module>
> Thanks,
> Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 2 months
[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Durgadatta Sahu (JIRA)
[ https://issues.jboss.org/browse/TEIID-3959?page=com.atlassian.jira.plugin... ]
Durgadatta Sahu updated TEIID-3959:
-----------------------------------
Environment: Windows 7, 64 bit
> dynamic VDB, Not loading UDF , Showing class Not Found .
> -----------------------------------------------------------
>
> Key: TEIID-3959
> URL: https://issues.jboss.org/browse/TEIID-3959
> Project: Teiid
> Issue Type: Feature …
[View More]Request
> Affects Versions: 8.12.2
> Environment: Windows 7, 64 bit
> Reporter: Durgadatta Sahu
> Assignee: Steven Hawkins
>
> Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR at run time .
> It is showing following exception:-
> 10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
> 10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
> 10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
> ===============================
> I have crated a dynamic VDB and define UDF details as follows
> <?xml version="1.0" encoding="utf-8"?>
> <vdb name="DDS_TEST_VDB" version="1">
> <model name="modelsource" type='VIRTUAL' >
> <property name ="lib" value ="com.my.app"></property>
> <metadata type="DDL">
> <![CDATA[
> create virtual function getDouble(key Long) returns Double
> options (
> java_class 'com.my.app.Demo',
> java_method 'getValue'
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> And I have deployed my jar file and module.xml in following path,
> \teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
> module.xml :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <module xmlns="urn:jboss:module:1.1" name="com.my.app">
>
> <resources>
> <resource-root path="myapp.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> </dependencies>
> </module>
> Thanks,
> Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 2 months
[JBoss JIRA] (TEIID-3959) dynamic VDB, Not loading UDF , Showing class Not Found .
by Durgadatta Sahu (JIRA)
Durgadatta Sahu created TEIID-3959:
--------------------------------------
Summary: dynamic VDB, Not loading UDF , Showing class Not Found .
Key: TEIID-3959
URL: https://issues.jboss.org/browse/TEIID-3959
Project: Teiid
Issue Type: Feature Request
Affects Versions: 8.12.2
Reporter: Durgadatta Sahu
Assignee: Steven Hawkins
Hi I am new to TEIID , and trying to deploy UDF and corresponding JAR …
[View More]at run time .
It is showing following exception:-
10:46:47,729 INFO [org.teiid.RUNTIME] (teiid-async-threads - 6) TEIID50030 VDB DDS_TEST_VDB.1 model "modelsource" metadata loaded. End Time: 2/6/16 10:46 AM
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Exception in thread "teiid-async-threads - 6" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "getDouble", since its invocation class "com.my.app.Demo" could not be found.
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:325)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:212)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:102)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:93)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:286)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:297)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService.access$1200(VDBService.java:81)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$6.run(VDBService.java:416)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Thread.run(Thread.java:745)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) Caused by: java.lang.ClassNotFoundException: com.my.app.Demo from [Module "deployment.udfa-vdb.xml:main" from Service Module Loader]
10:46:47,729 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName0(Native Method)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at java.lang.Class.forName(Class.java:340)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:315)
10:46:47,739 ERROR [stderr] (teiid-async-threads - 6) ... 13 more
===============================
I have crated a dynamic VDB and define UDF details as follows
<?xml version="1.0" encoding="utf-8"?>
<vdb name="DDS_TEST_VDB" version="1">
<model name="modelsource" type='VIRTUAL' >
<property name ="lib" value ="com.my.app"></property>
<metadata type="DDL">
<![CDATA[
create virtual function getDouble(key Long) returns Double
options (
java_class 'com.my.app.Demo',
java_method 'getValue'
);
]]>
</metadata>
</model>
</vdb>
And I have deployed my jar file and module.xml in following path,
\teiid-8.12.2-server\teiid-8.12.2\modules\com\my\app\main\
module.xml :
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.1" name="com.my.app">
<resources>
<resource-root path="myapp.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
</dependencies>
</module>
Thanks,
Durga
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 2 months
[JBoss JIRA] (TEIID-3958) NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
by Marc Shirley (JIRA)
[ https://issues.jboss.org/browse/TEIID-3958?page=com.atlassian.jira.plugin... ]
Marc Shirley updated TEIID-3958:
--------------------------------
Description:
Appears to still be an issue similar to TEIID 2537. Executing against the invokeHttp() procedure generated by JBDS 5 for Teiid Designer 7.7.3 without a stream parameter results in a slightly different stack trace, but appears to be the same issue.
2016-01-21 12:53:50,297 ERROR \[org.teiid.PROCESSOR\] (…
[View More]Worker22_QueryProcessorQueue117472) TEIID30019 Unexpected exception for request FzkQneotrSUs.5: java.lang.NullPointerException
at org.teiid.translator.ws.BinaryWSProcedureExecution.getOutputParameterValues(BinaryWSProcedureExecution.java:174)
at org.teiid.dqp.internal.datamgr.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:86) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:207) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
was:
Using Designer 8.1/Teiid 8.3 and executing against the following:
http://gw.esworkplace.sap.com/sap/opu/sdata/iwcnt/contact/ContactCollecti...
gives me the following NPE:
13:00:28,345 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue25) YH9sbL1HZbxJ TEIID30019 Unexpected exception for request YH9sbL1HZbxJ.6: java.lang.NullPointerException
at org.teiid.translator.ws.BinaryWSProcedureExecution.getOutputParameterValues(BinaryWSProcedureExecution.java:178)
at org.teiid.dqp.internal.datamgr.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:86) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:356) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:141) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:467) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:178) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:175) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [classes.jar:1.6.0_45]
at java.util.concurrent.FutureTask.run(FutureTask.java:138) [classes.jar:1.6.0_45]
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:120) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [classes.jar:1.6.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [classes.jar:1.6.0_45]
at java.lang.Thread.run(Thread.java:680) [classes.jar:1.6.0_45]
Fix Version/s: (was: 8.4)
(was: 8.4.1)
Summary: NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter (was: NPE Executing Against Web Service Source using invokeHTTP function without stream parameter)
Labels: (was: 8.4.Final)
Environment:
Migrated web services model from EDS 5.3.1 that does not include 'stream' parameter in the invokeHttp() procedure
DV 6.1 - translator-ws-8.7.1.redhat-8.jar
DV 6.2 - translator-ws-8.7.1.6_2-redhat-6.jar
Affects Version/s: 8.7.1.6_2
8.7.1
(was: 8.1)
> NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
> ----------------------------------------------------------------------------------------------
>
> Key: TEIID-3958
> URL: https://issues.jboss.org/browse/TEIID-3958
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1, 8.7.1.6_2
> Environment: Migrated web services model from EDS 5.3.1 that does not include 'stream' parameter in the invokeHttp() procedure
> DV 6.1 - translator-ws-8.7.1.redhat-8.jar
> DV 6.2 - translator-ws-8.7.1.6_2-redhat-6.jar
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
>
> Appears to still be an issue similar to TEIID 2537. Executing against the invokeHttp() procedure generated by JBDS 5 for Teiid Designer 7.7.3 without a stream parameter results in a slightly different stack trace, but appears to be the same issue.
> 2016-01-21 12:53:50,297 ERROR \[org.teiid.PROCESSOR\] (Worker22_QueryProcessorQueue117472) TEIID30019 Unexpected exception for request FzkQneotrSUs.5: java.lang.NullPointerException
> at org.teiid.translator.ws.BinaryWSProcedureExecution.getOutputParameterValues(BinaryWSProcedureExecution.java:174)
> at org.teiid.dqp.internal.datamgr.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:86) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:207) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 2 months
[JBoss JIRA] (TEIID-3958) NPE Executing Against Web Service Source using invokeHTTP function without stream parameter
by Marc Shirley (JIRA)
Marc Shirley created TEIID-3958:
-----------------------------------
Summary: NPE Executing Against Web Service Source using invokeHTTP function without stream parameter
Key: TEIID-3958
URL: https://issues.jboss.org/browse/TEIID-3958
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.1
Reporter: Marc Shirley
Assignee: Steven Hawkins
Fix For: 8.4, …
[View More]8.4.1
Using Designer 8.1/Teiid 8.3 and executing against the following:
http://gw.esworkplace.sap.com/sap/opu/sdata/iwcnt/contact/ContactCollecti...
gives me the following NPE:
13:00:28,345 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue25) YH9sbL1HZbxJ TEIID30019 Unexpected exception for request YH9sbL1HZbxJ.6: java.lang.NullPointerException
at org.teiid.translator.ws.BinaryWSProcedureExecution.getOutputParameterValues(BinaryWSProcedureExecution.java:178)
at org.teiid.dqp.internal.datamgr.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:86) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:356) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:141) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:467) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:178) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:175) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [classes.jar:1.6.0_45]
at java.util.concurrent.FutureTask.run(FutureTask.java:138) [classes.jar:1.6.0_45]
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:120) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [classes.jar:1.6.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [classes.jar:1.6.0_45]
at java.lang.Thread.run(Thread.java:680) [classes.jar:1.6.0_45]
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 2 months
[JBoss JIRA] (TEIID-3957) Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3957?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3957:
----------------------------------
Issue Type: Enhancement (was: Bug)
Fix Version/s: 9.0
> BUT this means give me 25 rows starting from *PAGE * 76 (with page size of 25 rows)
I don't see that meaning in the docs. It appears to just be a standard offset after which a limit is applied.
> The Teiid Impala translator doesn't push the offset but sums the limit …
[View More]and offset
Yes, that is the standard compensation when the translator is not marked as supporting offset. I believe that this was initially the case because we were targeting early releases of impala. It will be straight-forward to add support.
> Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-3957
> URL: https://issues.jboss.org/browse/TEIID-3957
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Affects Versions: 8.12.4
> Environment: Ubuntu Trusty
> Reporter: Don Krapohl
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 9.0
>
>
> With the impala translator we issue this LIMIT to Teiid:
> ORDER BY somecolumn DESC LIMIT 75, 25
> this means give me 25 rows starting from *ROW* 76.
> In Impala's SQL this should be translated to:
> ORDER BY somecolumn DESC LIMIT 25 OFFSET 75
> BUT this means give me 25 rows starting from *PAGE * 76 (with page size of 25 rows)
> ref: http://www.cloudera.com/documentation/archive/impala/2-x/2-1-x/topics/imp...
> The Teiid Impala translator doesn't push the offset but sums the limit and offset:
> ORDER BY somecolumn DESC LIMIT 100
> Request we add pushdown, which will be more efficient and overcome the difference in how offsets are handled between Impala and Teiid.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
[View Less]
9 years, 2 months