[JBoss JIRA] (TEIID-2919) BigInteger and BigDecimal datatypes are converted into string in MongoDB translator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2919?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2919.
-----------------------------------
Assignee: Steven Hawkins (was: Ramesh Reddy)
Fix Version/s: 8.8
Resolution: Done
Switched to using Double values for these numeric values.
> BigInteger and BigDecimal datatypes are converted into string in MongoDB translator
> -------------------------------------------------------------------------------------
>
> Key: TEIID-2919
> URL: https://issues.jboss.org/browse/TEIID-2919
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.8
>
>
> Description of problem:
> BigInteger and BigDecimal datatypes are converted into string in MongoDB translator (MongoDBExecutionFactory.java). User can't use these datatypes in the WHERE clause.
> For example
> The query:
>
> SELECT IntKey FROM SmallA where BIGINTEGERVALUE > 1
> returns no results because BIGINTEGERVALUE > 1 is converted into
> { "BIGINTEGERVALUE" : { "$gt" : "1"}}
> but is should be
> { "BIGINTEGERVALUE" : { "$gt" : 1}}
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month
[JBoss JIRA] (TEIID-2949) Issue querying Google Spreadsheet
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-2949?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-2949:
-------------------------------
Priority: Major (was: Blocker)
> Issue querying Google Spreadsheet
> ---------------------------------
>
> Key: TEIID-2949
> URL: https://issues.jboss.org/browse/TEIID-2949
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Issue querying google spreadsheet:
> Steps to Reproduce:
> 1. configure resource adaptor for google in standalone.xml
> <resource-adapter id="google">
> <module slot="main" id="org.jboss.teiid.resource-adapter.google"/>
> <transaction-support>NoTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google" enabled="true" use-java-context="true" pool-name="google">
> <config-property name="AuthMethod">
> ClientLogin
> </config-property>
> <config-property name="SpreadsheetName">
> testsheet
> </config-property>
> <config-property name="BatchSize">
> 4096
> </config-property>
> <config-property name="Username">
> hokuda.test(a)gmail.com
> </config-property>
> <config-property name="Password">
> passpassw
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> 2. deploy dynamic vdb
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="test" version="1">
> <description>Dynamic Google Spreadsheet VDB</description>
> <model name="google">
> <source name="google-spreadsheet" translator-name="google-spreadsheet" connection-jndi-name="java:/google"/>
> </model>
> </vdb>
> 3. you get an exception
> 16:59:34,429 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB test.1 model "google" metadata failed to load. Reas
> on:Error when getting batch 404:Not Found: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error when getti
> ng batch 404:Not Found
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDat
> aProtocolAPI.java:248)
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDat
> aProtocolAPI.java:163)
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI.getMetadata(GoogleDataProtocolAPI.java:109)
> at org.teiid.resource.adapter.google.gdata.SpreadsheetMetadataExtractor.extractMetadata(SpreadsheetMetadataExtractor.java:7
> 4)
> at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.getSpreadsheetInfo(SpreadsheetConnectionImpl.java:147)
> at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:71)
> at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:45)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61) [teiid-engine-8.4.1-red
> hat-7.jar:8.4.1-redhat-7]
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.4.1
> -redhat-7.jar:8.4.1-redhat-7]
> at org.teiid.jboss.VDBService$6.run(VDBService.java:397) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
> at org.teiid.jboss.VDBService$7.run(VDBService.java:444) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
> at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
> at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806)
> at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
> at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826)
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> Here's a reference to the google issue that's causing our issue:
> https://code.google.com/p/google-visualization-api-issues/issues/detail?i...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month
[JBoss JIRA] (TEIID-2949) Issue querying Google Spreadsheet
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2949?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2949:
---------------------------------------
Since this is a third-party library issue (in a little used source) and no workaround provided, this cannot be a blocker for us.
> Issue querying Google Spreadsheet
> ---------------------------------
>
> Key: TEIID-2949
> URL: https://issues.jboss.org/browse/TEIID-2949
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Blocker
>
> Issue querying google spreadsheet:
> Steps to Reproduce:
> 1. configure resource adaptor for google in standalone.xml
> <resource-adapter id="google">
> <module slot="main" id="org.jboss.teiid.resource-adapter.google"/>
> <transaction-support>NoTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google" enabled="true" use-java-context="true" pool-name="google">
> <config-property name="AuthMethod">
> ClientLogin
> </config-property>
> <config-property name="SpreadsheetName">
> testsheet
> </config-property>
> <config-property name="BatchSize">
> 4096
> </config-property>
> <config-property name="Username">
> hokuda.test(a)gmail.com
> </config-property>
> <config-property name="Password">
> passpassw
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> 2. deploy dynamic vdb
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="test" version="1">
> <description>Dynamic Google Spreadsheet VDB</description>
> <model name="google">
> <source name="google-spreadsheet" translator-name="google-spreadsheet" connection-jndi-name="java:/google"/>
> </model>
> </vdb>
> 3. you get an exception
> 16:59:34,429 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB test.1 model "google" metadata failed to load. Reas
> on:Error when getting batch 404:Not Found: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error when getti
> ng batch 404:Not Found
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDat
> aProtocolAPI.java:248)
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDat
> aProtocolAPI.java:163)
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI.getMetadata(GoogleDataProtocolAPI.java:109)
> at org.teiid.resource.adapter.google.gdata.SpreadsheetMetadataExtractor.extractMetadata(SpreadsheetMetadataExtractor.java:7
> 4)
> at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.getSpreadsheetInfo(SpreadsheetConnectionImpl.java:147)
> at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:71)
> at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:45)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61) [teiid-engine-8.4.1-red
> hat-7.jar:8.4.1-redhat-7]
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.4.1
> -redhat-7.jar:8.4.1-redhat-7]
> at org.teiid.jboss.VDBService$6.run(VDBService.java:397) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
> at org.teiid.jboss.VDBService$7.run(VDBService.java:444) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
> at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
> at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806)
> at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
> at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826)
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> Here's a reference to the google issue that's causing our issue:
> https://code.google.com/p/google-visualization-api-issues/issues/detail?i...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month
[JBoss JIRA] (TEIID-2949) Issues querying Google Spreadsheet
by Van Halbert (JIRA)
Van Halbert created TEIID-2949:
----------------------------------
Summary: Issues querying Google Spreadsheet
Key: TEIID-2949
URL: https://issues.jboss.org/browse/TEIID-2949
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Blocker
Issue querying google spreadsheet:
Steps to Reproduce:
1. configure resource adaptor for google in standalone.xml
<resource-adapter id="google">
<module slot="main" id="org.jboss.teiid.resource-adapter.google"/>
<transaction-support>NoTransaction</transaction-support>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google" enabled="true" use-java-context="true" pool-name="google">
<config-property name="AuthMethod">
ClientLogin
</config-property>
<config-property name="SpreadsheetName">
testsheet
</config-property>
<config-property name="BatchSize">
4096
</config-property>
<config-property name="Username">
hokuda.test(a)gmail.com
</config-property>
<config-property name="Password">
passpassw
</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
2. deploy dynamic vdb
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="test" version="1">
<description>Dynamic Google Spreadsheet VDB</description>
<model name="google">
<source name="google-spreadsheet" translator-name="google-spreadsheet" connection-jndi-name="java:/google"/>
</model>
</vdb>
3. you get an exception
16:59:34,429 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB test.1 model "google" metadata failed to load. Reas
on:Error when getting batch 404:Not Found: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error when getti
ng batch 404:Not Found
at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDat
aProtocolAPI.java:248)
at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDat
aProtocolAPI.java:163)
at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI.getMetadata(GoogleDataProtocolAPI.java:109)
at org.teiid.resource.adapter.google.gdata.SpreadsheetMetadataExtractor.extractMetadata(SpreadsheetMetadataExtractor.java:7
4)
at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.getSpreadsheetInfo(SpreadsheetConnectionImpl.java:147)
at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:71)
at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:45)
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61) [teiid-engine-8.4.1-red
hat-7.jar:8.4.1-redhat-7]
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.4.1
-redhat-7.jar:8.4.1-redhat-7]
at org.teiid.jboss.VDBService$6.run(VDBService.java:397) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
at org.teiid.jboss.VDBService$7.run(VDBService.java:444) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806)
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826)
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Here's a reference to the google issue that's causing our issue:
https://code.google.com/p/google-visualization-api-issues/issues/detail?i...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month
[JBoss JIRA] (TEIID-2949) Issues querying Google Spreadsheet
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2949?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-2949:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1095159
> Issues querying Google Spreadsheet
> ----------------------------------
>
> Key: TEIID-2949
> URL: https://issues.jboss.org/browse/TEIID-2949
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Blocker
>
> Issue querying google spreadsheet:
> Steps to Reproduce:
> 1. configure resource adaptor for google in standalone.xml
> <resource-adapter id="google">
> <module slot="main" id="org.jboss.teiid.resource-adapter.google"/>
> <transaction-support>NoTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google" enabled="true" use-java-context="true" pool-name="google">
> <config-property name="AuthMethod">
> ClientLogin
> </config-property>
> <config-property name="SpreadsheetName">
> testsheet
> </config-property>
> <config-property name="BatchSize">
> 4096
> </config-property>
> <config-property name="Username">
> hokuda.test(a)gmail.com
> </config-property>
> <config-property name="Password">
> passpassw
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> 2. deploy dynamic vdb
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="test" version="1">
> <description>Dynamic Google Spreadsheet VDB</description>
> <model name="google">
> <source name="google-spreadsheet" translator-name="google-spreadsheet" connection-jndi-name="java:/google"/>
> </model>
> </vdb>
> 3. you get an exception
> 16:59:34,429 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB test.1 model "google" metadata failed to load. Reas
> on:Error when getting batch 404:Not Found: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error when getti
> ng batch 404:Not Found
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDat
> aProtocolAPI.java:248)
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDat
> aProtocolAPI.java:163)
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI.getMetadata(GoogleDataProtocolAPI.java:109)
> at org.teiid.resource.adapter.google.gdata.SpreadsheetMetadataExtractor.extractMetadata(SpreadsheetMetadataExtractor.java:7
> 4)
> at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.getSpreadsheetInfo(SpreadsheetConnectionImpl.java:147)
> at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:71)
> at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:45)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61) [teiid-engine-8.4.1-red
> hat-7.jar:8.4.1-redhat-7]
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.4.1
> -redhat-7.jar:8.4.1-redhat-7]
> at org.teiid.jboss.VDBService$6.run(VDBService.java:397) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
> at org.teiid.jboss.VDBService$7.run(VDBService.java:444) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
> at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
> at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806)
> at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
> at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826)
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> Here's a reference to the google issue that's causing our issue:
> https://code.google.com/p/google-visualization-api-issues/issues/detail?i...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month
[JBoss JIRA] (TEIID-2949) Issue querying Google Spreadsheet
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-2949?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-2949:
-------------------------------
Summary: Issue querying Google Spreadsheet (was: Issues querying Google Spreadsheet)
> Issue querying Google Spreadsheet
> ---------------------------------
>
> Key: TEIID-2949
> URL: https://issues.jboss.org/browse/TEIID-2949
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Blocker
>
> Issue querying google spreadsheet:
> Steps to Reproduce:
> 1. configure resource adaptor for google in standalone.xml
> <resource-adapter id="google">
> <module slot="main" id="org.jboss.teiid.resource-adapter.google"/>
> <transaction-support>NoTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google" enabled="true" use-java-context="true" pool-name="google">
> <config-property name="AuthMethod">
> ClientLogin
> </config-property>
> <config-property name="SpreadsheetName">
> testsheet
> </config-property>
> <config-property name="BatchSize">
> 4096
> </config-property>
> <config-property name="Username">
> hokuda.test(a)gmail.com
> </config-property>
> <config-property name="Password">
> passpassw
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> 2. deploy dynamic vdb
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="test" version="1">
> <description>Dynamic Google Spreadsheet VDB</description>
> <model name="google">
> <source name="google-spreadsheet" translator-name="google-spreadsheet" connection-jndi-name="java:/google"/>
> </model>
> </vdb>
> 3. you get an exception
> 16:59:34,429 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB test.1 model "google" metadata failed to load. Reas
> on:Error when getting batch 404:Not Found: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error when getti
> ng batch 404:Not Found
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDat
> aProtocolAPI.java:248)
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDat
> aProtocolAPI.java:163)
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI.getMetadata(GoogleDataProtocolAPI.java:109)
> at org.teiid.resource.adapter.google.gdata.SpreadsheetMetadataExtractor.extractMetadata(SpreadsheetMetadataExtractor.java:7
> 4)
> at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.getSpreadsheetInfo(SpreadsheetConnectionImpl.java:147)
> at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:71)
> at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:45)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61) [teiid-engine-8.4.1-red
> hat-7.jar:8.4.1-redhat-7]
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.4.1
> -redhat-7.jar:8.4.1-redhat-7]
> at org.teiid.jboss.VDBService$6.run(VDBService.java:397) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
> at org.teiid.jboss.VDBService$7.run(VDBService.java:444) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7]
> at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
> at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806)
> at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
> at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826)
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> Here's a reference to the google issue that's causing our issue:
> https://code.google.com/p/google-visualization-api-issues/issues/detail?i...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month
[JBoss JIRA] (TEIID-2902) More incremental join when a limit is present
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2902?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2902.
-----------------------------------
Resolution: Done
In most circumstances where a sort is not pushed we'll elect to do an EnhancedSortMerge join. This change removes several places that forced us to fully read both sides. It also in the presence of a limit ensure that a more incremental join is performed (one side fully sorted, the other will only be sorted to a single pass - but will typically have been fully read).
> More incremental join when a limit is present
> ---------------------------------------------
>
> Key: TEIID-2902
> URL: https://issues.jboss.org/browse/TEIID-2902
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 8.7
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
> Fix For: 8.8
>
>
> For SQL like:
> SELECT
> t1.column1,
> t2.column1
> FROM
> schema1.table1 t1,
> schema2.table1 t2
> WHERE
> t1.column2=t2.column2
> LIMIT 100
> Teiid may get the whole schema1.table1 content and the whole schema2.table1 content, do the join in memory and then, limit the resultset to 100 records.
> However, I think teiid can fetch smaller set of data then do a join. If the join result set is less than number of rows asking, keep fetching next set of data and do a join until hits the limit number.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month
[JBoss JIRA] (TEIID-2919) BigInteger and BigDecimal datatypes are converted into string in MongoDB translator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2919?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2919:
---------------------------------------
It looks like values of those types should be converted to Double, rather than string (at the risk of some precision loss). As Ramesh is getting at though, it is somewhat of a usage error to choose a type that not natively supported.
> BigInteger and BigDecimal datatypes are converted into string in MongoDB translator
> -------------------------------------------------------------------------------------
>
> Key: TEIID-2919
> URL: https://issues.jboss.org/browse/TEIID-2919
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4
> Reporter: Filip Elias
> Assignee: Ramesh Reddy
> Fix For: 8.7.1
>
>
> Description of problem:
> BigInteger and BigDecimal datatypes are converted into string in MongoDB translator (MongoDBExecutionFactory.java). User can't use these datatypes in the WHERE clause.
> For example
> The query:
>
> SELECT IntKey FROM SmallA where BIGINTEGERVALUE > 1
> returns no results because BIGINTEGERVALUE > 1 is converted into
> { "BIGINTEGERVALUE" : { "$gt" : "1"}}
> but is should be
> { "BIGINTEGERVALUE" : { "$gt" : 1}}
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month
[JBoss JIRA] (TEIID-994) Unable to execute Oracle pipelined table function as procedure
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-994?page=com.atlassian.jira.plugin.... ]
Steven Hawkins resolved TEIID-994.
----------------------------------
Fix Version/s: (was: Open To Community)
(was: 8.7.1)
Resolution: Done
Marking as resolved given several workarounds that are applicable outlined in this issue. If a new scenario arises, this can be reopened or a new issue logged.
> Unable to execute Oracle pipelined table function as procedure
> --------------------------------------------------------------
>
> Key: TEIID-994
> URL: https://issues.jboss.org/browse/TEIID-994
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
>
> Oracle pipelined table functions (can be used in Oracle queries as TABLE(...)) that can be put in the FROM clause and used as if they were tables although they are really procedures. We found that we imported this table function, although didn't get it quite right - the result set was wrong, which may just be a deficiency of the JDBC import metadata. We were able to map the proc to a table and execute but when we did we got a PL/SQL error from the db.
> Because this is a proc, we are executing it as a CallableStatement down in the JDBC connector which apparently does not work with DataDirect. I'm not sure how we can detect and do something different but seems like we need to have some metadata (procedure name in source?) that can tell us that this proc needs to be run differently and have the Oracle JDBC Connector deal with this properly.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 1 month