January 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1702) Allow the file translator to abstract selecting a single file

by Steven Hawkins (JIRA)

Allow the file translator to abstract selecting a single file ------------------------------------------------------------- Key: TEIID-1702 URL: https://issues.jboss.org/browse/TEIID-1702 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1 If a single file is desired from the file translator that requires embedding a file name in the vdb. There should be a convenient way to abstract single file selection. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1573) Set Query Timeout on the Server

by RAKESH SAGAR (JIRA)

Set Query Timeout on the Server -------------------------------- Key: TEIID-1573 URL: https://issues.jboss.org/browse/TEIID-1573 Project: Teiid Issue Type: Feature Request Affects Versions: 7.3 Environment: Windows Reporter: RAKESH SAGAR Assignee: Steven Hawkins Hi, We want the configuration of the Query Timeout set on the server side instead of setting it for the Statement Object. Please see this discussion for more information http://community.jboss.org/message/600599#600599 We want the setQueryTimeout to override the default values. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

4
6
0 / 0

[JBoss JIRA] Created: (TEIID-1629) provide maven snapshot jars

by Mark Addleman (JIRA)

provide maven snapshot jars --------------------------- Key: TEIID-1629 URL: https://issues.jboss.org/browse/TEIID-1629 Project: Teiid Issue Type: Feature Request Reporter: Mark Addleman Assignee: Steven Hawkins It would be slightly easier for us if SNAPSHOT jars were available for daily builds. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

4
5
0 / 0

[JBoss JIRA] Created: (TEIID-1371) Translator does not unload correctly

by Ramesh Reddy (JIRA)

Translator does not unload correctly ------------------------------------ Key: TEIID-1371 URL: https://jira.jboss.org/browse/TEIID-1371 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.2 Reporter: Ramesh Reddy Priority: Minor When a Translator is deployed while Server is running, it loads dynamically, however if you replace with a new version, it says it unloaded the old, and loads the new, however it continues to use the old classes from previous version of the Translator. This was confusing, and time consuming for me to develop a Translator and keep re-starting the Server. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

5
4
0 / 0

[JBoss JIRA] Created: (TEIID-1611) Add reauthentication support for ODBC

by Steven Hawkins (JIRA)

Add reauthentication support for ODBC ------------------------------------- Key: TEIID-1611 URL: https://issues.jboss.org/browse/TEIID-1611 Project: Teiid Issue Type: Enhancement Components: ODBC Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1 Reauth support is currently only for jdbc. A statement based mechanism needs to be added to support reauth over odbc. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1676) Decomposed aggregates results can be wrong

by Steven Hawkins (JIRA)

Decomposed aggregates results can be wrong ------------------------------------------ Key: TEIID-1676 URL: https://issues.jboss.org/browse/TEIID-1676 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.4.1, 7.5 Decomposed aggregates results can be wrong when a cardinality dependent aggregate is computed against one side of a join and the other has a grouping pushed - and the staging grouping cols remove meaningful duplicate join results. See TestAggregateProcessing.testJira1621 for an example of this situation. The current expected results are wrong. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-942) Make ad hoc temp tables transactional

by Steven Hawkins (JIRA)

Make ad hoc temp tables transactional ------------------------------------- Key: TEIID-942 URL: https://jira.jboss.org/jira/browse/TEIID-942 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1 Ad hoc temp tables are scoped to the session and should be transactional. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

2
6
0 / 0

[JBoss JIRA] Created: (TEIID-1737) Error: Temporary table does not exist when using WITH clause and SQL Server

by Mark Brocato (JIRA)

