#DateForumTypeThreadPost
1131 Jul 2014 @ 08:08 PDTDatabaseTopicnumber of rows per AMP - BEFORE RECONFIGURATIONHi, 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...
1030 Jul 2014 @ 09:04 PDTDatabaseTopicpartitioning on DATE or TIMESTAMPHi, 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...
921 May 2014 @ 03:55 PDTDatabaseTopicstored procedures with loop - queueingHi, 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...
803 Mar 2014 @ 07:43 PSTToolsTopicFast Export parallelismHi, 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...
717 Oct 2013 @ 06:26 PDTDatabaseTopicstored procedure error handler for volatile tablesHi, 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...
611 Oct 2013 @ 02:59 PDTDatabaseReplyStats collection inside SP'sOn 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...
509 Oct 2013 @ 08:02 PDTDatabaseReplyTeradata 14 and REGEXP_INSTRok, 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...
409 Oct 2013 @ 07:40 PDTDatabaseTopicTeradata 14 and REGEXP_INSTRHi,   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...
309 Oct 2013 @ 04:29 PDTDatabaseTopicTimestamp wit time zone conversioHi,  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 ...
206 Oct 2013 @ 07:22 PDTDatabaseReplyPrimary index + Partition Key + single AMP operationOk, 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 ...
106 Oct 2013 @ 03:34 PDTDatabaseTopicPrimary index + Partition Key + single AMP operationHi 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...