#DateForumTypeThreadPost
365307 Apr 2015 @ 03:45 PDTDatabaseReplyincrease teradata database size from 4GB to 10GBTeradata Express has a fixed size, you can't increase it. TD13 is a very old release, is this still a Windows version? You should download a decent release (40 GB) running as a virtual machin...
365206 Apr 2015 @ 03:21 PDTDatabaseReplyRollup up specific columns in a group  You need to seperate the rollup select and then join to it, but a recursive view cna't be used in another view (as you already noticed). Is there a known maximum number of rows per ID?...
365106 Apr 2015 @ 03:13 PDTDatabaseReplyLoading to the same target table simultaneously#1: The data is already in the system, so why trying to use TPump? #2/#4: INSERT/SELECT and MERGE always applies a table lock, so the jobs will insert sequentially #3: Unless it's a PI-based ...
365006 Apr 2015 @ 03:06 PDTDatabaseReplyDeadlock on DBC.USERRIGHTSA deadlock on dbc.AccessRights will only happen when multiple sessions for a single user create/drop objects. A single BTEQ job using multiple session will not deadlock on dbc.AccessRights, but mi...
364906 Apr 2015 @ 03:02 PDTDatabaseReplyNeed to convert Rows to columns Based on your example/result I don't get what you want, probably some SUM(CASE...) 
364806 Apr 2015 @ 03:00 PDTDatabaseReplyHow to find the Object IDs form DBC where it is stored.dbc.tvm shows the object's tvmid and databaseid, but the the row's ROWID is normally not shown (has been switched off since Vr25) and there's no LockId at all.   It's still t...
364706 Apr 2015 @ 02:54 PDTDatabaseReplygenerate unique values for set of input fieldsHi Moutusi, the SHA algorithm must be installed as a UDF (similar to MD5): http://forums.teradata.com/forum/extensibility/sha-2-udfs-for-teradata
364606 Apr 2015 @ 02:50 PDTDatabaseReplyNeed help on converting timestamp to date and integer columnHi Deepak, just reverse Carlos' logic :-) select cast(ts as date) ,extract(hour from ts) * 100 + extract(minute from ts) from tab  
364506 Apr 2015 @ 02:46 PDTDatabaseReplyHow to get PPI/PI/SI usecountHi Samir,  WITH USECOUNT not only logs info about stats usage, it's also about access on database/table/column/index-level. This info is stored in dbc.ObjectUsage and several views acces...
364403 Apr 2015 @ 12:28 PDTDatabaseReplyGrant users to execute DML on their own tablesHi Abhishek, only grant the CREATE right on database level to the users and remove all other rights on a database level. The Creator of an object automatically gets all rights.
364302 Apr 2015 @ 01:17 PDTDatabaseReplygenerate unique values for set of input fieldsHi Moutusi, you need unique but consistent values, (1,2,3) should always return the same value? Then you should trust MD5 or SHA256/512 to return 99.999999... % unique values or use all three col...
364202 Apr 2015 @ 01:02 PDTDatabaseReplyQuestion on Randomized allocationHi Valeria, you could switch 0 and 1 like this (not random, but based on odd/even ABGLKEYs): SELECT ... , (CASE WHEN PERCENT_RANK() OVER (PARTITION BY ABGLKEY ...
364102 Apr 2015 @ 09:18 PDTDatabaseReplyQuery Rewriting.Stats might be up-to-date, but at least one on VP_SEM.CNL_DIM.DWH_STATUS is missing, DIAGNOSTIC HELPSTATS ON FOR SESSION; will reveal this. The estimates are horrible, what's th...
364002 Apr 2015 @ 09:04 PDTDatabaseReplyEnforce row count in a tableYou could use a trigger or add a dummy column: col NOT NULL UNIQUE DEFAULT 1 CHECK (col = 1)
363902 Apr 2015 @ 09:01 PDTDatabaseReplyHow to find the Object IDs form DBC where it is stored.Can you explain in detail what you're trying to achieve? Which objects? TablesViews/etc.? DBC.tvm holds the TVMIds, but the DBC views don't show them.
363802 Apr 2015 @ 08:58 PDTDatabaseReplyTune queryWhy do you care about the estimated time?  Did you check the actual numbers in the QueryLog? Based on the explain everything is fine. The join is on the PI-columns, followed by a redistribu...
363702 Apr 2015 @ 08:45 PDTDatabaseReplyTeradata concurrency controlHi Sriram, how are those Inserts processed, a single transaction or one transaction per table? Does the process only Insert or also Selects from those tables?   All locks within TD are alw...
363602 Apr 2015 @ 08:29 PDTDatabaseReplygenerate unique values for set of input fieldsHi Moutusi, will this be done as a one-time update or whenever there's a row inserted? Can you provide more details, e.g. DDL & sample data, number of rows, is this a batch load?
363502 Apr 2015 @ 08:26 PDTDatabaseReplyHow to get min and max value in a single olap query using ROW_NUMBER in teradataIs this a production system or a TD EXpress? If it's production your DBA should open an incident with TD's customer support.   This will return the same result, but will need two ST...
363402 Apr 2015 @ 08:14 PDTUDAReplyto check is a string is numeric or notHi Dips, this will fail if the string starts with a digit, e.g. '1qwertzuiopü+?' will pass. What's your Teradata release? There are several ways in TD14: WHERE REGEXP_SI...
363302 Apr 2015 @ 08:05 PDTGeneralReplyIs there a way to avoid NOT IN function It might be "common notion" in other DBMSes, but Teradata rewrites both NOT IN/NOT EXISTS to joins, too. The LEFT JOIN/NOT NULL might be more efficient in some rare cases (depending on th...
363202 Apr 2015 @ 08:03 PDTDatabaseReplyHex to Char conversionHi Abhishek, what's your Teradata release? Since TD14 there are two new functions for Hex/Byte conversions. If the characters in the Hex-string are ASCII you can use this: FROM_BYTES(TO_B...
363131 Mar 2015 @ 09:23 PDTGeneralReplyIs there a way to avoid NOT IN function Simpy compare both Explains, if there are any NULLable columns you'll find aggregate steps (to check for NULLs) and steps with "skip this step if NULLs exists" for NOT IN.  NOT ...
363031 Mar 2015 @ 09:15 PDTDatabaseReplyHow to get min and max value in a single olap query using ROW_NUMBER in teradataWhat's your TD release? Assuming that a simple MIN/MAX/GROUP BY(ds_id) is not enough this will work with a single STATS step in TD14.10: SELECT ds_id ,Version ,FIRST_VALUE(Version...
362927 Mar 2015 @ 03:28 PDTDatabaseReplyHow to find if a varchar field has 9 digit intergersWhat's your exact TD release, TD14? Is the source defined as LATIN or UNICODE?   There have been some bugs regarding the RegEx functions, this should have been fixed in recent patch lev...

Pages