All Forums

Topics related to the Teradata Database, excluding database connectivity (e.g. JDBC) and extensibility (e.g. UDFs) . Typical topics are about SQL syntax and usage (SELECT, GROUP BY etc), database performance, use of database functions, comparison with / migration from Oracle or DB2, and generally why the Teradata Database rocks. For articles, blogs and more, see the Database section of the site.

You must login to post to the forums.
Different Column Orders for Stats Recommended by DIAGNOSTIC HELPSTATS? Topic by ricejfx 1 hour ago stats

Hello,
I am running into a spool space problem on tables that I just created, which had no statistics.  I employed the DIAGNOSTIC HELPSTATS ON FOR SESSION in order to get the recommended stats (admittedly, this was just so I didn't have to type them all).  When I started to grab that stats that I thought would be helpful, I noticed the following recommendations:

4 views
0 replies
What is difference between Redistribution of rows and Duplication of small table in AMPs Topic by kamlesh114 8 hours ago

Related to join strategy used by TD optimzer.
 
When we join table and see explain plain then  it show that rows are redistributed/duplicated on all AMPs based on join startegy used by Optimizer to get the final result.
Please correct me..
1.Redistribution - Rows from one or both table are redistributed to all the AMPs based on hash code.

20 views
1 reply, 2 hours ago
Fastload Topic by abhishank18 1 day ago

Is there any way to access the Error Tables in case there is an error while fastload process, As selecting from error table throws an error saying table is being loaded ? If not how can we know due to which row the load has paused ?

 

59 views
8 replies, 6 hours ago
Help in XML shredding Topic by SteveTheBlue 17 Mar 2015

Hi, apologies if this is the wrong forum.
I am new to XML shredding and wondered if anybody could advise why the call on the procedure at the end of the following fails saying "CALL Failed.  [9134] AS_SHRED_BATCH:Error in function ASSHRED_GETTABLES: Invalid annotated schema. "
Thanks for any advice.
 
 

-- Create a file with the XML document

1287 views
3 replies, 7 hours ago
How to get column data type and format Topic by venkata_k01 9 hours ago

I am working on one automation process where data will be fetched from a table based on qualifying key passed as parameter. That qualifying key can be of type date/timestamp. I need to handle all formats of date in the where statement and if the type is timestamp,no need to convert timestamp to any format, just use that column in the where statement.

8 views
0 replies
how to handle Null values in FASTload Topic by aneelkumar04 10 hours ago
Define
 colum (CHAR(19), nullif='                   '),
 colum2 (CHAR(35), nullif='                                   '),
 colum3 (CHAR(2), nullif='  '),
 colum4 (CHAR(4), nullif='    '),
 colum5 (CHAR(19), nullif='                   '),
 colum6 (CHAR(4), nullif='    '),
9 views
1 reply, 10 hours ago
Fastload Duplicate Records issues Topic by aneelkumar04 6 days ago

Hi All,
 
I am loading data from file to Db using fastload. My file got aborted due to duplciate records,but when i chcecked in file there is no duplicate records in file. I am confusinng. How its possible.
 
Log :
Total Records read   = 2987
Total Error Table 1  = 0 Table has been dropped
Total Error Tabel2 = 0 Table has been dropped

85 views
7 replies, 10 hours ago
Help needed for understanding of space default behavior and limitations or rules Topic by agts 1 day ago

Existing Database

 

Database Name = A1

Perm Space    = 100 GB

Spool Space   = 100 GB

Temp Space    = 100 GB

 

 

CREATE DATABASE A11 FROM A1

AS PERMANENT  = 20 GB;

 

What will be default Spool and Temp space allocated to database A11 ?

 

CREATE DATABASE A12 FROM A1

18 views
2 replies, 11 hours ago
TPT Script Error While executing Topic by MohanMuchivolu 17 hours ago

Hi,
I am getting below TPT error while reading from MQ 
MQ_READER[1]: TPT19434 pmOpen failed. General failure (34): 'Teradata Websphere MQ AMOD/PIDMMain(!ERROR!).  --ERROR: Ignoring unnecessary pathname specification at open'
MQ_READER[1]: TPT19304 Fatal error opening file.
MQ_READER[1]: TPT19015 TPT Exit code set to 12.

5 views
0 replies
CASE statement vs UDF Topic by raka 20 hours ago case stament

Hi,
I'm a java developer and new to TD and looking for some input/advice.
We have a query where we are using "CASE". After rough profilling found this "CASE" part is taking more time compared to others. The query is working fine for smaller data sets but it is CPU timing out of larger datasets . How do I get around with the CPU timeout ?
 

10 views
0 replies
UDF Default Database Topic by andydoorey 29 Mar 2016 udf

Is there a database where we can create user defined functions so that it is not necessary to qualify them with the databasename when we use them.  The UDFs that have been created by the Teradata installation are all in the TD_SYSFNLIB database, and don't need to be prefixed with the databasename.  What I'm after is a place to put our own functions so we can use them in a similar way.

137 views
3 replies, 20 hours ago
partition by a superset of multiple columns Topic by tranlm 22 hours ago

Hi guys,

8 views
0 replies
Data migration between 2 different Boxes Topic by Navic 2 days ago # teradata #datamovent

Hello!
Our team is working in migrating data of few databases from one server to another server which are in different locations. Possibality of data movement  through only physical data dump due to some org policies.  
we have Teradata 14
We like to understand is there any way to take DB backup and move to new server and restore DB?

31 views
2 replies, 1 day ago
Merge into operation Topic by Soumyatg 4 days ago

I am rewriting an insert statement which was taking lot of time, as a Merge statement. The target table is Multiset also it has a composite NUPI. the source may have non unique rows. Is it at all possible to achieve this by using Merge statement?

62 views
5 replies, 1 day ago
DBQL Metrics Topic by samurai07 22 Jun 2013 totaliocount, MaxAmpIO, CPUSkew, IOSkew

Hi ,
Can some please explain / eloborate the DBQL Metrics and how they are interrelated like the below with some example with any record count
TotalIOCount,
MaxAmpIO,
MaxAmpCPU,
ImpactCPU
ImpactIO,
CPUSKew,
IOSkew,
IOSkewWastage,
CPUSkewWastage
 
Thanks

3177 views
8 replies, 1 day ago
How to calculate minimum & maximum values based on a column only if the records are continuous Topic by venkata_k01 1 week ago

Hi,
I have data as below
col1 col2 begindate enddate
A  100  '2016-01-01' '2016-02-18'
A   100 '2016-03-01' '2016-04-07'
A   101 '2016-03-31' '2016-04-20'
A   100 '2016-05-01' '2016-06-03'
A 100 '2016-06-18' '2016-07-07'
 
i need output like 
A 100 '2016-01-01' '2016-04-07'
A 101 '2016-03-31' '2016-04-20'

179 views
11 replies, 1 day ago
Consequential inserts into large fact table performing very slow inside stored Procedure Topic by Soumyatg 4 days ago
 Run_Id Check_Point Check_Point_Desc Records_Processed time_elapsed
16 201,607,122,102 1 Delete From    Xyz 110,013,266   0:00:28.0000
15 201,607,122,102 2 INSERT INTO    Xyz FROM abc6 42,007,343   0:06:27.0000
14 201,607,122,102 3 INSERT INTO    Xyz FROM abc5 66,254,366   0:21:33.0000
13 201,607,122,102 4 INSERT INTO    Xyz FROM abc4 1,276,919   0:01:11.0000
62 views
4 replies, 1 day ago
Problems installing in TDExpress15.00.02_Sles11_40GB Topic by juanalfonso 5 days ago TDExpress15 VM

Hello everybody,

I downloaded the Teradata Express 15.00.02 for VMware Player from the website and I'm trying to install SAP Data Services but I receive the following error:

  • Failed: Minimum patch level requirements for OS (Critical)

This is the release I have:

TDExpress15.00-02_Sles11:~ # cat /etc/SuSE-release

82 views
8 replies, 2 days ago
Defaulting during Teradata table loading through fast load Topic by pradip_rang 4 days ago

Hello everyone,
I am new to database and table loading, I am trying to load pipe separated .txt file into teradata table and i am using fast load mechanism.
My requirement is that for few columns I have write defaultung logic so that if null value found in the file then i need to use the default value may be -1 or so...

36 views
2 replies, 2 days ago
Create a table with a date column that has a default Topic by boxerdog 11 Sep 2012

Hi all,

No amount of google searching or manual reading has led me to the solution to this problem:

I would like to create a table that has a column that is a date.  I want said column to have a default value.

 

25347 views
4 replies, 3 days ago
34 views
2 replies, 3 days ago
Real/DoublePrecision/FLoat type in Teradata Topic by indra91 5 days ago

In the reference of Teradata I could see numeric data types like Real,Double Precision,Float.But I could see example of only Float data.Can anybody point out whether all the three refers to the same type.In case the answer is in negative could you cite an example of a Real/Double Precision type?

31 views
3 replies, 3 days ago
Volatile Tables in Macros Topic by N_Raghu 18 Oct 2014 #Volatile tables

I am writing a long macro that needed to stage data in several tables before loading into final table.

1506 views
6 replies, 4 days ago
TPT load in informatica giving CLI Error Topic by Prabhakar Thangapandi 01 May 2013 tpt, CLI Error, plug-in failed, cli, 220

Hello,
Greetings....
I am loading Teradata (V13.10.03.08) database using informaticav9.1.0 (with Hotfix1). In Infa, i am using TPT connection.
I have the follwing property on the TPT Connection string used in informatica..
Tenacity 4, Max/Min, 10/10. Sleep 6. Block Size 64000. System Operator: Export.

2498 views
15 replies, 4 days ago
Equivalent function for DATEADD Topic by Monica_a 18 Sep 2013 #sql

Hi all,
       I need to calculate 8 weeks of data is there any function related to this??
 

7742 views
5 replies, 5 days ago

Pages