#DateForumTypeThreadPost
81626 Aug 2016 @ 10:49 PDTDatabaseReplyEXPORTING SELECT QUERY OUTPUT TO A TEXT FILEWriting in uppercase is sometimes considered as crying loud and not the best habit in forums ;-)... The most important info is missing in your post - which utility / tool do you use to run this qu...
81511 May 2016 @ 04:41 PDTPrivate Forum
81410 May 2016 @ 07:16 PDTPrivate Forum
81304 Apr 2016 @ 08:01 PDTTeradata Database on AWSReplyStop and re-start a TD AWS instanceHi cr255015, yes, just saw it also in the documentation.  So this is the choice to be maid - keep the DB / data but pay for the EBS storage or start always from scratch.  Will try the ...
81204 Apr 2016 @ 06:19 PDTTeradata Database on AWSTopicStop and re-start a TD AWS instanceIs it possible to stop an AWS TD instance and restart it again with up an running DB. When I try TD DB is no longer responding. Is the DB file system deleted once the instance stops - I get a &quo...
81104 Apr 2016 @ 06:15 PDTTeradata Database on AWSReplyMy instance is hung in “shutting-down” state. How do I stop or terminate it?did you try to terminate it from the AWS console?  If yes, did you refresh the browser?
81004 Apr 2016 @ 04:59 PDTTeradata Database on AWSReplyHow do I SSH into my EC2 instance via a command line?ssh -i /path/to/your/keyfile ec_user@Your_Public_DNS  
80904 Apr 2016 @ 04:55 PDTTeradata Database on AWSReplyHow do I create additional key pairs for users?Not to my knowledge - once aws keypair is bound to the instance. But once the system is up and running you can configure the standard ssh keyless access with additional public keys.
80815 Feb 2016 @ 04:40 PSTPrivate Forum
80704 Feb 2016 @ 12:42 PSTDatabaseReplyEquivalent sentence in Teradata for the Oracle "CONVERT"?Not sure that this will work in TD - not all character sets are supported. Usually you store international data as unicode. Did you check the Translate function? Depending on you DB release you c...
80604 Feb 2016 @ 12:37 PSTDatabaseReplyFind Only DuplicatesI don't think you will have much other options the the big group by or the row_number() with big partition. Sorted export and doing the check via an external program will also require huge res...
80504 Feb 2016 @ 11:59 PSTDatabaseReplyUnstable explain planUsualy you find this kind of behaviour in case of missing / stale stats. And the cost based optimizer might decide to chose a different plan in case the demographics change. To an extreme one sing...
80425 Jan 2016 @ 02:28 PSTDatabaseReplyLong Parsing IssueSame point as Fred mention. In case of large CPU times - check the complexity of the SQL by running "show select...". Depending on the DB release there had been issues with the existance...
80325 Jan 2016 @ 02:15 PSTDatabaseReply2616: Numeric overflow occurred during computation.Can't also believe - how do these limitations fit to the scalabilty ability of the HW? If there are concers on the backwards compatibility this can be handled via dbc.control fields... It is ...
80207 Dec 2015 @ 03:42 PSTTeradata ApplicationsReplyTerdata BTEQ script ERROR:Can you als run a   bteq  with no input from the shell.  You should see something like  Teradata BTEQ 15.00.00.03 for Mac OS X. PID: 23275  Copyright 1984-2015, T...
80130 Nov 2015 @ 05:04 PSTDatabaseReplyAvoiding Duplication on All AmpsDo you have stats collected on ColumnX on both tables?
80030 Nov 2015 @ 05:00 PSTDatabaseReplyHow to populate max value rows with in the group by eliminating the min valuesmaybe but more complicated - you need some kind of product join - and won't get the same performance. Why don't you want to use the OLAP function?
79930 Nov 2015 @ 04:45 PSTDatabaseReplyHow to populate max value rows with in the group by eliminating the min valuestry the following - pseudo code not tested against the DB   select id, startdate, enddate, rate from yourTable qualify rate > max(rate) over (order by start_d...
79820 Nov 2015 @ 06:26 PSTDatabaseReplyHelp in Ordered Analytic FunctionsOn which version of TD are you? Check if you can use the TD_NORMALIZE_... functions  they should do what you want. Source for information: SQL Functions, Operators, Expressions, a...
79720 Nov 2015 @ 06:19 PSTDatabaseReplyDerived table efficiencyAre your stats correct? Are stats defined? Can you share the explain?
79618 Nov 2015 @ 07:05 PSTDatabaseReplyAuto E-mail to the end user after creation of userHi, I guess doing this via a script is the easiest way. The Teradata Python module would be a good choise for this. It allows you easy SQL generation, SQL execution and further processing (like s...
79518 Nov 2015 @ 01:50 PSTConnectivityReplyConnecting from R via RJDBC and terajdbc4.jar failscan you share your code you are using?
79413 Nov 2015 @ 12:14 PSTDatabaseReplyAlternate Solution to Self Joincheck the row_number() function in the SQL manual
79311 Nov 2015 @ 06:45 PSTViewpointReplyAlternative to Viewpoint?Hi, I am not sure how this affect the Viewpoint portlet, but the data labs are normal databases.  A good way to move space is: CREATE DATABASE SPACEMOVE FROM B AS PERM = 100000000000; ...
79209 Nov 2015 @ 12:15 PSTDatabaseReplyMinus Vs ExistsIn case of multiset tables your assumption should be that duplicates can exists. The DB will not prevent it... You need real strong hash functions like SHA-256 to avoid the hash collisions. As sta...

Pages