All forum activity

#DateUserForumTypeThreadPost
5781616 Jun 2016 @ 05:44 PDTBlamey4DatabaseReplyTime Difference from previous row Hi Dieter - Thank you for helping! In our database the date and time columns are serperate columns; The date column is data type [DATE] and the time columns is data type [VARCHAR(8)] so the value...
5781516 Jun 2016 @ 05:21 PDTSramDatabaseReplyFastload not picking decimal valueHi, iam loading from file to table, where table is having datatype varchar(100)
5781416 Jun 2016 @ 04:47 PDTh.r.thejas@gmail.comToolsReplyTDCH-TPT InterfaceI tried the example in the TPT User Guide but instead of wrting to hdfs it was writing to local eventhough i have set HadoopHost for the Dataconnector operator may be i have missed some other confi...
5781316 Jun 2016 @ 03:50 PDTM.Saeed KhurramDatabaseReplyFastload not picking decimal valueHi, In fact when you load a Decimal value to VARCHAR, it is truncated after the decimal point. Can you try with DECIMAL datatype in staging, e.g. DECIMAL(18,2). It will fix the issue. Br, Khurr...
5781216 Jun 2016 @ 03:21 PDTM.Saeed KhurramToolsReplyDownloading Previous versions of Teradata StudioHi, You must an account on Teradata Tays, from there you can get ay version of Teradata utilities. If you are on a customer site, then you can ask the customer to provide Tays account. Br, Khur...
5781116 Jun 2016 @ 02:27 PDTsk8s3iDatabaseReplyHow to parametrize WHERE IN clause in stored procedure?Thank you Dieter! It worked.   Copying my working code here for reference: REPLACE PROCEDURE mydb.mw_test_proc_k222 ( IN varList VARCHAR(200), OUT valOut SMALLINT ) BEGIN SE...
5781016 Jun 2016 @ 02:05 PDTsachinsDatabaseReplyDegraded Query performance while performing insertionHi Samir, I ran the command Diagnostic helpstats on for session on that query last week and found some collect stats as mentioned below required. So, accordingly I ran the collect stats below...
5780916 Jun 2016 @ 02:03 PDTCarlosALDatabaseReplypassing parameter to mload script and loading into target tableHi. Please provide the table DDL (at least the column datatypes) and the param.txt file. Cheers. Carlos.
5780816 Jun 2016 @ 01:41 PDTyuvaevergreenDatabaseReplyHow to group depending on number of recordsYou need to have an order by clause and group the records...Is that your exact requirement?
5780716 Jun 2016 @ 01:35 PDTJohannes VinkConnectivityReplyODBC performance on LinuxNo-one?
5780616 Jun 2016 @ 12:44 PDTgloxtonTeradata StudioReplyCode Assist functionality questionsMany Thanks for this Francine. In regards to Question 5, unchecking 'Always run in Background' just seems to stop this automatically running in the backgorund. The question I had was wheth...
5780515 Jun 2016 @ 07:19 PDTcr255014Teradata StudioReplyInstalling Teradata Eclipse Plugin Breaks running DTD againsdt other platforms?Below is Eclipse version that I am running.   Eclipse Java EE IDE for Web Developers.   Version: Mars.2 Release (4.5.2) Build id: 20160218-0600
5780415 Jun 2016 @ 06:12 PDTfeinholzToolsReplyTDCH-TPT InterfaceReading/writing from/to Hadoop files via HDFS are no different than accessing them from the local file system. You give us the name and the directory and the format. The only difference that is m...
5780315 Jun 2016 @ 06:09 PDTfeinholzToolsReplyProblems with multibyte tdload / TPT19134 !ERROR!Do you happen to know if that character is a 4-byte UTF8 character?
5780215 Jun 2016 @ 04:16 PDTfgrimmerTeradata StudioReplyCode Assist functionality questionsGreg, You are correct in your answers (1, 2, 3). As you have discovered, the code assist is trigger by a pause or Ctrl+SPACE or when entering a 'dot' on a SQL object in your SQL statement. ...
5780115 Jun 2016 @ 02:30 PDTamoyyangDatabaseReplycreate mutiple tables from an existing table with while loopHi Dnoeth, I SEE! I missed Cut&Paste&Run. Now, I get them. Thanks a lot! Sorry I am new in Teradata! But the actual query in each iteration is rather long. So I do like to try a Stored Pro...
5780015 Jun 2016 @ 02:12 PDTteradatauser2DatabaseReplyAlter table on huge tableHi, I never delved much deeper in Alter, as in our installation, we generally use drop recreate rather than alter. --samir
5779915 Jun 2016 @ 02:10 PDTteradatauser2DatabaseReplyDegraded Query performance while performing insertionFew of the basic things that you need to see are : 1. Run : Diagnostic helpstats on for session 2. Run the explain of the query, See if optimizer suggests you some stats. Plese collect the stats ...
5779815 Jun 2016 @ 01:41 PDTdnoethDatabaseReplyHow to group depending on number of recordsHow many groups? Based on a specific order?
5779715 Jun 2016 @ 01:39 PDTdnoethDatabaseReplycreate mutiple tables from an existing table with while loopWell, the query only returns 10 CREATE TABLE statements which need to be executed. Cut&Paste them to your query window and run them.   To do that in a loop you need a Stored Procedure, ...
5779615 Jun 2016 @ 01:35 PDTdnoethData ModelingReplyDoes Teradata have a probit or Normal dsitribution functionNORM.S.INV is the Cumulative distribution, there's no way to calculate an integral in SQL. A quick serach shows some solutions for SQL Server, which might be easily adopted to Teradata (lots o...
5779515 Jun 2016 @ 01:25 PDTauanupDatabaseTopicHow to group depending on number of recordsI have one doubt. Suppose my table contains 1000 records, I need to write a sql statement to group table in equal number of records.
5779415 Jun 2016 @ 01:24 PDTdnoethDatabaseReplyAsk help regarding to TOP, Rank and Partition Q1: yes, that's correct, you can easily test that Q2: if both time1 and time2 have a datatype TIME you can use (time1 -time2) hour to second, this will return an INTERVAL. Q3: I don'...
5779315 Jun 2016 @ 01:15 PDTdnoethDatabaseReplyFastload not picking decimal valueWhat's the datatype of the target column? Seems like it's truncated to an INT.
5779215 Jun 2016 @ 01:13 PDTdnoethDatabaseReplyTime Difference from previous rowBoth START_DTE_TME_EVB and EVENT_END_TME_EVB seem to be no timestamps, what's the actual datatypes? And your calculation looks way too complicated, can you show sone example data?&nb...

Pages