![]() |
SQLAlchemy¶SQLAlchemy is an open source python library which provides an abstraction over relational databases making them easier to work with. It provides a SQL expression language to generate SQL queries and has an object relational mapper that allows you to express database queries in terms of classes and relationships between them. Using SQLAlchemy has several advantages:
07 Jul 2016
,
|
![]() |
My main objective is to transfer data from teradata to hadoop. TPT is the fastest way of doing this (eventhough i have confusion between TDCH and TPT which one to go for). TPT 15.0 onwards supports direct export to hdfs as i read in one of the documentation and also on one of the forums.
26 May 2016
,
|
![]() |
i am using Terdata version 13.10 and R Studio 3.2.3 (32-bit). I am trying to establish connection between both using following code. I also have all required JDBC drivers installed on system.
11 Mar 2016
| 4 comments
,
|
![]() |
It appears there are two evaluation versions of Teradata:
08 Feb 2016
| 2 comments
,
|
![]() |
I get the Error 2616 (Numeric overflow occurred duing computation) when I run the code below. I developed 2 separate queries that each run. When I put them in one query and use a UNION I get the error message. 1 side of the union returns 274 records and the other side returns 277 records. I'm using Teradata SQL Assistant when I get this message. We a
24 Oct 2015
| 2 comments
,
|
![]() |
Hi, i am trying to query all the data from my table in batches, e.g i have 10000 rows that i want to collect by 10 callls to db, each one will bring 1000 rows. so i will end up with 10000 rows, without duplications and row missing. i dont have any uniqe index or column in this table.
14 Oct 2015
,
|
![]() |
In Teradata Studio, when executing a REPLACE PROCEDURE statement with a comment (block /* */or single-line --) above the statement, I receive the error "REPLACE failed. Failed [3706 : 42000] Syntax error: Invalid SQL Statement." Below is an example that fails but if you remove the "-- comment" line it is successful.
20 Aug 2015
| 3 comments
,
|
![]() |
I inherited the code below and am trying to add 2 new fields to the results (bolded below). The code I'm using to join is also bolded below. I'm sure it is something I'm dong that is causing me to get the following error message when I run this sql. The error message says: Select failed 3810 Column / Paramete rfs_rv.pft.paymt_mdia_proc_sys_cde does not
10 Aug 2015
| 2 comments
,
|
![]() |
Hi,
08 Jul 2015
| 1 comment
,
|
![]() |
I have 3 prompts in my report: (1) Group Number, (2) State, and (3) Branches. The user selects the group number (1) and the prompt for State (2) is updated with all of the states the group does business in. Then the user selects either "null" or one of the states from the state prompt (2).
09 Apr 2015
,
|
![]() |
|
![]() |
Hi All,
03 Apr 2015
| 5 comments
,
|
![]() |
Hi,
01 Dec 2014
| 5 comments
,
|
![]() |
Hello All..
20 Nov 2014
| 8 comments
,
|
![]() |
Hi Can anyone help me in solving this.....
20 Nov 2014
| 2 comments
,
|
![]() |
Hi West RMACA-RMACB-RMACC-RMACD Central PO63A-PO63B-PO63C-PO63D
But i need like this
19 Nov 2014
| 4 comments
,
|
![]() |
What all are possible ways to get the exact output mentioned below: start and endtime is timestamp fields ... In the final output starttime should take from status A and end time should take from status C .
15 Oct 2014
| 5 comments
,
|
![]() |
I have a table AAA which has 3 columns as Month_No,Year_No and Profit.
16 Sep 2014
| 1 comment
,
|
![]() |
I have a query that is using Table1 and Table2 with left outer join on 'usage'. Now I have to join that query
07 Aug 2014
| 3 comments
,
|
![]() |
Hello Experts: In the Explain plan of query:
04 Aug 2014
| 2 comments
,
|
![]() |
Hi,
03 Jul 2014
| 1 comment
,
|
![]() |
Hi
18 Jun 2014
| 3 comments
,
|
![]() |
Teradata Online Training By Keen Technologies.We are Best Institute for Online Training and we have Expert trainers to share knowledge on Teradata. Terada course materials,videos are designed by our trainers.we
02 May 2014
| 4 comments
,
|
![]() |
I am new in the field of data warehousing and have basic understanding of SQL.I want to know,What are the career fields in Teradata for those who have basic understanding of SQL and data warehousing?I want a detail answer from them who really have been in the industry for several years.
23 Mar 2014
| 2 comments
,
|
![]() |
Dear Experts,
14 Feb 2014
| 4 comments
,
|
![]() |
I have a table tab1 with structure as- columnName | datatype and sample data as
15 Jan 2014
| 5 comments
,
|
![]() |
Hello everyone,
15 Jan 2014
| 10 comments
,
|
![]() |
Hi,
15 Jan 2014
| 2 comments
,
|
![]() |
Numeric overflow computation error
14 Dec 2013
| 2 comments
,
|
![]() |
|
![]() |
I seem to be having trouble with a query that I inherited from another developer. I'm told this is running a 99% skew. Would anybody be able to tell me what looks so skewed about this table?
11 Dec 2013
| 3 comments
,
|
![]() |
Can following query be rewritten so it does not have to use UNION ? THANKS. FROM
28 Oct 2013
| 1 comment
,
|
![]() |
|
![]() |
HI all,
20 Sep 2013
| 3 comments
,
|
![]() |
Hi ,
11 Sep 2013
| 5 comments
,
|
![]() |
hi
05 Sep 2013
| 1 comment
,
|
![]() |
Hi,
I'm new to Teradata,working in Teradata to Oracle migration project, converting Teradata DDL to Oracle.
For UNIQUE PRIMARY INDEX ( TRSY_ID,TRSY_STM,TAX_ID ): converted like below
TRSY_ID as Primary key , TRSY_STM as not null Unique , TAX_ID as not null Unique.
01 Sep 2013
,
|
![]() |
Hi all,
30 Aug 2013
| 4 comments
,
|
![]() |
SEL CAD.CUST_ACCT_KEY, CATD.CUST_ACCT_MKT_DESC, CASD.CUST_ACCT_STAT_CODE, ETD.RCVR_TYPE_DESC, ETD.EQUIP_BUS_CAT_DESC
FROM CUST_ACCT_DIM AS CAD JOIN CUST_ACCT_STAT_DIM AS CASD ON CAD.CURR_CUST_ACCT_STAT_KEY = CASD.CUST_ACCT_STAT_KEY
JOIN CUST_ACCT_TYPE_DIM AS CATD
10 Jul 2013
| 1 comment
,
|
![]() |
The following query gives the higest #number count per day, which is 7 rows each for 1 day. I want to include HOURS column to the results set with changing the resulting result set.So I want to know at which hour the count was the highest? without listing all the hours. Is it possiable?
result should be as this:
09 Jul 2013
| 4 comments
,
|
![]() |
how can I merge these two sql in to one query?
SELECT MONTH_BGN_DATE FROM MONTHDAY_DIM WHERE MONTHDAY_KEY = ADD_MONTHS(DATE , -4))
SELECT MONTH_END_DATE FROM MONTHDAY_DIM WHERE MONTHDAY_KEY = ADD_MONTHS(DATE , -3))
thanks.
30 Jun 2013
| 3 comments
,
|
![]() |
How can I rewrite following query to avoid join condition like this : SEL SOM.CUST_ACCT_KEY, ORD_ID, EQUIPDESC, SHIP_METH_DESC, D_DESC, SITE,
24 Jun 2013
| 1 comment
,
|
![]() |
19 Jun 2013
,
|
![]() |
How can I translate this loop into Teradata SQL? DECLARE @logdate DATETIME DECLARE @hrinput1 INTEGER DECLARE @hrinput2 INTEGER SET @logdate = '2013-03-01' SET @hrinput1 = '0' SET @hrinput2 = '1'
while @logdate <= '2013-04-01' BEGIN
28 May 2013
,
|
![]() |
How can I translate the following ms sql to Teradat Stored Procedure? DECLARE @logdate DATETIME DECLARE @hrinput1 INTEGER DECLARE @hrinput2 INTEGER SET @logdate = '2013-03-01' SET @hrinput1 = '0' SET @hrinput2 = '1'
while @logdate <= '2013-04-01' BEGIN
28 May 2013
| 1 comment
,
|
![]() |
Teradata ( Dev + Admin ) DEMO CLASS on Saturday, 25 May at 8:00 AM IST
24 May 2013
| 1 comment
,
|
![]() |
I am trying to filter transactions that are less than 5 minutes apart. In trying to develop this filter, I keep running into error messages. The two columns I need to find the difference for are TIME datatypes:
21 May 2013
| 4 comments
,
|
![]() |
Hello,
28 Mar 2013
| 2 comments
,
|