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.
To compare data in different columns for different rows of records: Topic by Vaishnavi 2 days ago

I’ve a table named MBR_DATA which is of below structure:

28 views
2 replies, 12 hours ago
Get the number of sessions of a job Topic by brokenp87 17 Jul 2012 tpt, fastload, multiload, fastexport, log, multisession, number of session

Hi everyone,
I would like to know if it's possible to know with some system table (such as dbc.dbqlogtbl or similar) to get the number of sessions opened by a MultiLoad/FastLoad/FastExport/TPT job.
In the dbqlogtbl it seems that Teradata puts only the father session which will create the child sessions...

3373 views
2 replies, 14 hours ago
Teradata Temporal Error Topic by Kishore_1 3 days ago Temporal table

I am getting the following error while using the following query:

CURRENT VALIDTIME SELECT * FROM Policy;

 *** Failure 9330 ValidTime qualifier requires at least one table with ValidTime.

                Statement# 1, Info =0 

The table Policy is defined as follows:

   CREATE TABLE Policy(

      Policy_ID INTEGER,

49 views
3 replies, 15 hours ago
Primary Index on VARCHAR column Topic by tdforumuser 17 May 2011 statistics, primary index, performance

Is it a good practice to define a Primary Index on VARCHAR column ? Although I dont see any strange (data type conversions) in explain plans between Join operations on VARCHAR (Primary Index) to CHAR column (Primary Index) since they are from same domain, I just want to understand if this is as efficient as Joins between CHAR to CHAR columns.

4379 views
6 replies, 16 hours ago
Regarding date format Topic by praveen_reddy 1 day ago date, current_date

Hi all,
 
I created a table 

create table financial.test

 (empid integer not null, 

 ename char(30), 

hiredate DATE FORMAT 'ddmmyyyy' )

primary index (empid);

 

and inserted data into it and the data is as fallows

 

empid ename hiredate

1 101 abc 01-01-2000

2 109 f 11-04-2013

25 views
1 reply, 1 day ago
Recursive ordering Topic by Zsolt84 4 days ago recursice, order, permutation

Hello,
Please help me on this issue. Generally i want my recursice query to do the recursion by ordered. I want permutations from 2 column. See below.
 
1-Have this data
content_type, product_offered
0    2
0    5
0    4
0    6
0    1
0    3
 

16 views
1 reply, 1 day ago
GENERIC JDBC and Teradata Databases Topic by Jugalkishorebhatt1 1 day ago GENERIC JDBC and Teradata Databases

Could plz help me understand the difference between these two connections.

Is it like when i connect a user with GENERIC JDBC, the session is ANSI.
Eg. When i create table. By default, it is created as MULTISET table.
Whereas if i connect a user using Teradata Database the session is Teradata Semantic and when i create a table, by default it is created as SET. I am right?

15 views
0 replies
GENERIC JDBC and Teradata Databases Topic by Jugalkishorebhatt1 1 day ago GENERIC JDBC and Teradata Databases

Hello All,
 
Could plz help me understand the difference between these two connections.

12 views
0 replies
Skew Factor Topic by reachkishore 04 Mar 2012

Hi iam Kishore.....here is my question.....suppose if have a skewfactor of 40%....then how to avoid the skewfactor...as the PI cannot be altered after table creation?

6106 views
8 replies, 1 day ago
Scemantic Layer in Teradata Data Warehouse Topic by abhijit.p 3 days ago data modeling, erwin, scemantic layer, security

Hi All,

Currently we are in development phase of a new data warehouse for a telecom giant according to cLDM 12 data model.
Our next plan is to design & build a scemantic layer on top of this new data warehouse.
 

51 views
2 replies, 2 days ago
32 views
1 reply, 2 days ago
ODBC Connection issues with Teradata 14 on VMWare Player Topic by TDAdmin 15 Jan 2013

Hell Folks,
I am receiving this disgusting error, tried many ways to figure this out but couldn't succeed. See if you can help.

835 views
2 replies, 2 days ago
How to find if system has AMFS enabled? Topic by Shrinivas.Sagare 3 days ago

Hello,
Can somebody tell me to find if system has Anonymous Memory Filesystem (AMFS) enabled?
Thanks,
Shrinivas

26 views
1 reply, 2 days ago
Identify Set - Multiset Tables in TD 14 Topic by eejimkos 2 days ago

Hello,
1.Is there any way to identify the set-multiset tables in TD14?(except the like expression on request text)?
2.Still the syntax create table as... , does not include the constraints?
 
Thank you very much.

50 views
2 replies, 2 days ago
Difference between X and V views Topic by AliHammad 1 week ago X views, V views, performance, system views

What is the difference between simple system view like dbc.tables, X views and V views and which one is better - performace wise?
Does every system view like dbc.tables will always have a corresponding X and V view? I failed to find any X or V view for for dbc.ErrorMsgs?
 
Thanks

111 views
4 replies, 2 days ago
Teradata Java UDF Topic by makaveli0129 3 days ago java, judf, udf, teradata, connection

I have a java udf that basically just does a bunch of shows on each and every procedure and macro and then inserts those into a table. The jar is installed and my definition for the procedure is below. The problem i'm getting is i keep getting the error:

51 views
3 replies, 3 days ago
Cannot connect to AWS Teradata Instance Topic by seanc 1 week ago AWS, Connection Issues

Hello,

36 views
1 reply, 3 days ago
How to reduce skew factor on stage tables with NoPI? Topic by mandava921 21 Mar 2013

Hi,
 
I am new to teradata. I have several stage tables defined as NoPI.
I notice most stage talbes have skew factor > 50. Is there a way to reduce this.
What is the best way to handle this situation for stage tables with NoPI?
Any ideas. please advise.
 
Thanks,
VM.

2186 views
14 replies, 3 days ago
Storing result set as a variable in a procedure Topic by akhilkotak 04 Dec 2013 Result Set, procedure, Result Set in Procedure

Hi,
 
I am trying to pass a result set of a query into a procedure. I  only need one column from a table but the column will have multiple rows.
I have tried within the procedure to have : SELECT columnname INTO :variable from dbc.tablename where columnname2 = 'value';

735 views
5 replies, 3 days ago
illogical answer set Topic by sakotomas 3 days ago

Hi,
 
I am querying a really big view (more than 100 columns, more than 100 million rows),
when running distinct on one column with restrictions in WHERE clause, it returns 200 rows.
However, when running the same query (same WHERE clause) with "top 10 * " it returns 0 rows.   
 

8 views
0 replies
Partition Primary Index Topic by n_shashi 5 days ago

Hi,
  I've to choose candidates for PPI for about 80 tables.Can somebody let me know the criteria for considering a field as a PPI candidate like below
 
1) Table size
2) Fields used in WHERE condition etc..
 
