• Teiid - Deploy one table into an existing model

    I am using embedded Teiid  9 with Oracle translator.   I have an Oracle schema with a large number of tables.   I have to deploy the Oracle model at each time a new table is added and the deploy is t...
    Profile Photo
    last modified by mtawk
  • Distinct keyword and like_regex performance is very slow

    I am using TEIID to connect to an nosql service, which cannot take care of distinct, so we are getting lot of records, and distinct is performed at TEIID layer.   The distinct keyword and like_regex performance ...
    Profile Photo
    last modified by avinashch.1611
  • SalesForce URL always invalid Teiid Designer

    I am unable to connect to our test/sandbox environment as any version of the test url supplied generates -  "The supplied URL text is not a valid SalesForce URL". I've tried quite a few variations and don't know ...
    Profile Photo
    last modified by johncockson
  • Deploy Elastic Search through Rest URL on Teiid Designer VDB on Wildfly server

    Hello All,   We are trying to deploy elastic search vdb through Rest url. Below are the steps we followed.   1. We imported Elastic Search index through Import>Webservice Source>Source and ViewModel(...
    Profile Photo
    last modified by srinath0533
  • Issues connecting Jboss DV to Hive source.  Wrong Driver Class is the error.

    Hello All,   I'm trying to connect my Jboss DV to Hive using Jboss Developer Studio.   - Jboss Developer Version: 9.1.0.GA - Redhat Jboss EAP 6.1+ - Teiid-engine-8.12.5.redhat-8 - Hive Driver - hive-jdb...
    Profile Photo
    last modified by srinath0533
  • Issues connecting Jboss DV to Hive source.  Wrong Driver Class is the error.

    Hello All,   I'm trying to connect my Jboss DV to Hive using Jboss Developer Studio.   - Jboss Developer Version: 9.1.0.GA - Redhat Jboss EAP 6.1+ - Teiid-engine-8.12.5.redhat-8 - Hive Driver - hive-jd...
    Profile Photo
    last modified by srinath0533
  • DevStudio Issue after started - "Searching runtimes...."

    Hello All,   Everytime i start the Devstudio i see an error while updating the project wizard.     ERROR MESSAGE: An internal error occurred during: "Searching runtimes...".   Exception Stack...
    Profile Photo
    last modified by srinath0533
  • DevStudio Issue after started - "Searching runtimes...."

    Hello All,   Everytime i start the Devstudio i see an error while updating the project wizard.     ERROR MESSAGE: An internal error occurred during: "Searching runtimes...".   Exception Stack...
    Profile Photo
    last modified by srinath0533
  • TeiidDesigner 11.1.3 and Wildfly 10x. Unable to import views from Hive but able to import tables

    I choose Table Types as TABLE and i was able to import the tables     Now i choose Table Types as TABLE,VIEW as seen above but see error as below. I also choose Table Types as just the VIEW but still sa...
    Profile Photo
    last modified by srinath0533
  • Could not free space for pending write

    Hi,   I'm currently using Teiid to copy billions of rows from different sources to a Microsoft SqlServer  database. The records are related to patient files.   I'm doiing this using a small Java progr...
    Profile Photo
    last modified by gadeyne.bram
  • In Teiid Designer, how to create a VARIADIC parameter for a procedure?

    http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metadata.html#_create_procedure_function   I had read the above reference. In Teiid Designer, I had created a source model, and a custom proced...
    Profile Photo
    last modified by cshong
  • Unable to execute batch upsert in prepared statement

    Hi,   I am getting exception when performing upsert using prepared statement batch. teiid version: 9.1.3 jboss version: Wildfly 10.0.0 teiid AdminShell: 9.1.3   Scenario: I am trying to perform upsert in bat...
    Profile Photo
    last modified by kulbhushanc
  • org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException

    Hello,   After creating view from hive table , while i am going to view it's data using preview. below exception is coming. I'm using teiid 9.0.6 and wildfly 9.0.2   error on jboss developers studio :-  ...
    Profile Photo
    last modified by gopal.goel
  • Teiid odata : scientific notation support

    Hi,   I have an issue with Teiid 10.2.0.   The odata translator doesn't seems to support scientific notation   Here is my input :     "@odata.context": "https://toto",    "val...
    Profile Photo
    last modified by berenger
  • VDB Versioning misunderstanding?

    Hi, i'm trying to use simple VDB versioning. I'm using just simple XML VDB deploy (placing into deployments dir): <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="test" version="1"> ...
    Profile Photo
    last modified by lukyer
  • Design of Teiid Camel Component

    Hi,   There has been some interest in the Teiid Camel Component. So far, Teiid team has been suggesting to use the Camel's SQL component to interact with Teiid. That seemed like the best idea at that time. But t...
    Profile Photo
    last modified by rareddy
  • Apparently incomplete README.adoc in teiid-quickstarts/webservice-as-a-datasource

    Hi all,   (if this is the wrong forum for this kind of question, please point me to the right one)   teiid-quickstarts/webservices-as-a-datasource/README.adoc contains a step-by-step instruction on how to ...
    Profile Photo
    last modified by inreoh
  • Rest Service Post Method - How to pass multiple input parameters?

    Hello,   I have a stored procedure defined in VDB, which is enabled to get deployed as rest service (war).   Stored procedure gets 3 input parameters and is defined to use rest method as http'Post'. ...
    Profile Photo
    last modified by cm.kumar
  • How to write Exception handling in VDB stored procedure?

    Can you guys give me some examples for Exception handling in VDB stored procedure
    Profile Photo
    last modified by thiru28
  • Error Connecting to Teiid (9.0.1) via ODBC

    Hi,   I get the following error while connecting to Teiid via odbc:   DataSource.Error: ODBC: ERROR [50000] ERROR: TEIID31100 Parsing error: Encountered "[*]from[*] \"adfcorevdb\".\"TestDallas\".\"Product_...
    Profile Photo
    last modified by jrod2016