Stack Overflow
Stack Overflow

Questions tagged [teradatasql]

The Teradata SQL Driver for Python (or related drivers). For Teradata (Vantage) database questions, use the [teradata] tag instead.

The Teradata SQL Driver for Python is a DBAPI Driver that enables Python applications to connect to the Teradata Database. The Teradata SQL Driver for Python implements the PEP-249 Python Database API Specification 2.0.

It is available from PyPI or Teradata's public download site and is used by the Teradata Python Package (teradataml) and the Teradata SQL Driver Dialect for SQLAlchemy (teradatasqlalchemy) to connect to a Teradata DBMS, aka Teradata Vantage SQL Engine. This driver is also leveraged by the Vantage Modules for Jupyter and is closely related to the Teradata SQL Drivers for R and Node.js.

272 questions
1
vote
2 answers

Can't download Teradata Vantage Express 16.20

I can't do a simple download of any Teradata software such as Vantage Express 16.20. I keep getting this message. access denied
sjuwana
  • 35
  • 2
1
vote
2 answers

how to take rows after a certain criteria SQL

I am using Teradata SQL and have the following data: ID MonthID Acc Complaint 1 202202 5 1 1 202203 4 2 1 202204 3 0 2 202202 2 0 2 202203 3 1 2 202204 2 3 3 202202 1 0 3 202203 2 0 3 202204 3 0 I want to retrieve all the…
samronaldo309
  • 61
  • 5
1
vote
1 answer

number pattern matching in Teradata

I was trying to get the rows matched with a pattern by using like in Teradata select * from table_name where col_name like '10%'; here I wanted to get all the rows with column values like 1000, 101, 109, 1048 this is showing me error: *** Failure…
Shivi Singla
  • 13
  • 3
1
vote
2 answers

List of unique values instead of count teradata sql

I have 2 columns; access_method-id, app_name Each user uses different apps from time to time and I need to write a query to get a list of all the apps that the user have used in one column. like this acess_method_id | App_Name 12345 |…
irum zahra
  • 417
  • 1
  • 8
  • 17
1
vote
4 answers

Teradata - Date format conversion from INT(yyyymmdd) type to date(mm/dd/yyyy) in Teradata SQL Assistant

I have dates in integer format in a column. The length is 11. Example values current format integer (11) --> date format required yyyymmdd --> dd/mm/yyyy 20121203 --> 03/12/2012 20090403 --> 03/04/2009 Can someone suggest a solution keeping in…
Naman Singhal
  • 11
  • 1
  • 3
1
vote
0 answers

Unable to connect to Teradata using sqlalchemy

I'm trying to connect to Teradata using sqlalchemy as have to read sql using read_sql(). Code: import pandas as pd import numpy as np import sqlalchemy import teradata import sqlalchemy_teradata link =…
Aditi
  • 31
  • 5
1
vote
1 answer

Teradata Active directory scan, Script show Job terminated with status 8

I follow a blog post and run the script for active directory scan with TPT but No success. No error show but just a message. Job terminated with status 8 I follow this script to make a test. I can't upload my codes here I see errors in my post just…
user16753483
1
vote
0 answers

In teradata, can you insert a cte into a table?

I've looked at the other postings but I haven't seen a resolution for this. CREATE TABLE newtable AS (SELECT * FROM yourtable) with no data ; Then with cte as ( select top 10* from yourtable ) insert into newtable select * from cte select * from…
ctk
  • 11
  • 1
1
vote
0 answers

Load Teradata table from Python Pandas Dataframe

I am getting below error while trying to load Teradata table from Python Pandas, Any idea ? teradatasql and pandas - writing dataframe into TD table - Error 3707 - Syntax error, expected something like '(' between the 'type' keyword and '=' import…
BalajiR
  • 11
  • 1
1
vote
2 answers

list of Employee having 2 products

Can someone help here. I have table employee. I want to find out list of employees having 2 products(P1,P2). Emp_id Prd_id E1 P1 E1 P2 E2 P1 E2 P2 E2 P3 E3 P1 E3 P3 E4 …
Santosh Suplepatil
  • 11
  • 3
1
vote
2 answers

How to select the latest record of each month?

I guess it is really hard to be friends with sql. Please help! I have history table that contains master records of customer for 3 years. the table looks like this: Table A: | ID | Name | Number|Date(in Timestamp)| |:---…
Jojo10478
  • 29
  • 6
1
vote
1 answer

How to extract timestamp without the time zone in sql and without converting it to string for manipulation?

I am trying to extract the local timestamp from a timestamp with time zone data type column. I currently have the below table schema: ARRIVAL_DTM TIMESTAMP(0) WITH TIME ZONE I am able to convert the timestamp to a date format without teradata…
Jonathan Lam
  • 1,237
  • 3
  • 20
  • 49
1
vote
0 answers

How to place a new line via select statement in teradata?

Suppose there is string = 'Hello how are you? Are you there?' I want the string to be splitted into 2 lines, basically want to put a new line character in between, so that the export file (from bteq) captures it. o/p in export file…
pc52938
  • 11
  • 2
1
vote
2 answers

How to handle repeated records in SQL?

I have a simple data set like below: Employee Data I need minimum start date & max end date of an employee whenever there is a dept id change or status code change. So i wrote this formula for Min start date- select emp id, dept id, status code ,…
Rajesh Kota
  • 35
  • 4
1
vote
2 answers

Subtracting value in one column from the date in another column

I have tried: add_months('date_column', -'number_of_months_column') I get: error [3535] A character string failed conversion to a numeric value. Is what I am trying to do possible with the add_months option?
InvisibleInk
  • 43
  • 1
  • 8
1
2
3
…
18 19