October 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2481) common table (with) push down improvements

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2481?page=com.atlassian.jira.plugin... ] Work on TEIID-2481 stopped by Steven Hawkins. --------------------------------------------- > common table (with) push down improvements > ------------------------------------------ > > Key: TEIID-2481 > URL: https://issues.jboss.org/browse/TEIID-2481 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > The general strategy for with pushdown should better handle: > - a with clause that can be pushed against a source that does not support common table. If a single reference or some other sufficient condition is met then we should just inline the pushdown rather than inhibiting the whole query from pushing down. > - even if a source supports with pushdown, it may be more performant in some circumstances to inline the common table reference (such as only a single reference). This is complicated slightly by subqueries. > - alternatively in some situations even if a with clause can be pushed, it may be better to not perform the pushdown -e.g. two separate pushdown accesses to a common table that is expensive to compute (this may need to be hint driven). -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3174) integer operation within LEFT command

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3174?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3174: --------------------------------------- Can you clarify the intent of issue? The error message is saying that a -1 count is invalid, which means that your locate is not finding a comma. > integer operation within LEFT command > ------------------------------------- > > Key: TEIID-3174 > URL: https://issues.jboss.org/browse/TEIID-3174 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Labels: left, stringfunction > > When executing a command of the following form > LEFT(Description,((LOCATE(',',Description))-1)) > I get an Exception like this: > 14:31:00,038 WARN [org.teiid.PROCESSOR] (Worker3295_QueryProcessorQueue53347) 5tz38FpQ/WJw TEIID30020 Processing exception for request 5tz38FpQ/WJw.50 'TEIID30328 Unable to evaluate LEFT(sometable.Description, (LOCATE(',', sometable.Description) - 1)): TEIID30384 Error while evaluating function left'. Originally ExpressionEvaluationException 'TEIID30396 Left/Right count -1 is invalid. It must be >= 0.' FunctionMethods.java:758. Enable more detailed logging to see the entire stacktrace. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2932) Datastax: fail to access PortfolioDemo (demo schema that provided by Datastax)

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2932?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-2932: ----------------------------------- Assignee: Ramesh Reddy > Datastax: fail to access PortfolioDemo (demo schema that provided by Datastax) > ------------------------------------------------------------------------------- > > Key: TEIID-2932 > URL: https://issues.jboss.org/browse/TEIID-2932 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: Datastax with Teiid 8.7 CR > Reporter: Ivan Chan > Assignee: Ramesh Reddy > > Fail to access PortfolioDemo (demo schema that provided by Datastax) and the the following exception: > java.lang.NullPointerException > at org.teiid.metadata.MetadataFactory.addColumn(MetadataFactory.java:204) > at org.teiid.translator.cassandra.CassandraMetadataProcessor.addColumnsToTable(CassandraMetadataProcessor.java:101) > at org.teiid.translator.cassandra.CassandraMetadataProcessor.addTable(CassandraMetadataProcessor.java:63) > at org.teiid.translator.cassandra.CassandraMetadataProcessor.process(CassandraMetadataProcessor.java:50) > at org.teiid.translator.cassandra.CassandraMetadataProcessor.process(CassandraMetadataProcessor.java:42) > at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:915) > at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73) > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) > at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:685) > at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:161) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:635) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:547) -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1049) Create data source for each VDB deployed automaticaly

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-1049?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-1049: -------------------------------- Fix Version/s: 8.10 (was: 8.9) > Create data source for each VDB deployed automaticaly > ----------------------------------------------------- > > Key: TEIID-1049 > URL: https://issues.jboss.org/browse/TEIID-1049 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 7.0 > Reporter: Ramesh Reddy > Priority: Minor > Fix For: 8.10 > > > When a VDB is deployed, auto create a data source for the deployed VDB using the Teiid's "embedded" data source class. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3173) Change the web service resource-adapter module dependency

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3173?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3173: ------------------------------------ No, you can close it. > Change the web service resource-adapter module dependency > --------------------------------------------------------- > > Key: TEIID-3173 > URL: https://issues.jboss.org/browse/TEIID-3173 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > > Change the web service resource-adapter module to depend upon the cxf module delivered in the base modules. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3173) Change the web service resource-adapter module dependency

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3173?page=com.atlassian.jira.plugin... ] Van Halbert closed TEIID-3173. ------------------------------ Resolution: Rejected > Change the web service resource-adapter module dependency > --------------------------------------------------------- > > Key: TEIID-3173 > URL: https://issues.jboss.org/browse/TEIID-3173 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > > Change the web service resource-adapter module to depend upon the cxf module delivered in the base modules. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3174) integer operation within LEFT command

by Bram Gadeyne (JIRA)

Bram Gadeyne created TEIID-3174: ----------------------------------- Summary: integer operation within LEFT command Key: TEIID-3174 URL: https://issues.jboss.org/browse/TEIID-3174 Project: Teiid Issue Type: Bug Affects Versions: 8.7 Reporter: Bram Gadeyne Assignee: Steven Hawkins When executing a command of the following form LEFT(Description,((LOCATE(',',Description))-1)) I get an Exception like this: 14:31:00,038 WARN [org.teiid.PROCESSOR] (Worker3295_QueryProcessorQueue53347) 5tz38FpQ/WJw TEIID30020 Processing exception for request 5tz38FpQ/WJw.50 'TEIID30328 Unable to evaluate LEFT(sometable.Description, (LOCATE(',', sometable.Description) - 1)): TEIID30384 Error while evaluating function left'. Originally ExpressionEvaluationException 'TEIID30396 Left/Right count -1 is invalid. It must be >= 0.' FunctionMethods.java:758. Enable more detailed logging to see the entire stacktrace. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1049) Create data source for each VDB deployed automaticaly

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1049?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1049: --------------------------------------- Ramesh is this something that we still want to pursue? Or just punt to 8.10? > Create data source for each VDB deployed automaticaly > ----------------------------------------------------- > > Key: TEIID-1049 > URL: https://issues.jboss.org/browse/TEIID-1049 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 7.0 > Reporter: Ramesh Reddy > Priority: Minor > Fix For: 8.9 > > > When a VDB is deployed, auto create a data source for the deployed VDB using the Teiid's "embedded" data source class. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2883) Support ParAccel as a data source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2883?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2883: ---------------------------------- Fix Version/s: 8.10 (was: 8.9) > Support ParAccel as a data source > --------------------------------- > > Key: TEIID-2883 > URL: https://issues.jboss.org/browse/TEIID-2883 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 8.10 > > > Support ParAccel as a data source -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2882) Add support for Presto DB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2882?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2882: ---------------------------------- Fix Version/s: 8.10 (was: 8.9) > Add support for Presto DB > ------------------------- > > Key: TEIID-2882 > URL: https://issues.jboss.org/browse/TEIID-2882 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 8.10 > > > Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. > Presto was designed and written from the ground up for interactive analytics and approaches the speed of commercial data warehouses while scaling to the size of organizations like Facebook. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2014