Stack Overflow
Stack Overflow

Questions tagged [teiid]

Teiid is a data virtualization system by JBoss that allows applications to use data from multiple, heterogenous data stores.

Teiid is a data virtualization system by JBoss that allows applications to use data from multiple, heterogenous data stores.

http://www.jboss.org/teiid

158 questions
0
votes
1 answer

Deploying Solr Translator in Jboss

I am trying to use the embedded JCA connector to connect to a Solr Source to be able to then deploy that as native VDB in TEIID to query SOLR using SQL. Below is the translator and resource adapter configuration I have under…
ASAFDAR
  • 19
  • 1
  • 7
0
votes
1 answer

Convert the timestamp in accessing VDB (TEIID)

I am new to TEIID and VDB. As per my need, I need to extract the VDB data using Postgres SQL by validating the converted timestamp. Issue is Here is the sample query that I am trying to execute. select col1, col2, col3 from (EXEC…
Sekhar
  • 627
  • 4
  • 14
  • 34
0
votes
0 answers

NO LOCK Hint for SQL Server Connection in Jboss/TEIID

How can one pass no lock hint option in Jboss connection settings. Is passing the TRANSACTION_READ_UNCOMMITTED flag correct? Even though I have this flag in connection setting, I still see a LCK_M_SCH_S wait type for Jboss connection to SQL Server…
ASAFDAR
  • 19
  • 1
  • 7
0
votes
1 answer

I am unable to run HIVE functions in my DBeaver tool

I am trying to run some hive functinos in Dbeaver tool but it always giving the below error What I am trying to run is for example : SELECT from_unixtime(unix_timestamp('17-Sep-21', 'dd-MMM-yy'),'dd-MMM-yy'); error I am getting : SQL Error [30328]…
Ganesh galla
  • 15
  • 1
  • 4
0
votes
1 answer

TEIID Function not returning Value

I have created following simple function to return a count value but its not returning when executing from SQL: CREATE VIRTUAL FUNCTION GET_COUNT (IN value string) RETURNS integer AS BEGIN SELECT count(variable) from…
ASAFDAR
  • 19
  • 1
  • 7
0
votes
1 answer

Wildfly Idle/Hung connection timeout

I have a connection defined in standalone.xml to be able to release a connection upon idle timeout. I have noticed sometimes the connection is not releasing from SQL server DB even after the query has completed. The other scenario I would like to…
ASAFDAR
  • 19
  • 1
  • 7
0
votes
1 answer

Calling Python Function as UDF from TEIID

If I have series of functions in python that I want to call from TEIID VDB as UDF. Is that possible without having to convert it to native Java based code ? Can this be done using Jython ?
ASAFDAR
  • 19
  • 1
  • 7
0
votes
1 answer

How to access only virtual views and hide physical tables with a standalone-vdb.xml wildfly/Teiid domain

We are using standalone-vdb.xml domain to create a vdb and then make it accessible through Jupiter for other users. Now based on the xml file below as an example, we created the VIEW "customer_view" from the table "Export2.customer_table" and they…
Alexis_543
  • 33
  • 8
0
votes
1 answer

Cannot invoke "org.teiid.spring.common.ExternalSource.getTranslatorName()" because "es" is null

I am trying out this starter for the first time using this example : rdbms But i am getting the below exception: Cannot invoke "org.teiid.spring.common.ExternalSource.getTranslatorName()" because "es" is null 2021-06-22 01:29:57.683 WARN 1204195…
Sim
  • 382
  • 2
  • 13
0
votes
1 answer

Accessing Parquet files form Teiid

Can Teiid be used to access parquet files stored in external directory (out side the web container) in Wildfly web application? Appreciate any help on this
Himesh Narana
  • 1
  • 2
0
votes
0 answers

Implicit conversion of UUID to character varying when using TEIID with postgres

I have a VDB containing a view with a UUID column with this definition …
Tomáš Tomek
  • 21
  • 4
0
votes
1 answer

Combine two Java Objects in TEIID

I have a UDF that returns two java objects with double values: object1 = {1.0,1.5,2.0,2.5} object2 = {5.0,6.0,7.0,8.0} I would like to combine/merge them in following way returning a double array: resultArray = [1.0,5.0,1.5,6.0,2.0,7.0,2.5,8.0] I…
ASAFDAR
  • 19
  • 1
  • 7
0
votes
1 answer

OData changeset transaction with Teiid

I am trying to insert data into a SQL server datbase by using an Odata batch request changeset with Teiid. Surprisingly the inserts doesn't seem to be atomic. I am using Teeid 13.0.2 and mssql-jdbc-7.4.1.jre8.jar. To demonstrate the problem. I…
mbankdmt
  • 1
  • 1
0
votes
1 answer

Teiid-wildfly Odata4 Server side validation

Please let me know if we can configure server side validation logic in vdb.xml file to validate the user input before insert values into database using teiid wildfly odata4 service. Thanks.
AMITESH
  • 5
  • 2
0
votes
1 answer

Teiid Springboot Starter Collation or Locale

Where can I set the locale for translators and what is the accepted format. E.g. I have seen instances where the locale is set as nl_NL, nl-NL. I want to force the locale of Teiid Springboot to be UTF-8 in order to make sure that ORDER BY clauses…
Kusters
  • 28
  • 1
1 2
3
…
10 11