#DateForumTypeThreadPost
6605 Sep 2013 @ 03:06 PDTDatabaseReplyCreating Group ID from SUM LimitChange your running sum to order on QtySold.  Join that result to SELECT SUM(QtySold) AS GrandTotal FROM Prod_List.  Replace your CASE expression with (running/GrandTotal) DIV <#of b...
6522 Aug 2013 @ 03:16 PDTDatabaseReplyCombining multiple rows into a single rowSELECT cust_id, name, max(age),max(telno),... GROUP BY cust_id, name; Hopefully there is some way to identify which rows are new so that these don't get coalesced with prior rows for a cu...
6422 Aug 2013 @ 01:21 PDTDatabaseReplyRefreshing View?It's a feature! If you do not replace the view, the applications using it are unaffected by the changes to the underlying table definitions.
6308 Aug 2013 @ 08:43 PDTDatabaseReplyTeradata database restart?Yes. Performance degradation only between the two restarts of course.
6207 Aug 2013 @ 09:17 PDTDatabaseReplyTeradata database restart?Good question - I did not comment on the return to service part... If there is a standby node, then when the failed node is repaired it is returned to the configuration automatically as the new st...
6107 Aug 2013 @ 05:54 PDTGeneralReplyQuery disobeying conditions?The form of CT you are using tries to inherit the type of the columns in the select. But you can specify the columns just like in a regular CT: CT account_services (Account_number <data type>...
6007 Aug 2013 @ 04:11 PDTDatabaseReplyTeradata database restart?When a node fails - that is not currently a spare node - Teradata will restart no matter what the configuration. If hot spare is available, then the AMPs from the failed node will move to the hot ...
5907 Aug 2013 @ 02:20 PDTDatabaseReplyImproper column reference in the search condition of a joined tableThe ON clause may only reference the two tables on either side of the JOIN clause. To reference other tables you must put those conditions in a WHERE clause.
5806 Aug 2013 @ 09:00 PDTGeneralReplyQuery disobeying conditions?I guess you will have to define the columns in the create table statement with the datatypes.  The MAX is required to allow all the flags to be grouped onto one row for the account. 
5706 Aug 2013 @ 05:21 PDTGeneralReplyQuery disobeying conditions?The semantics of your question are not clear to me. Do you want accounts set to 'HMI' IFF the account has each of those attributes and no other attributes? the subquery you have does not a...
5625 Jul 2013 @ 04:12 PDTDatabaseReplyCan I do select from fallback table?What you are describing is all automatic in Teradata. If an AMP is down, and fallback is in place, then the query automatically reads the fallback copy and reads all current data. If updates are pe...
5527 Jun 2013 @ 02:32 PDTDatabaseReplyCommon Table Expression Within ViewWhat release are you running? This capability was allowed in TD14.0 and future releases.
5404 Jun 2013 @ 07:28 PDTGeneralReplySame hash for different valuesThis actually demonstrates an interesting property of the Teradata hash function. Providing the same values in a different order will result in the same hash - on purpose. This makes it possible fo...
5302 May 2013 @ 01:06 PDTDatabaseReplyHybrid columnar automatic formatTeradata does not automatically determine if a table should be row format or column format. That needs to be specified by the DBA at physical table definition time. The examples you provide show a ...
5202 May 2013 @ 12:55 PDTDatabaseReplytuning the Skewed joinsTry first with stats on the column. The extremely skewed values can be dealt with by the optimizer by creating alternate plans. If that does not work, then follow Dieters advice.  Hint: if yo...
5130 Jan 2013 @ 09:38 PSTDatabaseReplyCan we access a table from SQL UDF in TD 14?A SQL UDF is only allowed to perform an expression and return the result. A Select is not allowed in a SQL UDF.
5016 Jan 2013 @ 08:55 PSTDatabaseReplyProvisioning more spaceIt is possible to add disk to an existing configuration if the physical configuration has room. The disks are physically added to the platform and the TVS subsystem is told about their existence. T...
4916 Jan 2013 @ 08:33 PSTDatabaseReplyTeradata Table Naming It is currently intended that Teradata 14.10 due out later this year will increase this limit. As always, this is not a promise, only the official release content documentation can describe the act...
4816 Jan 2013 @ 08:30 PSTDatabaseReplyIncrease the size limit of teradata objects name from 30 characters to more.It is currently intended that Teradata 14.10 due out later this year will increase this limit. As always, this is not a promise, only the official release content documentation can describe the act...
4704 Jan 2013 @ 10:29 PSTPrivate Forum
4623 Dec 2012 @ 01:04 PSTPrivate Forum
4521 Dec 2012 @ 08:39 PSTDatabaseReplyTransposed multiple rows into one column and one rowThis is also an application for an aggregate UDF that concatenates each sucessive sucessive value that it is presented, returning the concatenated string.
4416 Dec 2012 @ 11:08 PSTPrivate Forum
4314 Dec 2012 @ 02:24 PSTPrivate Forum
4214 Dec 2012 @ 01:46 PSTDatabaseReplySET & Multiset TablesThis is a good disucssion and a common question. It has become common to use multiset or unique index/constraints to avoid duplicate row checks. However, this can be overdone. If a NUPI has a reas...

Pages