29 | 19 Jan 2011 @ 02:08 PST | Database | Reply | Code check | When 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... |
28 | 13 Jan 2011 @ 06:09 PST | Database | Reply | Fload from csv file | Also check encoding of your file, if there any nonascii symbols try SET SESSION CHARSET "UTF8" |
27 | 13 Jan 2011 @ 06:04 PST | Database | Reply | Fload from csv file | This 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... |
26 | 12 Jan 2011 @ 12:57 PST | Database | Reply | semantic layer | Semantic layer consist of views with some logic: for example, in WHERE clause, some joins etc... |
25 | 11 Jan 2011 @ 05:17 PST | Database | Reply | Difference in Inserting '1 ' and '1' | Both queries
select hashrow('1');
select hashrow('1 ');
returns the same 4C-6C-48-9E
May be some bag... |
24 | 03 Jan 2011 @ 02:55 PST | Database | Reply | Spool space error in collect statistics | Try "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); |
23 | 03 Jan 2011 @ 02:50 PST | Database | Reply | Insert a timestamp and characters in the same column | Use 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... |
22 | 29 Dec 2010 @ 01:01 PST | Database | Topic | Errors 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... |
21 | 28 Dec 2010 @ 07:55 PST | Database | Reply | What's the sql statement to get default schema name for Teradata? | select database; |
20 | 28 Dec 2010 @ 07:51 PST | Database | Reply | error-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... |
19 | 28 Dec 2010 @ 07:35 PST | Database | Reply | Joining Sequence | It 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... |
18 | 28 Dec 2010 @ 07:27 PST | Database | Reply | Count the No. of Occurence | No, there is no such a built in function in teradata. |
17 | 28 Dec 2010 @ 07:23 PST | Database | Reply | How to find the maximum length of a column | show 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 ... |
16 | 03 Dec 2010 @ 03:13 PST | Database | Reply | what is fallback pls tell | See 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... |
15 | 02 Dec 2010 @ 10:32 PST | Database | Reply | iam new to teradata , i want to know sql part how i can prepare pls tell...its very urgent to me | Just 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... |
14 | 02 Dec 2010 @ 07:49 PST | Database | Reply | Transpose II | Here 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(... |
13 | 27 Nov 2010 @ 03:05 PST | Database | Reply | Need help handling null and empty values | It looks like true. |
12 | 27 Nov 2010 @ 01:26 PST | General | Reply | Error in instalation of Teradata Express Edition V13 | What you see in "My computer / Manage / Events viewer (or something like this, don't remember exactly)"? |
11 | 27 Nov 2010 @ 01:13 PST | Database | Reply | Error during fast export | 2644 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... |
10 | 25 Nov 2010 @ 07:27 PST | Tools | Reply | Retain Previous record field value | do pre-process in SAS :) it is will be most simply |
9 | 19 Nov 2010 @ 08:01 PST | Database | Reply | Fewer Partitions vs Smaller Partitions | It _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... |
8 | 19 Nov 2010 @ 07:04 PST | Database | Reply | error: bad argument for sqrt function | I 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... |
7 | 17 Nov 2010 @ 11:46 PST | Database | Reply | error: bad argument for sqrt function | CarlosAL, 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 ... |
6 | 17 Nov 2010 @ 07:29 PST | Database | Reply | error: bad argument for sqrt function | May 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... |
5 | 17 Nov 2010 @ 05:56 PST | Database | Reply | error: bad argument for sqrt function | i'm use sqla v13.
query
"select * from table where a < b"
returns zero rows.
the error is "2603 Bad argument for SQRT function." |