Teiid cancel exception for insert query i'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... 
Enabling Remote Access to JMX and Profile Service on Teiid Server I 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 ... 
Salesforce VDB hangs/fails to return any contents Hi, 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 issue Hi, 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... 
problem on oData query with FK on the same table Hi, 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... 
It seems to take longer to build ddl for oracle data source in version 9.1.1 comparing to version 8.12.3 It seems to take longer for Teiid version 9.1.1 to build ddl for oracle data source comparing to version 8.12.3 when using progress oracle driver. Is there new extra machinery added for building ddl for oracle d... 
Oracle Connector: LISTAGG function Consider 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... 
Getting error when doing inner join between integer and varchar columns I used to be able to do inner join between integer and vachar columns without using CAST function in Teiid 8.12.3. But it doesn't work in Teiid 9.1.1 anymore. And I got the following error: Caused ... Teiid error on Oracle Trunc function Teiid 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.... Oracle: wrong query generated for oracle 12c Hi, 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 Teiid We 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... 
Prevent queries directly against a Model which is marked 'visible=false' Consider the following model definition: <model name="GoSalesModel" type="PHYSICAL" visible="false"> <property name="importer.useFullSchemaName" value="false"/> <property name="impo... VoltDB translator Is there a teiid translator for VoltDB? 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... 
Aggregation over big table consuming memory I'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 issue Hi, 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 queries I have written a query leveraging the objectable function: SELECT x.* FROM OBJECTTABLE('teiid_context' COLUMNS LastPingTime string 'teiid_row.session.getLastPingTime', ApplicationName s... 
java.lang.IllegalArgumentException: type cannot be null in translator-odata Hi , I am using teiid odata and ws libraries to for making a SAP Odata connector. I am able to create a connection and get all the properties for a SAP entity. But while trying to fetch the records I get the followin... 
Teiid Query Exception: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null Teiid Query needs to rewrite tween Teiid version 8.2 and 8.12.3. A customer's virtual datasource had a query containing a join statement which involved MS Sql Server tables and Oracle tables. Things were fine til they... Teiid Embedded: Can I use XmlTable/XMLParse and TextTable functionality in my implementation of ResultSetExecution? Consider the following model definitions: Virtual View <model name="Test" type="VIRTUAL" visible="true"> <metadata type="DDL"> <
Log in to follow, share, and participate in this community.