All forum activity

#DateUserForumTypeThreadPost
5904209 Aug 2016 @ 08:58 PDTcrazyrama5DatabaseTopic Merge the continuous rows with date range( sequential rows should merge) Hi All,   Can somebody please help me with following scenario. I am looking for dynamic solution of SQL. Because number of rows are not static. CUST, OLD_ST_DT, OLD_END_DT, AMT1...
5904109 Aug 2016 @ 08:46 PDTfeinholzToolsReplyTPT load failure - Please suggestWhat version of TPTAPI have you installed? What version of CLI? This sometimes can occur when mismatching components are installed.  
5904009 Aug 2016 @ 08:46 PDTfgrimmerTeradata StudioReplyCode Assist functionality questionsThere is a menu option in the top level SQL Mmenu to toggle on Code Assist Autoactivation. It may be untoggled.
5903909 Aug 2016 @ 08:38 PDTBRIANHDatabaseReplyDBC - CURRENTPERM EXCEEDS MAXPERMHi Fred... sorry I took an extensive length of time to respond to you... fighting some gremlins... I reviewed the DBQL tables and they were fairly large, purged most of their contents and currentpe...
5903809 Aug 2016 @ 08:36 PDTstami27ToolsReplyTPT load failure - Please suggestI forgot to communicate the platform where the TUs are installed:  cat /proc/version Linux version 2.6.32-431.11.2.el6.x86_64 (mockbuild@x86-027.build.eng.bos.redhat.com) (gcc version 4....
5903709 Aug 2016 @ 08:36 PDTtejakandikonda86DatabaseTopicretrieve row count from Teradata MacroHi,   I have a Macro 'ABC' which would take one input parameter. I am executing the macro as execute ABC(?) through jdbc. This Macro returns results with column values. However I ne...
5903609 Aug 2016 @ 08:29 PDTfeinholzToolsReplyQueries for Teradata Fast Export Utility1. FastExport should be installed on the edge node. It should never be installed on the database server. 2. It has been shown that a max session count of 4 is generall the best setting, but you ca...
5903509 Aug 2016 @ 08:25 PDTfeinholzToolsReplyTPT export into AWS S3 buckets.We are currently developing an Amazon AWS S3 access module that will allow you to move data from S3 directly into Teradata (and vice versa) without landing the data to disk. It is not yet released....
5903409 Aug 2016 @ 08:20 PDTstami27ToolsReplyTPT load failure - Please suggestHello Steve We want to upgrade the RDBMS TD 15.10 soon. Prepared, I have installed the Linux Tools 15.10.01. ... tdodbc1510-15.10.01.01-1.noarch tptstream1510-15.10.01.03-1.noarch tpump15...
5903309 Aug 2016 @ 08:14 PDTGlassDatabaseReplyHow to do a random sample?Random sample will return different results each time. You could insert  results into a work table and join to that each additional time.   Rglass
5903209 Aug 2016 @ 05:42 PDTToddAWalterGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitionsAs you can see, optimizer combines multiple ordered analytic functions with the same partition and order into a single execution.   Two different ones are required because there are two d...
5903109 Aug 2016 @ 05:06 PDTjester666Teradata Database on AWSReplypkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0Address this issue by downgrading to python 2.6. If someone find solution for running tdc-init on Python 2.7, would appreciate your comment.
5903009 Aug 2016 @ 05:05 PDTrajezkumar11511ConnectivityReplyTeradata JDBC Connection FailureHi Tomnolan, I'm also facing the same issue when I tried to create a new connection profile Teradata studio express 15.  How can I check database is running in my system? and I'm usi...
5902909 Aug 2016 @ 04:34 PDTkrishna1985ToolsReplyCasting Date in Bteq utilitiesHi Team, can anyone let me know syntax to convert date as above in fastload instead of bteq plzz
5902809 Aug 2016 @ 03:15 PDTMohank1006TrainingReplyImmediat TERADATA Online training available...,Interested people drop a mail @navench@gmail.comHi All, Good day. This is Mohan, and I joined in this group just now.   Br, Mohan
5902709 Aug 2016 @ 02:53 PDTArpan.RoyAsterTopicload_from_hcatalog --- error while selecting Varchar,Date,Timestamp column Hi All, We are trying to read data from Hive table and load into teradata table after lots of transformation. So, we are trying to use "load_from_hcatalog". But while selecting dat...
5902609 Aug 2016 @ 02:35 PDTCescoDatabaseReplyUser's DDLThank you all for your answers. Unfortunatly, in my company we can't use the "Teradata studio", but I can obtain all the informations I need from DBC.logonrules, DBC.users and using ...
5902509 Aug 2016 @ 01:38 PDTPriti_KanalDatabaseTopicNumeric overflow occurred during computation in Teradata Stored procedure INSERT INTO TGT SELECT DECIMAL_C1, DECIMAL_C2, MAX(CAST(DATE_C3 AS DATE)) AS MAX_DATE_C3, MAX(CAST(TIMETSAMP_C4 AS TIMESTAMP(6))) AS MAX_TIMETSAMP_C4 (     SELECT&nb...
5902409 Aug 2016 @ 01:08 PDTDan95AsterTopicCode Assist not workingHi, I'm trying to use code assist for displaying a list of table after writting my database name. However code assist is not working, i'm on teradata studio express v15.11, any help ? -&g...
5902309 Aug 2016 @ 12:58 PDTDan95Teradata StudioReplyCode Assist functionality questionsHi, I have some problem with code completion, when writting database. i'm not getting a list of table. Is it working on teradata studio express v15.11 ? Thanks a lot, Dan
5902209 Aug 2016 @ 12:31 PDTPrivate Forum
5902108 Aug 2016 @ 11:01 PDTSoumyatgGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitions We do an all-AMPs STAT FUNCTION step from Spool 2 (Last Use) by      way of an all-rows scan into Spool 6 (Last Use), which is assumed      to be redistr...
5902008 Aug 2016 @ 10:38 PDTkrishna1985ToolsTopicCasting Date in Bteq utilitiesHi Team,   I am new to Teradata  and I have a requirement to load the data FROM EXCEL using BTEQ UTILITIY. However as far as I know we cannot load data from excel but can load in CSV fo...
5901908 Aug 2016 @ 09:10 PDTVandeBergBTrainingReplyNeed help to find out Teradata certification materialRead the manuals, get some experience and learn for yourself via hands on experience.  Just passing the test has zero value in the real world. If you can only regurgitate the manuals without ...
5901808 Aug 2016 @ 07:06 PDTYunfei ZhaoDatabaseTopicHow to do a random sample?I want to do a simple random sample in Teradata. I have a table, My_Table, it has 2 columns, SSN and Tran_ID. This is for a bank, like Citibank, which has millions of customers (SSN), and...

Pages