Log in to follow, share, and participate in this community.
Thread Teiid cancel exception for insert query
Teiid cancel exception for insert queryi'm using Teiid 9 with oracle translator. i'm executing a query insert into select, that writes around 5 million records. After randomly around10-20 minutes and around 2 millions records inserted, Teiid is returning...
Thread Enabling Remote Access to JMX and Profile Service on Teiid Server
Enabling Remote Access to JMX and Profile Service on Teiid ServerI have a Teiid 8.8.1 server and was asked to activate the JMX according to this instruction. I can't manage to transfer the instructions to my Teiid server, since the files are obviously different. Is there a similar ...
Thread Salesforce VDB hangs/fails to return any contents
Salesforce VDB hangs/fails to return any contentsHi, Over the past few days I've been trying unsuccessfully to get the Salesforce adapter to work correctly with my VDB. My dynamic VDB is pretty straightforward, and is attached to this ticket (SFDCVdb-vdb.xml...
Odata support with TEIID issueHi, I am accessing the teiid with odata support http://localhost:8080/odata/webservice/Customers.CustomersView where webservice is a vdb, Customers is model name and CustomersView is my view n...
Thread problem on oData query with FK on the same table
problem on oData query with FK on the same tableHi, we're facing some problems with Teiid 9.1.4 on a particular oData query We have a virtual table like this: EmployeesEntity: EmployeeID (int) FirstName (varchar(50)) LastName (varchar(50)) Dele...
Oracle Connector: LISTAGG functionConsider the following SQL directly against Oracle: SELECT LISTAGG(last_name, '; ')
WITHIN GROUP (ORDER BY hire_date, last_name) "Emp_list",
MIN(hire_date) "Earliest"
FROM employees
WHERE d...
Teiid error on Oracle Trunc functionTeiid reported the following exception: Got exception [TEIID40095 TEIID31080 gosales_vdb3.Inventory_query_Time validation error: TEIID30068 The function 'TRUNC((TIME_DIMENSION.MONTH_KEY / 100), 0)' is an unknown form....
Thread Oracle: wrong query generated for oracle 12c
Oracle: wrong query generated for oracle 12cHi, I recently upgraded from Teiid 8.12.3 to version 9.1.1. And I found query transformation problem for oracle 12c. I have a simple query. See below: select "STORE_CITY" from "jas...
HDFS as a source from TeiidWe have a file stored in HDFS Hadoop cluster on some box, Is there any way in teiid to take this file as a source to create view model. We have successfully accessed Hadoop objects using hive but will it be sam...
how to make POST request via invokeHttp()Hi All, could anyone please help to provide simple example of sending post request with BODY to http service, which is running on tomcat server, using invokeHttp()? I am able to make GET request, it wo...
Thread Aggregation over big table consuming memory
Aggregation over big table consuming memoryI'm using Teiid 9.0.0 with MSSQL translator I have a table containing around 8 million records. I'm running a query with sum aggregation and grouped by 5 fields. While executing the query, Teiid is consuming almost...
odata4 multiple foreign keys issueHi, after installing version 9.1.3 with the fix of TEIID-4298 the reverse navigation seems to work fine. We've facing another problem in the oData navigation in case of two foreign keys between two tables: E...
objecttable queriesI have written a query leveraging the objectable function: SELECT x.* FROM OBJECTTABLE('teiid_context' COLUMNS LastPingTime string 'teiid_row.session.getLastPingTime', ApplicationName s...