11 | 31 Jul 2014 @ 08:08 PDT | Database | Topic | number of rows per AMP - BEFORE RECONFIGURATION | Hi,
I know how to check data distribution per AMP using primary index columns. Easy.
However, I have a table , couple of weeks later new AMPs are added and reconfiguration hasn't been d... |
10 | 30 Jul 2014 @ 09:04 PDT | Database | Topic | partitioning on DATE or TIMESTAMP | Hi,
I was suggested by DBA to change in one of tables , the partitioning column from timestamp to date.
In explain plan I can see that in both cases partition prunning takes place.
Is there anyb... |
9 | 21 May 2014 @ 03:55 PDT | Database | Topic | stored procedures with loop - queueing | Hi,
Due to size of data (not to blow spool space) I need to chop that big dataset with cursor looping through X millions of rows.
Our database is really busy, and each iteration of loop gets pars... |
8 | 03 Mar 2014 @ 07:43 PST | Tools | Topic | Fast Export parallelism | Hi,
I am successfully exporting with fast export tool. However I am not sure about parallelism of export.
From fastexport logs I have:
**** 13:49:28 UTY8715 FastExport is submitting the followin... |
7 | 17 Oct 2013 @ 06:26 PDT | Database | Topic | stored procedure error handler for volatile tables | Hi,
I am working with volatile tables in stored procedure.
I need to handle errors for drop table X:
a) when table being dropped already exists (from prior run of stored procedure)
b) when tabl... |
6 | 11 Oct 2013 @ 02:59 PDT | Database | Reply | Stats collection inside SP's | On teradata 14 collecting statistics for volatile tables within stored procedure works for me fine, BUT
due to security reason I am granted I had to add SQL SECURITY INVOKER
CREATE PROCEDURE data... |
5 | 09 Oct 2013 @ 08:02 PDT | Database | Reply | Teradata 14 and REGEXP_INSTR | ok, interesting REGEXP_INSTR to work can only take two params like:
regexp_instr(tekst,'\.([[:alpha:]]){0,}$')
when you give
regexp_instr(tekst,'\.([[:alpha:]]){0,}$',1,1... |
4 | 09 Oct 2013 @ 07:40 PDT | Database | Topic | Teradata 14 and REGEXP_INSTR | Hi,
I am trying to call for REGEXP_INSTR , but despite being on :
InfoKey,InfoData
RELEASE,14.00.04.08
LANGUAGE SUPPORT MODE,Standard
VERSION,14.00.04.07
I am getting 5589 error te... |
3 | 09 Oct 2013 @ 04:29 PDT | Database | Topic | Timestamp wit time zone conversio | Hi,
I have a table with timestamp(3) column. Timestamp value is normalized to UTC 0 time zone.
I want to query that table using local time for Brasil, but I want to avoid normalizing UTC 0 ... |
2 | 06 Oct 2013 @ 07:22 PDT | Database | Reply | Primary index + Partition Key + single AMP operation | Ok, I understand that would be to much for single AMP to handle millions of rows.( I am new to TD so I prefered to ask :-) )
I will make PI distributed as evenly as possible , i.e. using ( userid ... |
1 | 06 Oct 2013 @ 03:34 PDT | Database | Topic | Primary index + Partition Key + single AMP operation | Hi Teradatares :-)
I am new to Teradata database. Currently I am thiking of creating "big" table that should grow 200 mln rows each week. After a year data it will be 10 000 000 000 rows... |