#DateForumTypeThreadPost
2111 Oct 2006 @ 06:06 PDTDatabaseReplywhether row hash changes when new nodes or Amp added?If you do a reconfig, you'll get a new Hashmap
2029 Aug 2006 @ 06:06 PDTToolsReplySecondary index SubtableIf you want to know the Diskspace size of your subtable(s) you can COLLECT DEMOGRAPHICS on the base table into a QCD of your choice
1929 Aug 2006 @ 06:00 PDTToolsReplySQL Qery Performance Problemwithout seeing the explain or the table stats, my first plan would always be to ditch the OLAP processing.
1823 Aug 2006 @ 08:21 PDTAnalyticsReplyAny function like Oracle "months_between"?If the dates of tenure are going to span one or more year-ends, then something like this might be quite groovy...select a.month_of_calendar - b.month_of_calendarfrom sys_calendar.calendar a cross...
1722 Aug 2006 @ 04:49 PDTConnectivityReplyCreating New User Defined FunctionsIf, instead of clicking on 'Discussion forums', you move down a bit and right a bit on the Teradata.Com page, you'll see a link to 'Drivers and UDFs'.You can pinch a pre-written UDF from there and ...
1622 Aug 2006 @ 01:16 PDTToolsReplyDate Format ProblemHow about this, which WILL work with ODBC...(courtesy of my mate Andy)..select cast(cast(date as date format 'YY-MM-DD') as char(8)) ;
1522 Aug 2006 @ 01:05 PDTToolsReplyDate Format ProblemAre you using SQL Assistant ? ODBC doesn't cope with Formatting.
1418 Aug 2006 @ 06:03 PDTAnalyticsReplyUpdate syntaxSomething like this would probably do ...UPDATE TMP1FROM TEMP_PRD.T_CST_SUB_DAILY_INFO_TEMP TMP1 ,(SELECT T_CUA_CUST_CODE , COUNT (*) AS CC_COUNT FROM TEMP_PRD.T_CST_SUB_DAILY_I...
1318 Aug 2006 @ 05:16 PDTUDAReplyLimitation ON Bteq ExportSorry mate, no idea.
1217 Aug 2006 @ 07:49 PDTUDAReplyLimitation ON Bteq ExportMP-RAS is the 'flavour' of UNIX used on the Teradat box. It's a bit old and has a 2GB limitation on the size of any files.Quick bit of maths makes me think you may indeed have hit the 2GB limit...2...
1117 Aug 2006 @ 01:28 PDTUDAReplyLimitation ON Bteq ExportAre you hitting the MP-RAS 2GB file limit ?
1009 Aug 2006 @ 07:43 PDTDatabaseReplyCancelling Rollback on a PPI tableFred,Thanks for your reply.ALTER in conjunction with adding/dropping partitions on a PPI table is perhaps a bit different to 'normal' DDL. There's a substantial amount of data deleted and inserted ...
908 Aug 2006 @ 10:40 PDTDatabaseTopicCancelling Rollback on a PPI tableJust aborted an Drop Partition/Add Partition Alter statement on a table with about 100M rows and 15 populated partitions (27 partitions in all).It's taking ages to abort, and is easily re-created, ...
820 Jul 2006 @ 11:53 PDTAnalyticsTopicUsing Statistics WizardWhen attempting to analyse a workload, I get the following message...[NCR][ODBC Teradata Driver][Teradata RDBMS] Statistics Analysis is not allowed when access logging is enabled. [15102]Is this an...
720 Jul 2006 @ 01:27 PDTUDAReplyCould I stop an abort session?oops..Alfredo,Do you have a friendly DBA around with access to the database window ?That's where you'll need to start the recovery manager.In the Supervisor screen of the database window, type 'sta...
620 Jul 2006 @ 01:25 PDTUDAReplyCould I stop an abort session?Alfredo,Do you have a friendly DBA around with access to the database window ?That's where you'll need to start the recovery manager.In the Supervisor screen of the database window, type (you'll n...
519 Jul 2006 @ 11:20 PDTUDAReplyCould I stop an abort session?Alfredo,If you mean that you have an aborting session and you'd like to kill the abort process, then yes, you can by using the CANCEL ROLLBACK option in Recovery Manager.Bear in mind though, you'll...
406 Jul 2006 @ 08:49 PDTDatabaseReplyDropping PPI partitionsVinay,Sorry, how rude, thanks also for your reply. There's nothing more dispiriting than having a forum posting ignored.Cheers
306 Jul 2006 @ 08:48 PDTDatabaseReplyDropping PPI partitionsDieter,Many thanks - I hadn't made the connection between having to have no NO RANGE when using WITH DELETE.The developers won't be happy though - they'll have to clean their data prior to loading ...
206 Jul 2006 @ 02:17 PDTDatabaseTopicDropping PPI partitionsAnybody had issues dropping PPI partitions ?We have a PPI table (3.2 Billion rows, 12 months data, partitioned by month). Lat night, a Prod job attempted to drop the oldest partition (approx 164 mi...
118 Apr 2006 @ 08:20 PDTDatabaseTopicINTEGER/BYTEINT accumulation and presentationComrades !I ran this query...sel aaa.Catgy ,sum(case when bbb.Catgy = 'splat0' then 0 else 1 end )as SL from ptemp.table_1 aaa left outer join ptemp.table2 bbb on aaa.Catgy = bb...