Error: Temporary table does not exist when using WITH clause and SQL Server --------------------------------------------------------------------------- Key: TEIID-1737 URL: https://issues.jboss.org/browse/TEIID-1737 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.5 Environment: JBoss AS 5.1, TEIID 7.5, SQL Server 2008 Reporter: Mark Brocato Assignee: Steven Hawkins It appears that the WITH clause is not compatible with SQL Server. The following simple query errors out: with T1 as ( select id from DEMO.dbo.ACCESS_GROUP ) select id from T1 The error message is: Remote org.teiid.api.exception.query.QueryProcessingException: Temporary table "T1" does not exist. With Log4J debugging turned on I was able to do a little digging and it looks like to me that TEIID is sending the correct SQL down into SQL Server, but then gets confused when processing the result. Here is the relevant portion of the log: 12:56:29,910 DEBUG [COMMAND_LOG] START USER COMMAND: startTime=2011-08-31 12:56:29.91 requestID=QsxTHCTkSXXC.0 txID=null sessionID=QsxTHCTkSXXC applicationName=JDBC principal=user@teiid-security vdbName=Qiagram vdbVersion=1 sql=with T1 as ( select id from DEMO.dbo.ACCESS_GROUP ) select id from T1 12:56:29,912 DEBUG [PROCESSOR] Request Thread QsxTHCTkSXXC.0 with state NEW 12:56:29,913 DEBUG [PROCESSOR] QsxTHCTkSXXC.0 No cache directive 12:56:29,913 DEBUG [PROCESSOR] QsxTHCTkSXXC.0 executing with T1 as ( select id from DEMO.dbo.ACCESS_GROUP ) select id from T1 12:56:29,916 DEBUG [PROCESSOR] ProcessTree for QsxTHCTkSXXC.0 AccessNode(1) output=[id] WITH T1 (T1.id) AS (SELECT g_0.id FROM SCRAP.DEMO.dbo.ACCESS_GROUP AS g_0) SELECT g_0.id AS c_0 FROM T1 AS g_0 12:56:29,917 DEBUG [TXN_LOG] before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@1a53c407(QsxTHCTkSXXC) 12:56:29,917 DEBUG [TXN_LOG] after getOrCreateTransactionContext : QsxTHCTkSXXC NONE ID:NONE 12:56:29,917 DEBUG [BUFFER_MGR] Creating FileStore: 53 12:56:29,917 DEBUG [BUFFER_MGR] Creating TupleBuffer: 53 [id] [integer] of type PROCESSOR 12:56:29,918 DEBUG [PROCESSOR] QueryProcessor: closing processor 12:56:29,918 DEBUG [PROCESSOR] Request Thread QsxTHCTkSXXC.0 - error occurred [QueryProcessingException]Temporary table "T1" does not exist. at org.teiid.query.tempdata.TempTableStore.getOrCreateTempTable(TempTableStore.java:240) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:487) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:188) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:176) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:358) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:156) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:153) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:182) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:126) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:352) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:207) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:194) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 12:56:29,923 DEBUG [COMMAND_LOG] ERROR USER COMMAND: endTime=2011-08-31 12:56:29.923 requestID=QsxTHCTkSXXC.0 txID=null sessionID=QsxTHCTkSXXC principal=user@teiid-security vdbName=Qiagram vdbVersion=1 finalRowCount=null 12:56:29,924 WARN [PROCESSOR] Processing exception 'Temporary table "T1" does not exist.' for request QsxTHCTkSXXC.0. Exception type org.teiid.api.exception.query.QueryProcessingException thrown from org.teiid.query.tempdata.TempTableStore.getOrCreateTempTable(TempTableStore.java:240). Enable more detailed logging to see the entire stacktrace. 12:56:29,924 DEBUG [PROCESSOR] Removing tuplesource for the request QsxTHCTkSXXC.0 12:56:29,924 DEBUG [BUFFER_MGR] Removing TupleBuffer: 53 12:56:29,924 DEBUG [PROCESSOR] Sending error to client QsxTHCTkSXXC.0 [QueryProcessingException]Temporary table "T1" does not exist. at org.teiid.query.tempdata.TempTableStore.getOrCreateTempTable(TempTableStore.java:240) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:487) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:188) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:176) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:358) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:156) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:153) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:182) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:126) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:352) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:207) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:194) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

2
6
0 / 0

[JBoss JIRA] Created: (TEIID-1745) Forward only results that exceed the output buffer can hold active plans

by Steven Hawkins (JIRA)

Forward only results that exceed the output buffer can hold active plans ------------------------------------------------------------------------ Key: TEIID-1745 URL: https://issues.jboss.org/browse/TEIID-1745 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.5, 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Blocker Fix For: 7.4.1, 7.6 Not completely reading large forwad only resultsets can consume active plans, which will eventually halt processing. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1758) Native PG Connector implement postgres DEALLOCATE command

