#DateForumTypeThreadPost
9126 Mar 2014 @ 11:51 PDTDatabaseReplyHelp with creating a Case within an In statment within a CaseIf this is a short list, then doing it in a case expression is fine, but I have often seen the case expression get way out of hand with hundreds or thousands of things to match. If your case is hea...
9031 Dec 2013 @ 12:20 PSTDatabaseReplyTable PartitionWhen the partitioning expression is very complicated, the optimizer cannot see through it to see that the partition access can be done. This is especially true for multiple casts. If you change th...
8911 Dec 2013 @ 03:09 PSTAnalyticsReplyWhile we add New AMPThe RowIDs do not change when AMPs are added. A new hasmap is created to balance hashbuckets across the new configuration of AMPs, then rows within buckets that have moved are moved to their new AM...
8811 Dec 2013 @ 02:50 PSTPrivate Forum
8702 Dec 2013 @ 07:35 PSTUDAReplyCancel Rollback on a table with referential integrityIt sounds like the additional couple weeks would be much smaller resulting in a much shorter update time and a much shorter rollback time if the work is aborted.
8602 Dec 2013 @ 07:16 PSTUDAReplyHot Standby NodesOne HSN is attached to each clique, there is no IO cross connection between cliques which means that an HSN can only serve node failures within the clique to which it is connected.
8529 Nov 2013 @ 02:00 PSTUDAReplyRelay Services GatewayRSG is there in the base Teradata software. It needs to be configured and initialized as part of installing MDS.
8429 Nov 2013 @ 01:56 PSTUDAReplyHot Standby NodesHot standby nodes are not offered with those platforms. Only with 6xxx and 1xxx platforms.
8329 Nov 2013 @ 01:52 PSTUDAReplyAppliance 2690 No, there are specific limits to the disk IO cabling that control the clique configurations.
8229 Nov 2013 @ 01:48 PSTUDAReplyLogical Clustering of ampsNot sure what clustering you are referring to. The configuration of the AMPs on the system is done at system install or HW upgrade time and is implemented by Teradata during the staging process.
8129 Nov 2013 @ 12:52 PSTUDAReplyCancel Rollback on a table with referential integrityThe select does not affect the insert. It does suggest that the target table is not empty since it is not going to do anything when the table is empty. It will cause the intermediate result to be s...
8028 Nov 2013 @ 08:54 PSTGeneralReplyCollecting StatsStats on this column are strongly indicated if the column is used in the where clause regularly. If you do not have stats, the optimizer will assume approximately 5% selectivity which will be far o...
7928 Nov 2013 @ 08:44 PSTUDAReplyCancel Rollback on a table with referential integrityYou didn't mention how you were doing the loading? An Insert Select into an empty table should be a fast rollback. A tpump style load should be a short rollback because each PACK is committed....
7821 Nov 2013 @ 06:27 PSTDatabaseReplyTypes of locks during Fastload abort-?The status is in the target table and the error, log tables. they are all tied together internally. Unfortunately the status cannot be seen in the dictionary with a query. A list of tables in this ...
7721 Nov 2013 @ 04:47 PSTDatabaseReplyTypes of locks during Fastload abort-?HUT locks are for ARC backup/restore only. This is the only kind of lock in Teradata that persists when there is not a job running. The lock is left if the job does not finish normally so that...
7618 Nov 2013 @ 12:01 PSTDatabaseReplyTypes of locks during Fastload abort-?Technically, there are no locks when Fastload or Multiload are not running - if the job has aborted or been halted prior to finishing. There is a status recorded in the table that says that the tab...
7501 Nov 2013 @ 03:20 PDTGeneralReplyQuerybanding in Oracle,SQL server,Db2Oracle has a similar function to queryband, can't remember the name at the moment. It is used particularly in the session pool area. Spelled differently of course but similar goal.
7401 Nov 2013 @ 09:33 PDTDatabaseReplyIdentifying HOTAMP / COLD AMPThere is no such thing as a hot amp or a cold amp. Teradata's multi-temperature storage has hot and cold storage on every AMP (varies depending on platform family member, platform generation). ...
7331 Oct 2013 @ 03:04 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]"There can certainly be rows that are not unique per any uniqueness definition on the table within the first 1000 rows - or a constraint violation or a bad date or ... .  But until we know the ...
7231 Oct 2013 @ 02:17 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]"A SQL error such as uniqueness violation can get worse over the insert of more rows if there are duplicates in the source data. The first rows will all go in fine but as you get further along, more...
7111 Oct 2013 @ 10:08 PDTDatabaseReplyCasting to An integer giving incorrect result.This has been addressed in 14.10 and works properly there. Prior - we take the string and put it into floating point. Floating point is an imprecise representation when there is a very long mantis...
7003 Oct 2013 @ 02:38 PDTDatabaseReplywhat happens when you drop a table that is used in a running insert query?The insert select statement was probably sitting in a TASM throttle queue and had not yet started to execute.
6902 Oct 2013 @ 04:20 PDTDatabaseReplyproblem joining on imported unix columnCould you share the column definitions from the table? I'm wondering about differences in character set, upper/lower case attributes,...
6819 Sep 2013 @ 02:59 PDTDatabaseReplyRights on View and macro and underlying tablesIf the user is allowed those operations then it means that the owner of the view or marco has both the appropriate rights on the underlying table and WITH GRANT OPTION to be able to pass those righ...
6706 Sep 2013 @ 05:26 PDTDatabaseReplyCreating Group ID from SUM LimitThis is missing the join to and division by the grand total. That is necessary in order to make the running sum a percentage contribution.  And I left off the multiplication of that result by ...

Pages