Q&A BY TAG 'Teradata'

You must sign in to ask a question. If you do not have an account, you can register here

Same query, different results
answered 30-11-2021 07:30:41 -0500

I have a derived query that joins data from Teradata and AWS Athena sources. Both data sources are updated nightly. The derived view takes about 20minutes to complete. I noticed that the same query returned different results when executed back to back....

Answers: 5

athena Teradata

Create base view from exist stored procedure at teradata source
answered 08-06-2020 08:43:40 -0400

Hi, please I have stored procedure exist at teradata source and I need to create baseview using this stored procudre , so I tried to make base view by using create from sql query and type call pocedureName() but error appears " [Teradata Database] [Ter...

Answers: 1

Base View descrptions Stored Procedure Teradata

query bands to teradata.
answered 24-04-2020 06:01:38 -0400

my team is impementing denodo with one of our customer facing apps calling denodo. denodo then will reach out to Teradata. so the jdbc from my app will be calling the denodo views/objects ( which are inherintly mapped to my teradata views/objects). ...

Answers: 7

teradata query bands

[Teradata Database] [TeraJDBC 16.20.00.12] [Error 3706] [SQLState 42000]
answered 23-10-2019 08:36:26 -0400

I am trying to create a Denodo base view from an already developed Teradata view used in Tableau TDE. THe same query executed fine in Teradata, but give the below error while I try to create a base view from query n Denodo. com.denodo.util.exceptions....

Answers: 1

Denodo Teradata

Function LASTDAYOFMONTH not delegated to Teradata
answered 22-01-2019 06:26:53 -0500

Hallo Denodo Team, Investigating the reasons why a query is not delegated to the Teradata data source, we have read this explanation: The function 'lastdayofmonth' cannot be delegated to this database Teradata has a corresponding function, namely LA...

Answers: 2

delegate lastdayofmonth teradata delegation

Is it possible to create volatile table(temp table) in teradata via Denodo?
answered 12-10-2017 02:59:25 -0400

I was trying to create a baseview in denodo by using the below query. i am getting an exception com.denodo.util.exceptions.InternalErrorException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.35] [Error 1077] [SQLState HY000] executeQuery() cannot be us...

Answers: 2

teradata DENODO

Teradata as Cache Database and Configuring Monitoring Tool for Teradata
answered 24-04-2017 16:56:47 -0400

Teradata as cache Database: Does Denodo supports Teradata as caching database ? If yes then is it works as other RDBMS system does ? I wanted to confirm if I setup Teradata as cache database, element delegation such as function, subquery, etc, should w...

Answers: 2

cache cache configuration Denodo Monitor teradata monitoring tool monitor