#DateForumTypeThreadPost
2919 Jan 2011 @ 02:08 PSTDatabaseReplyCode checkWhen you join tables, then teradata selects rows, that has not null values in join-fields. You can see this if you look at the query plan of your query. For example: create table zzz(a int,b i...
2813 Jan 2011 @ 06:09 PSTDatabaseReply Fload from csv fileAlso check encoding of your file, if there any nonascii symbols try SET SESSION CHARSET "UTF8"
2713 Jan 2011 @ 06:04 PSTDatabaseReply Fload from csv fileThis is from "Message" pdf document: 35 EOF encountered before end of record Explanation: The end-of-file was reached before the expected end-of-record was reached. I.e., the record read is...
2612 Jan 2011 @ 12:57 PSTDatabaseReplysemantic layerSemantic layer consist of views with some logic: for example, in WHERE clause, some joins etc...
2511 Jan 2011 @ 05:17 PSTDatabaseReplyDifference in Inserting '1 ' and '1' Both queries select hashrow('1'); select hashrow('1 '); returns the same 4C-6C-48-9E May be some bag...
2403 Jan 2011 @ 02:55 PSTDatabaseReplySpool space error in collect statisticsTry "USING SAMPLE" keyword. This prevent fullscan. Example: COLLECT STATISTICS USING SAMPLE ON DB_1.TABLE_1 COLUMN (COL_B, COL_C, COL_D, COL_E);
2303 Jan 2011 @ 02:50 PSTDatabaseReplyInsert a timestamp and characters in the same columnUse column with type varchar(19). When inserting timestamp, just cast it into varchar(19), and constant string insert "as is". For example: create table x(f1 varchar(19)); insert into x (f1) va...
2229 Dec 2010 @ 01:01 PSTDatabaseTopicErrors ignoring mode...Is there in teradata some modes/options, that let me define some errors i would like to be ignored while executing some sql statements (e.g. numeric overflow, when overflow values to be truncate or...
2128 Dec 2010 @ 07:55 PSTDatabaseReplyWhat's the sql statement to get default schema name for Teradata?select database;
2028 Dec 2010 @ 07:51 PSTDatabaseReplyerror-NO OF TABLES IN JOIN EXCEEDS PARSER LIMIT http://www.google.ru/search?q=NO+OF+TABLES+IN+JOIN+EXCEEDS+PARSER+LIMIT++teradata&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a#hl=ru&expIds=17259,27586&xhr=t&q=3540+terada...
1928 Dec 2010 @ 07:35 PSTDatabaseReplyJoining SequenceIt depends on query. In common case - no. It will be more effeective to collect statistics on join-fields of join tables (of course, if the are tables, and not subqueries): collect statisti...
1828 Dec 2010 @ 07:27 PSTDatabaseReplyCount the No. of OccurenceNo, there is no such a built in function in teradata.
1728 Dec 2010 @ 07:23 PSTDatabaseReplyHow to find the maximum length of a columnshow table TableName; It will print DDL of your table with types of each field. More carefull information see in SQL Reference: Data Types and Literals, docs are available on teradata's portal ...
1603 Dec 2010 @ 03:13 PSTDatabaseReplywhat is fallback pls tellSee links (found in google): http://forums.teradata.com/forum/database/fallback http://forums.teradata.com/forum/database/implementing-fallback http://teradata.biz/t/resources/white-papers/Fal...
1502 Dec 2010 @ 10:32 PSTDatabaseReplyiam new to teradata , i want to know sql part how i can prepare pls tell...its very urgent to meJust read documentation: http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TDBS13.10&rdsort=Title&srtord=Asc&wNew=True&nm=Teradata+Database+13.10 T...
1402 Dec 2010 @ 07:49 PSTDatabaseReplyTranspose IIHere is an example, how to do this, but the restriction is that you'll need a field, which describe link between row order and column, where you want place this. --drop table t; create table t(...
1327 Nov 2010 @ 03:05 PSTDatabaseReplyNeed help handling null and empty valuesIt looks like true.
1227 Nov 2010 @ 01:26 PSTGeneralReplyError in instalation of Teradata Express Edition V13What you see in "My computer / Manage / Events viewer (or something like this, don't remember exactly)"?
1127 Nov 2010 @ 01:13 PSTDatabaseReplyError during fast export2644 No more room in database %DBID. Explanation: This error occurs only when an attempt is made to increase the amount of space used by a database, and there is no space left to accommodate the...
1025 Nov 2010 @ 07:27 PSTToolsReplyRetain Previous record field valuedo pre-process in SAS :) it is will be most simply
919 Nov 2010 @ 08:01 PSTDatabaseReplyFewer Partitions vs Smaller PartitionsIt _mostly_ depends on issues, that wanted to be resolved, queries you executes, frequency of them and so on. >>but not a lot of queries request that level of detail Just collect time-statist...
819 Nov 2010 @ 07:04 PSTDatabaseReplyerror: bad argument for sqrt functionI replaced bigint with decimal(38,0), and it's work correctly! :) Thanx all! ps: CarlosAL, i use formula, that described in SQL Reference: Functions and Operators, function STDDEV_POP ("Compu...
717 Nov 2010 @ 11:46 PSTDatabaseReplyerror: bad argument for sqrt functionCarlosAL, when i use sqrt(abs(...)), query isn't fails. dnoeth, the formula is right, it's unsuccessful renaming variables. Isn't DECIMAL(38,0) and float are the same? Thanx, i'll try the ...
617 Nov 2010 @ 07:29 PSTDatabaseReplyerror: bad argument for sqrt functionMay be you mean (a-b) + 0.5? I already use sqrt(abs(...)), but will try to run from bteq, thx. >How many rows are in that table? there are about 100 000 000 rows >Does it work for a singl...
517 Nov 2010 @ 05:56 PSTDatabaseReplyerror: bad argument for sqrt functioni'm use sqla v13. query "select * from table where a < b" returns zero rows. the error is "2603 Bad argument for SQRT function."

Pages