Pages
![]() |
Visit the landing page for more information including sample notebooks, video clips and more ... https://teradata.github.io/jupyterextensions Join the community discussion at community.teradata.com - Ecosystem Management Forum, topic: Jupyter
15 Oct 2020
,
|
![]() |
Hi guys,
30 Aug 2016
| 4 comments
,
|
![]() |
Hi Everyone,
29 Jun 2016
| 1 comment
,
|
![]() |
I have one doubt.
15 Jun 2016
| 2 comments
,
|
![]() |
I have a parameter in a report (Report Builder 3.0) called REPORT_FILTER. This parameter has 4 available values. The labels are (1) Home Group, (2) Home Branch, (3) Other Group, and (4) Other Branch. The corresponding values are 1, 2, 3, and 4.
13 Jun 2016
,
|
![]() |
I'm struggling with a query to fetch entire database hierarchy and calculating path of each node from root. I need to create same directory structure on the file system whereby each directory represents a database.
09 Jun 2016
| 2 comments
,
|
![]() |
For a Fortune 50 Banking Company. W2 or corp-to-corp. Local candidates preferred but those willing to relocate will be considered. Manager would like to interview as soon as possible. Must have hands on experience with SQL development in Aster environment
02 Jun 2016
,
|
![]() |
Hi All, Mar 22, 2016 12:06:35 PM
31 May 2016
| 1 comment
,
|
![]() |
I am trying to use XMLAGG to transpose the row-wise data to comma separated value in Teradata 15. Its working fine with English (LATIN character set) characters. But while I am using other characters (Unicode character set) I am getting 'string contains untranslatable character' error.
16 May 2016
| 3 comments
,
|
![]() |
|
![]() |
Hi All,
30 Apr 2016
| 1 comment
,
|
![]() |
Hi All,
21 Apr 2016
| 1 comment
,
|
![]() |
execute(
17 Mar 2016
| 1 comment
,
|
![]() |
Hello!
29 Feb 2016
,
|
![]() |
Presto is an open source distributed SQL engine, originally developed by Facebook for their massive Hadoop data warehouse.
22 Feb 2016
,
|
![]() |
Please forgive me if this is a basic question, but I have found myself responsible for creating SQL reports which is not my forte. Any help will be greatly appreciated!
16 Feb 2016
| 19 comments
,
|
![]() |
Which of the following partitioning expression has a better performance while SELECT, INSERT operations ? Consider the table has data around couple of Terabytes.
05 Feb 2016
| 1 comment
,
|
![]() |
Dear All, Need help with below situation....
12 Nov 2015
| 2 comments
,
|
![]() |
I have a query with a UNION. I was trying to combine 2 records into 1. The top half gets records from 1 set of tables and the bottom half gets records from a differen set of tables. Both halves use fields from 2 derived queries. The results currently look like this:
28 Oct 2015
,
|
![]() |
My Undesrstanding was this
e.g. A Inner Join B on A.x=B.y WHERE B.z between Date1 and Date2
27 Oct 2015
,
|
![]() |
The following SQL statement using this syntax failed after query execution:
28 Sep 2015
| 4 comments
,
|
![]() |
There is "poetic query" that takes forever to run
16 Sep 2015
| 2 comments
,
|
![]() |
We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.11.
10 Sep 2015
| 5 comments
,
|
![]() |
Below delete is consuming 11K CPU.Need assistance to re-write the below delete sql to consume less CPU.
DELETE FROM IMPORT_REFER_F AA WHERE ( AA.JOB_ID, AA.JOB_HEADER_ID,AA.JOB_LINE_NUM,AA.JOB_IDN) IN (SELECT JOB_ID,JOB_HEADER_ID,JOB_LINE_NUM,JOB_IDN FROM IMPORT_REFER_S BB GROUP BY 1,2,3,4)
28 Aug 2015
| 1 comment
,
|
![]() |
Hi all,
17 Aug 2015
| 4 comments
,
|
![]() |
How to center align a decimal value(including negative numbers) with 20 characters as total fixed length.
14 Jul 2015
| 3 comments
,
|
![]() |
Good day all,
08 Jul 2015
| 11 comments
,
|
![]() |
I have a table with the following layout cust_acct_id (PK)| effect_dt | expiry_dt | curr_rec_ind | field_a | field_b | field_c | field_d I have to populate any NULL values in field_a, field_b, field_c, or field_d with the most recent value received for that field for the same cust_acct_id. Sample Input:
30 Jun 2015
| 5 comments
,
|
![]() |
Hi,
11 Jun 2015
| 1 comment
,
|
![]() |
Hi,
09 Jun 2015
| 2 comments
,
|
![]() |
Hello,
04 Jun 2015
| 3 comments
,
|
![]() |
Hi,
01 Jun 2015
| 1 comment
,
|
![]() |
Hi, CREATE VOLATILE TABLE A (ClickLoad_Dt DATE FORMAT 'yyyy/mm/dd'); INSERT INTO A(ClickLoad_Dt) SELECT MAX(CAST (click_dt AS DATE FORMAT 'yyyy/mm/dd') ) FROM B; SELECT * FROM A I get and empty table even though the answer to below query is 5/25/2015
26 May 2015
| 2 comments
,
|
![]() |
with drvd_amts (acct_nbr, grp_br_ps_org_id, PSAmt) as (select d.acct_nbr, d.grp_br_ps_org_id, sum(d.pstd_ttl_amt) as PSAmt from psfs.ps_gl_acct_ldgr d where d.fiscal_yr_mth_nbr between 201500 and 201508 and d.acct_nbr between 130500 and 160500 group by d.grp_br_ps_org_id, d.acct_nbr) SELECT a.FA_ACCT, a.ERACBR, a.deptid,
13 May 2015
| 1 comment
,
|
![]() |
I need to generate a report for top 10 rows for each date in a table. I can write a statment for each date but can anyone help with writitng it in single query;
29 Apr 2015
| 3 comments
,
|
![]() |
Hi Guys, thanks for reading the post. I did do a search for "view on view" and there was no result.
13 Apr 2015
| 1 comment
,
|
![]() |
We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.10.
30 Mar 2015
,
|
![]() |
Hi all, 1) I define a table that has a column with COMPRESS clause
16 Mar 2015
| 3 comments
,
|
![]() |
Hi,
11 Mar 2015
| 2 comments
,
|
![]() |
Hello,
04 Mar 2015
,
|
![]() |
In Teradata SQLAssistant, I have created a db user USER1 which has 17 views. This user can do a SELECT on any view, thanks to a profile/role I granted and then associated to him. His child USER2 is a db user with the same profile/role as USER1, but my problem is he can't select any of the views of USER1 :
03 Mar 2015
| 2 comments
,
|
![]() |
Hello,
10 Feb 2015
| 3 comments
,
|
![]() |
Hi,
05 Feb 2015
| 4 comments
,
|
![]() |
Hi All,
Order by Behavior is different in DB2 and Teradata
I already tried adding Case specific which doesn’t work for my project related data .
Here is the main query modified (table-name etc for security reasons and its output Demo Data but similar to main one )
03 Feb 2015
| 3 comments
,
|
![]() |
We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.01.
27 Jan 2015
,
|
![]() |
Hello Experts EMP -------- ID NAME SAL DEPT 1 SAM 50 D1 2 TOM 50 D1 3 RAM 40 D1 4 PAM 30 D1 5 JAM 30 D1 6 MAM 40 D2
31 Dec 2014
| 7 comments
,
|
![]() |
I have run into a perplexing little problem. I know how to work around it, but want to understand the reason it is occuring.
When I use the FIRST_VALUE function on a date as below, it returns two rows:
10 Dec 2014
,
|
![]() |
Hi , I tried checking forums before posting this query. Please suggest
I am getting below o/p by joining couple of tables ACT ACTIND A1 01 A1 02 A1 02 A1 03 A2 01 A2 03 A2 03 A3 01 A3 01 A3 01
30 Nov 2014
| 4 comments
,
|
![]() |
This session is intended for those already familiar with writing SQL but who are somewhat new to Teradata.
14 Nov 2014
,
|
![]() |
Hi,
04 Nov 2014
| 2 comments
,
|