5,624 questions
0
votes
2
answers
101
views
Grouping of records in case values are null
We have got a table with a identifier, a key/value pairs and a start and end timestamp which indicates the valid period for the values.
MASTER_WORK_ORDR_ID
START_TS
END_TS
WORK_ORDR_ID_CTXT
...
- 13
0
votes
0
answers
62
views
Python teradatasql - Timeout per sql request issues
Presently trying to create a teradatasql python means of creating a timeout per each sql request made to a connection of 30 seconds but when trying the "request_timeout":"30", to ...
- 35
0
votes
0
answers
77
views
How does using RTLD_NODELETE affect Teradata UDF shared library unloading behavior?
I'm working on a UDF solution for Teradata Database using C-based UDFs compiled into a .so shared object library. The UDFs run in non-secure mode, inside the main Teradata processes.
Observed behavior:...
- 51
0
votes
0
answers
69
views
PySpark to Teradata insert fails with java.sql.BatchUpdateException when using batchsize
I am trying to insert data from HBase into Teradata using PySpark.
The data is read into a Spark DataFrame and inserts successfully when I limit the DataFrame to 3000–5000 rows like this:
df = df....
- 155
2
votes
3
answers
135
views
Changing data structure from "Date" to "From_Date" and "To_Date" based on ID and Flag
I have IDs, their as at date (end of month format), and their corresponding flags. I only care if the flag is Y.
It is in the following format:
ID
as_at_date
Enabled_Flag
1
31/01/2025
Y
1
28/02/2025
Y
...
- 23
1
vote
2
answers
69
views
Consolidate date ranges using Teradata
I need to take a list of date ranges and consolidate them. In our existing table, sometimes the FROM_DT and TO_DT are the same and the FROM_DT in the following row is 1 day after the previous row's ...
-1
votes
1
answer
94
views
Matching holidays between two dates (SAS TO SQL)
I have two tables one with request dates and SLA and the other with the list of dates of US holidays.
I want to write query that checks if any of the holidays fall between the request dates and the ...
- 873
0
votes
0
answers
45
views
Teradata PI+Non PI in join
Will primary index be utilised in Teradata if join condition on NON primary index along with primary index columns?
Suppose,
-- Table A
CREATE TABLE Orders (
OrderID INT,
CustomerID INT,
...
- 11
0
votes
3
answers
122
views
Teradata SQL Conditional Join
I'm guessing my question was asked before, but after hours of scouring, either I'm not able to figure out how the answers match my dilemma or it truly hasn't been asked (I'm guessing the former). So, ...
- 111
0
votes
0
answers
43
views
To remove multiple rows using GROUP BY in Teradata sql assistant
Im using the below query and its result will be,
sel SOLD_ACCTBL_DOC_ID,prim_SOLD_ACCTBL_DOC_ID,
case when CPN_NUMBER=1 then cpn_number else '' end as CPN_NUMB_1,
case when CPN_NUMBER=...
0
votes
0
answers
66
views
Create oracle link to teradata
isql works normally but when selecting with database I got "NativeErr = 50404"
My odbc.ini is :
[myteradatadb]
Description = TERRADATA
Driver = /opt/teradata/client/20.00/odbc_64/lib/...
- 13
0
votes
0
answers
63
views
Invalid Period value constructor. The beginning bound must be less than the ending bound
I have the following stored procedure that raise an error I don't succeed in resolving.
I know the problem is on the line "PERIOD..."
AND PERIOD(CAST(max_dt_deb AS TIMESTAMP), CAST(...
- 141
0
votes
0
answers
135
views
How to avoid "no more spool space" when joining two very big tables (thousand of billions)?
I have two tables I am using on a request.
Table 1 has 1 billions rows / Table 2 has one trillion rows.
When I execute the following request I have the error "no more spool space"
create ...
- 141
0
votes
0
answers
46
views
Teradata trigger to update values based on lookup tables
I'm trying to create a trigger to update a couple of columns in a main table (UI_tab) with values from two lookup tables (lu1_tab and lu2_tab). Here are the table layouts:
UI_tab:
network_id int
...
- 185
0
votes
1
answer
105
views
Display column names in export file bteq command
I have SQL queries with bteq that sometimes return no data and it's normal.
I want that the export file, even when the query returns no data, contains the columns names.
How can I do that please?
...