by Graeme Gillies (JIRA)

Native PG Connector implement postgres DEALLOCATE command --------------------------------------------------------- Key: TEIID-1758 URL: https://issues.jboss.org/browse/TEIID-1758 Project: Teiid Issue Type: Bug Affects Versions: 7.5 Environment: Teiid 7.5.0.Final using java version "1.6.0_20" OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64) OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode) Running inside of JBoss EAP 5.1.1 on Red Hat Enterprise Linux Server release 5.7 problem occurs with perl-DBD-Pg versions 2.15.1-3.el6 and 2.18.0-2.fc15.i686 (and possibly others) Reporter: Graeme Gillies Assignee: Steven Hawkins Hi, We currently are using the below script to try and connect to our teiid instance and pull out a bunch of data. and we have noticed that the script works fine on Rhel5 (using perl-DBD-Pg-1.49-2.el5_3.1 for example) but does not work on newer OS's like Fedora 15 or Rhel6 (which have perl-DBD-Pg versions 2.15.1-3.el6 and 2.18.0-2.fc15.i686) {code} #!/usr/bin/env perl use strict; use warnings; use DBI; use DBD::Pg; my $dbh = DBI->connect("dbi:Pg:dbname=EngVDBF;host=vdb.engineering.redhat.com;port=35432", 'teiid', 'teiid', {AutoCommit => 0}) || die "Could not connect to database: $DBI::errstr"; my $ret = $dbh->selectall_hashref("SELECT MAX(Id) AS max_id FROM Rt4S.Transactions", 'max_id'); my ($result) = keys %$ret; printf "selectall_hashref max_id = %8d\n", $result; $ret = $dbh->selectrow_hashref("SELECT MAX(Id) AS max_id FROM Rt4S.Transactions"); printf "selectrow_hashref max_id = %8d\n", $ret->{max_id}; print "done!"; $dbh->disconnect(); {code} The output we get when the script fails on newer systems is as follows {noformat} DBD::Pg::db selectall_hashref failed: ERROR: Parsing error: Encountered "DEALLOCATE" at line 1, column 1. Was expecting one of: "alter" ... "call" ... "create" ... "delete" ... "drop" ... "exec" ... "execute" ... "insert" ... "select" ... "table" ... ... DETAIL: org.teiid.jdbc.TeiidSQLException: Parsing error: Encountered "DEALLOCATE" at line 1, column 1. Was expecting one of: "alter" ... "call" ... "create" ... "delete" ... "drop" ... "exec" ... "execute" ... "insert" ... "select" ... "table" ... ... at ./teiid-fail.pl line 12. selectall_hashref max_id = 2568235 DBD::Pg::db selectrow_hashref failed: ERROR: Parsing error: Encountered "DEALLOCATE" at line 1, column 1. Was expecting one of: "alter" ... "call" ... "create" ... "delete" ... "drop" ... "exec" ... "execute" ... "insert" ... "select" ... "table" ... ... DETAIL: org.teiid.jdbc.TeiidSQLException: Parsing error: Encountered "DEALLOCATE" at line 1, column 1. Was expecting one of: "alter" ... "call" ... "create" ... "delete" ... "drop" ... "exec" ... "execute" ... "insert" ... "select" ... "table" ... ... at ./teiid-fail.pl line 16. selectrow_hashref max_id = 2568235 {noformat} The output we get on RHEL5 is {noformat} selectall_hashref max_id = 2568235 selectrow_hashref max_id = 2568235 {noformat} As you can see the query does run and is displayed correctly, but it looks like the Postgres driver sends a DEALLOCATE command to the server http://www.postgresql.org/docs/8.1/static/sql-deallocate.html which teiid doesn't know what it means so throws the error. I tried to look in the DBD-Pg docs to see if I can get it to not call DEALLOCATE, but it looks like that might not be possible. Other languages postgres libraries might call the same command anyway. Is it possible to have the DEALLOCATE statement implemented in teiid (even if it doesn't actually do anything) so that native libraries trying to call it won't throw these errors? Regards, Graeme -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

5
5
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2012