171 | 14 Jun 2007 @ 11:43 PDT | Database | Reply | GROUP BY and WITH...BY clauses may not contain aggregate functions ? | True. If you want the "empty return" behavior, you can use GROUP BY just as long as the expression is not a simple integer constant. That case has special meaning in Teradata. You could use a non-... |
170 | 13 Jun 2007 @ 11:35 PDT | Database | Reply | GROUP BY and WITH...BY clauses may not contain aggregate functions ? | When you say "GROUP BY 1", the 1 refers to the first expression in the SELECT list, namely COUNT(*), which is why you get this error. If all the expressions are aggregates you can just omit the GRO... |
169 | 09 Jun 2007 @ 12:44 PDT | Tools | Reply | Queue on CPU and Resusage Table | No, this would be processes (which might be AWTs) waiting in the OS dispatcher queue for their next CPU time slice. It's not directly related to messages waiting for an AWT to pick one up and start... |
168 | 06 Jun 2007 @ 11:23 PDT | Third Party Software | Reply | V2R6 EXAMS | Logical next move would be to actually release Teradata 12.0, and some time after that to modify the exams to reflect the new feature / function. |
167 | 06 Jun 2007 @ 11:20 PDT | Tools | Reply | FSP=0 and Mload | Yes, it will attempt to allocate a new cylinder. If the number of free cylinders on the AMP approaches zero that could trigger minicylpack. |
166 | 05 Jun 2007 @ 07:47 PDT | Tools | Reply | FSP=0 and Mload | No, it doesn't fail. MLoad into a populated table ignores FSP (uses free space if there is any). |
165 | 02 Jun 2007 @ 09:58 PDT | Database | Reply | Teradata Space and Cylinders | A "cylinder" is a group of logically contiguous sectors in the Teradata hashed filesystem. See the manuals, e.g. Database Administration, for details. |
164 | 02 Jun 2007 @ 09:43 PDT | Tools | Reply | Queue on CPU and Resusage Table | (ProcReadySum / CollectIntervals) should give you an "average CPU queue depth" by node by log interval. Or SUM(ProcReadySum)/SUM(CollectIntervals) it you want to aggregate... |
163 | 30 May 2007 @ 11:00 PDT | Analytics | Reply | All virtual circuits are currently in use | How many IIS instances, and how many IP addresses / gateways is each using for Teradata connections? That's more likely to be the bottleneck than number of PEs.Are you using specific IP address, a ... |
162 | 30 May 2007 @ 10:43 PDT | Connectivity | Reply | trying to connect to SQL 2005 DTS | Not Teradata specific, but did you set PersistSecurityInfo property to True for the connection? |
161 | 30 May 2007 @ 10:36 PDT | Database | Reply | Required the book TERADATA ORANGE BOOK : Partition Primary Index Usage | Orange Books can be downloaded from Teradata @ Your Service. |
160 | 18 May 2007 @ 03:20 PDT | Database | Reply | Dates In Decimal Format | Integer arithmetic is cheaper than string manipulation or FORMAT conversion:SELECT CAST((1000000+(IntDate MOD 100)*10000+IntDate/100) AS DATE)FROM (SELECT CAST(112207 AS INTEGER)) x(IntDate);Or if ... |
159 | 14 May 2007 @ 10:51 PDT | Tools | Reply | Missing records | You say you selected FASTLOAD? FastLoad always quietly eliminates totally duplicate rows. If you really need to load duplicate rows to a MULTISET table you should use some other method, e.g. MultiL... |
158 | 14 May 2007 @ 10:47 PDT | Database | Reply | Collect stats index vs multiple columns: advantages? | If there is a corresponding index, the action taken by the database is identical regardless of which syntax you use. The only time it matters is if you first collect stats on multiple columns and l... |
157 | 09 May 2007 @ 10:30 PDT | Connectivity | Reply | TIMESTAMP in UDF | Did you look at the supplied sqltypes_td.h? TIMESTAMP is a struct rather than a simple type... |
156 | 08 May 2007 @ 11:38 PDT | Database | Reply | out of spool | Each user has a spool space limit, stated as a system-wide limit but enforced as a proportional limit on a per-AMP basis. "No more spool space" does not mean that there is no free space left on the... |
155 | 08 May 2007 @ 11:23 PDT | Database | Reply | Fastload via Teradata Client | Try :start_date (date, format'yyyymmdd')etc. |
154 | 19 Apr 2007 @ 12:23 PDT | Tools | Reply | Creating a new Table | And you generally should also specify a PI, otherwise it will default to NUPI on the first column only. |
153 | 16 Apr 2007 @ 09:51 PDT | Database | Reply | Prior week from current date | Or if you care about the time of day WHERE ORDER_CREATE_DT >= CURRENT_TIMESTAMP - INTERVAL '7' DAY |
152 | 09 Apr 2007 @ 01:34 PDT | Database | Reply | not able to release mload lock | You should always attempt the RELEASE MLOAD before you drop anything. That way if you get 2572 you can decide if you want to restart the MLOAD and allow it to complete or if you really want to abor... |
151 | 03 Apr 2007 @ 11:11 PDT | Connectivity | Reply | Unable to find compiler for CREATE FUNCTION | Sort of... The help file on the demo CD says you need VS / VC++ 6.0, but does not give details as to why or what you might do if you don't have that exact version available. |
150 | 03 Apr 2007 @ 11:43 PDT | Connectivity | Reply | Unable to find compiler for CREATE FUNCTION | I believe the V2R6.1 demo is still looking specifically for Visual C++ / Visual Studio 6.0 registry keys. See this thread for a possible workaround: http://www.teradataforum.com/teradata/20040720_1... |
149 | 03 Apr 2007 @ 11:27 PDT | UDA | Reply | Encryption or masking of data at DB Level!!!! | Masking can be done with a view. Encryption would require a UDF; there are third-party vendors that partner with Teradata to provide such features. |
148 | 29 Mar 2007 @ 01:41 PDT | UDA | Reply | Need information on end of life support for Teradata V2R6.01.00.00 | Log on to Teradata @ Your Service and you'll find the current "maintenance schedule" under the Roadmaps heading.You don't say what exactly you mean by "end of life"; but for V2R6.1.0, the answer wo... |
147 | 23 Mar 2007 @ 12:21 PDT | Connectivity | Reply | libmqmcs.so missing | Those libraries are part of WebSphere MQ client install. Teradata's MQ Access Module is an interface between IBM's client code and Terdata's utilities. |