#DateForumTypeThreadPost
13205 Mar 2015 @ 08:23 PSTDatabaseReplyIssue in updating a table in Sql assistantYou've got alpha or alphanumeric data in column C2, and your cast is failing when it encounters untranslateable data.
13103 Mar 2015 @ 10:10 PSTDatabaseReplyTeradata String Manipulation, Extract String from a text field.Blue, What you need to do is consider your initial substring component as a unit of string and repeat what you've done to the raw column again.  Yeah, i know clear as mud... Consider if ...
13003 Mar 2015 @ 06:56 PSTGeneralReplyStored Proc In Teradata For Calculated Fieldstart by looking at the sys_calendar.calendar view.  You should be able to fashion a case statement using the dates in your table along with the day_of_week column in the calendar view.
12921 Feb 2015 @ 07:30 PSTGeneralReplyHow to get unique ID for the concurrent jobsVani, Can you post the explain plans?  At first blush, dropping the stats should exhibit more expensive queries, longer duration and locks as TD tries to complete your join requests.  Th...
12821 Feb 2015 @ 07:22 PSTGeneralReplySuggest me which query to useRun an explain on each construct and see which one is less expensive.  At first glance it looks like the output should be identical, but that's up to the optimizer.   The data volume ...
12712 Feb 2015 @ 12:58 PSTDatabaseReplyImproving indexing on Balance Tracking table Before you rule out anything, check the explain to see if there is any improvement.  You might also try a JI across these two tables to "pre-join" them
12612 Feb 2015 @ 08:16 PSTDatabaseReplyRemove duplicate records and load into another tableYou have to remember that the hours, minutes, seconds in an explain plan are pronounced KOST.  There is no relevance to wall clock time.  Those measure labels in the explain plan are labe...
12511 Feb 2015 @ 07:34 PSTDatabaseReply[Teradata Database] Numeric overflow occurred during computation.Unable to get catalog string. Connection StringI suspect that Hemanth is on the right track or your join condition is incomplete, causing a cartesian product somewhere...  
12411 Feb 2015 @ 07:32 PSTDatabaseReplyRemove duplicate records and load into another table insert into newtable select min(key_id) ,process_data_month ,data_source_id ,data_source_code ,logical_data_source_code ,geography_code from oldtable group by ...
12311 Feb 2015 @ 05:43 PSTDatabaseReplyFunctions in Join ConditionsYou're forcing spool either way, check the explain plan for each query.  I think they're both going to be rather ugly.
12209 Feb 2015 @ 10:07 PSTGeneralReplyhow hash value is calculated or AMP is chosen for new rowThe value of the hash is independent which amp the row ends up.  There is a hash map that determines what hash results map to which amp.   If you have a system with 240 amps and a table ...
12106 Feb 2015 @ 06:44 PSTAnalyticsReplyParallel Loads to same target tableYou can't load the same table with multiple jobs at the same time, the first job to run will get a write lock and the remaining jobs will queue up waiting for the preceding write lock to be rel...
12005 Feb 2015 @ 08:24 PSTDatabaseReply[Teradata Database] Numeric overflow occurred during computation.Unable to get catalog string. Connection StringKong, the only place you could be seeing a numeric overflow looks like the count(), in the query.  TD uses the integer data type and my guess is that you've exceeded the integer bound. &n...
11930 Jan 2015 @ 02:59 PSTDatabaseReplyhow to query large rows in Teradata SQL?loading via sql assistant is going to be painfully slow.  you need to put together a TPT script to load the file into a permanent table on your TD system, or use the TDLoad option for TPT, qui...
11829 Dec 2014 @ 07:44 PSTDatabaseReplyWhile refreshing the table.Sri, There are a couple of wasy to do this, depending upon whether or not your app is using a view (it should be, according to TD best practices).   presuming the table you want to refresh i...
11729 Dec 2014 @ 06:34 PSTDatabaseReplyWhile refreshing the table.Sri, In addition to RGlass' questions above...How big is the table? How many rows are you deleting? Are you using the PI values to select the rows for deletion? Are you deleting through a base...
11628 Dec 2014 @ 01:02 PSTDatabaseReplyGTT vs VTThe DB has to build the volatile table, that means interpreting the ddl and building the table, which is already done if you're using a GTT
11527 Dec 2014 @ 02:53 PSTDatabaseReplyGTT vs VTThe DDL that defines GTTs remains in the data dictionary.  This aspect of GTTs can save you system resources and dbc calls.  Everytime you create a volatile table, there are calls to the ...
11410 Dec 2014 @ 06:04 PSTDatabaseReplyDate data type Would you be so thoughtful as to post the DDL?
11310 Dec 2014 @ 06:02 PSTDatabaseReplySame old Untranslatable character you can use the output of the translate_chk function in combination with substring to trim out the errant character in a select statement. select substring(col from 1 to (translate_chk(col using l...
11230 Nov 2014 @ 07:46 PSTDatabaseReplyQUERY OPTIMIZATIONThe intermediate table is a waste of IO.  Bullet three is the key here, PI to PI joins, making the joins amp local are going to be key to this query.  You can also partition the sessions ...
11128 Nov 2014 @ 06:20 PSTDatabaseReplyFast Load - doesn't load duplicate records in multi set tableBy default, FastLoad eliminates duplicate records.  The entire row must be a duplicate, not just the PI, the entire row.  There is no way to retrieve the duplicate discards.   
11030 Sep 2014 @ 06:35 PDTGeneralReplyHOW TO FIND THE FIRST 20 WORST RUNNING QUERIES LISTS IN TERADATAor of course you could search these forums for articles like the following...http://developer.teradata.com/viewpoint/articles/killer-queries-track-them-find-them-fix-them Some other calculations o...
10911 Sep 2014 @ 10:14 PDTDatabaseReplyCreate View error - UDFCALLNAMETeradata doesn't allow you to use initial numerics to name an object.  The band-aid you've applied by adding the quote marks (") around the object name allow the view to be create...
10803 Sep 2014 @ 09:31 PDTDatabaseReplyGet Order skip the cast, extract etc... select blah, blah, blah, cal.quarter_of_year from yourtable yt inner join sys_calendar.calendar cal on (yt.orddt = cal.calendar_date); the system calendar has quarte...

Pages