All forum activity

#DateUserForumTypeThreadPost
5826707 Jul 2016 @ 10:55 PDTfgrimmerTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listingIs the banks development server a sandbox vm?
5826607 Jul 2016 @ 10:54 PDTfgrimmerTeradata StudioReplyStudio Express severe keyboard lagAs you mention, the -data is to re-locate the workspace. Are you launching with -data? Where is your workspace created? By default, Studio Express will create the workspace in your %HOMEDRIVE%%HOME...
5826507 Jul 2016 @ 10:38 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagI noticed the following.  Curious as to whether any of these values look right and could be causing the keyboard lag, considering that I'm running on a 64-bit Windows computer.  I obv...
5826407 Jul 2016 @ 10:26 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagI've been connecting to Teradata v. 15.10.1.08.
5826307 Jul 2016 @ 09:41 PDTkchinnadTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listingHi Fgrimmer, My port number is correct. I verified it in ambari. I'm able to run hive queries via Hive command line. I'm using banks development server set up by hortonworks team. Please ...
5826207 Jul 2016 @ 09:20 PDTfgrimmerTeradata StudioReplyStudio Express severe keyboard lagIt means that the version of the database is not recognized by Studio Express. What version of Teradata are you connecting to?
5826107 Jul 2016 @ 09:17 PDTRhino_373DatabaseReplyPossible loop usage in SQL?Dieter, you've been very helpful. I've been able to modify this to use a subquery for one of the tables and tested it in a number of situations. I appreciate your assistance!
5826007 Jul 2016 @ 09:16 PDTfgrimmerTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listing@kchinad, I am wondering if you have a DNS issue. Are you using a Hortonworks sandbox?
5825907 Jul 2016 @ 09:09 PDTdnoethConnectivityReplyPing Failed - can not connect to Teradata on Linux - awsThere should be messages when & why Teradata restarts, search for entires following "#TPA START".   To fix it you might start the Database Window (xdbw) and then "start vp...
5825807 Jul 2016 @ 08:57 PDTHanCDatabaseReplyReturning a Results from Stored Procedure replace PROCEDURE dbschema.sp_test2  (  IN "SRC_DB_NM" VARCHAR(30) , In "SRC_TBL_NM" VARCHAR(30) )     DYNAMIC RESULT SETS 1 BEGIN&nb...
5825707 Jul 2016 @ 08:52 PDTdnoethDatabaseReplyHow to find how many mloads triggeredYou can check the queryband in dbc.QryLogV for UTILITYNAME=MULTLOAD, all load sessions share the same value in the LSN column.
5825607 Jul 2016 @ 08:36 PDTdnoethTeradata StudioReply“Teradata Studio.pkg” can’t be opened because it is from an unidentified developer.This is due to Gatekeeper, see https://support.apple.com/en-us/HT202491
5825507 Jul 2016 @ 05:40 PDTvijaya.l.tirumalareddyDatabaseTopicHow to find how many mloads triggeredI am looking for information on howmany mloads triggers on Teradata instance during a particular time frame like 9 am to 12pm. Would like to see count by user, triggered time, and query ( if possi...
5825407 Jul 2016 @ 04:41 PDTsharonnConnectivityReplyPing Failed - can not connect to Teradata on Linux - awsThank you Dieter, I've tried looking at /var/log/messages but could not find any useful information - can you please guide me what to look for? i've also tried restarting with t...
5825307 Jul 2016 @ 04:19 PDTmonchomarkToolsReplyTPT EXPORT OPERATOR job structurethanks again, I got another good example from here: http://teradatafaqs.blogspot.ie/2013/11/73-teradata-parallel-transporter-export.html
5825207 Jul 2016 @ 04:17 PDTdnoethDatabaseReplyMigration CompatibilityI never heard of Tibero before, it seems to be an OLTP system, but Teradata is a Data Warehouse DBMS.
5825107 Jul 2016 @ 04:16 PDTdnoethConnectivityReplyPing Failed - can not connect to Teradata on Linux - awsWell, there's no Parsing Engine, no way to logon. There were several crashes of the PE during the restarts, which finally lead to a FATAL state. You can investigate what caused the crashes (/...
5825007 Jul 2016 @ 04:10 PDTdnoethDatabaseReplyStored procedureYou need Dynamic SQL to create a matching Select-statement, there's no way to do that outside of a Stored Procedure.
5824907 Jul 2016 @ 04:08 PDTdnoethDatabaseReplyPossible loop usage in SQL?There's no need for loops, you can utilize an OLAP-function plus RESET WHEN: SELECT ... SUM(t1.amt) OVER (ORDER BY t1.dt DESC RESET WHEN t2.dt IS NOT NULL) FROM table1 AS...
5824807 Jul 2016 @ 04:01 PDTdnoethAnalyticsReplyReplacing missing value with next vaulesAssuming that the rows are sorted by date it's a simple MAX(Attmpt_dt) OVER (ORDER BY sortcolumn).   Otherwise you need LAST_VALUE (Attmpt_dt IGNORE NULLS) OVER (ORDER BY sortc...
5824707 Jul 2016 @ 03:55 PDTdnoethToolsReplyTPT EXPORT OPERATOR job structurehttp://www.info.teradata.com/HTMLPubs/DB_TTU_13_10/index.html#page/Load_and_Unload_Utilities/B035_2445_020A/2445appA.32.26.html#ww10737921 I don't know if the location changed, but the sample ...
5824607 Jul 2016 @ 02:53 PDThv186006Teradata StudioTopic“Teradata Studio.pkg” can’t be opened because it is from an unidentified developer.Hello, I want to install Teradata Studio on my Macbook Pro, but when I download the file from the downloads.teradata.com and try to open the pkg file, I get the following error message: “Ter...
5824507 Jul 2016 @ 01:50 PDTmonchomarkToolsReplyTPT EXPORT OPERATOR job structureI'm looking at these paths but no tpl file samples to be found, ./client/13.10/sample ./client/13.10/odbc_32/samples ./client/13.10/odbc_64/samples ./client/13.10/tbuild/sample ./clien...
5824407 Jul 2016 @ 01:42 PDTArpan.RoyToolsReplyTPT output from ODBC includes Indicator Bytes?Hi Steve, Thanks for your response. Below is my TPT contril file: DEFINE JOB LOAD_ACR_ACCTS_RECEIVABLE_TO_TABLE DESCRIPTION 'export LOAD_ACR_ACCTS_RECEIVABLE_TO_TABLE' ( ...
5824307 Jul 2016 @ 01:12 PDTmonchomarkToolsReplyTPT EXPORT OPERATOR job structurehi feinholz, yes I've been looking both the tpt user guide and the tpt reference manual, didn't find full examples. I was hoping for a minimal or standard query-to-file structure, I can...

Pages