Thanks in advance.

104 views
6 replies, 3 days ago
Current Month End Date Topic by rlaskar 28 Mar 2006

Hi All,I was trying to identify current month end date. Let me know any sql syntax toidentify the current month end date.Thanks,rlaskar

35011 views
5 replies, 3 days ago
Find Calling Script in DBQL Topic by RA186030 4 days ago dbql

Is there a field in DBQL that returns the name of the script in which a command is executed?

25 views
1 reply, 3 days ago
Group Concatenate Topic by ds185243 4 days ago

I have a data set that looks like the following.

ID	Rank	Text
a	1	Text1a
a	2	Text2a
a	3	Text3a
b	1	Text1b
b	2	Text2b

 I would like the results to look like this:

ID	Text
a	Text1aText2aText3a
b	Text1bText2b

 I am unsure where to begin. Any help would be appreciated.

8 views
0 replies
How to install Teradata Express on Windows 7 64 bit machine? Topic by adiideas1 28 Feb 2013 teradata express

Folks,
 
I am new to teradata and to this forum. I am looking to install Teradata Express on my laptop.
On the downloads.teradata.com, it says VMware is to be installed but link is not active for Windows 7 OS.
If anybody can provide some pointers, it would be great.
 
Thanks
Adi
 
 

1995 views
4 replies, 4 days ago

Pages