All forum activity

#DateUserForumTypeThreadPost
5776615 Jun 2016 @ 01:57 PDTM.Saeed KhurramGeneralReplyto remove duplicatesWorkaround: Create a new table with same structure: INSERT INTO NEWTABLE SELECT * FROM OLDTABLE QUALIFY ROW_NUMBER() OVER(PARTITION BY OBJECTTABLENAME ORDER BY OBJECTTYPE) = 1; Br, Khurram
5776515 Jun 2016 @ 01:34 PDTM.Saeed KhurramAsterReplyFailed to start cluster activationHi, When you login to AMC, can you see the Worker node in Prepared state? If so, only then you can activate the cluster. Otherwise, I would suggest to note donw the IP of worker, remove the worke...
5776415 Jun 2016 @ 01:24 PDTmgazzato@gmail.comDatabaseTopicConcatenate Columns value orderedHi, I have a table that looks like this: Column1 Column2 Column3 800 900 200 500 300 40 100 600 150 and I would like to concatenate Column1, Column2, Column3 in a list tha...
5776315 Jun 2016 @ 01:22 PDTmgazzato@gmail.comDatabaseTopicConcatenate Columns value ordered Hi, I have a table that looks like this:   Column1 Column2 Column3 800        900        200 500        300 &...
5776215 Jun 2016 @ 01:21 PDTmgazzato@gmail.comDatabaseTopicConcatenate Columns value ordered Hi, I have a table that looks like this:   Column1 Column2 Column3 800        900        200 500        300 &...
5776115 Jun 2016 @ 12:47 PDTsachinsDatabaseReplyDegraded Query performance while performing insertionHi Samir, No the select operation is also not executing fast. Both select and insert are taking time. Can you suggest any ways through which I can improve the query performance. As you can see in...
5776015 Jun 2016 @ 12:37 PDTtd_user001DatabaseReplyAlter table on huge tableThanks Samir for your opinion on this. Couple of questions arises in my mind as I have already mentioned in my previous post: 1. Under what circumstances every row in the table to be rewritten? ...
5775914 Jun 2016 @ 11:59 PDTRaulFSData ModelingReplyDoes Teradata have a probit or Normal dsitribution functionHello, Is it possible to get the integral of this function in Teradata?we need the probability distribution function, and that would be the integral of the density function. In Excel sheet this c...
5775814 Jun 2016 @ 11:44 PDTchungtqDatabaseReplyGetting junk values for Latin column when using JDBCI tried without success, I received others "junk values", they are Polish character and I guess that, there must be solution for this
5775714 Jun 2016 @ 11:15 PDTyarekshy85DatabaseTopicpassing parameter to mload script and loading into target tableDo I need to define the column in file format section of mload which I am planning to load as hard coded value coming from parameter file. In attached code report_suit_id should be passed from para...
5775614 Jun 2016 @ 10:22 PDTcelinexuDatabaseTopicquestion about RANK and TOPSELECT TOP 100 sku, store, amt, RANK()OVER (PARTITION BY store ORDER BY amt DESC) FROM trnsact; Not really I want The following is what I want and I only want t...
5775514 Jun 2016 @ 10:22 PDTcelinexuDatabaseTopicquestion about RANK and TOPSELECT TOP 100 sku, store, amt, RANK()OVER (PARTITION BY store ORDER BY amt DESC) FROM trnsact; Not really I want The following is what I want and I only want t...
5775414 Jun 2016 @ 10:15 PDTh.r.thejas@gmail.comToolsReplyTDCH-TPT InterfaceDo you have any sample scripts to invoke TPT's HDFS interface, the reason for using TDCH-TPT interface was because of better parllelism where we have more mappers writing simultaneous...
5775314 Jun 2016 @ 09:00 PDTmario_rozarioToolsReplyTPT Data Connector Error reading JSONHello there, Figured this out guys. It was a simple syntax issue: - (see below)  STEP export_to_file ( APPLY ('INSERT INTO SAMPLES.FLIGHT_JSON(FLIGHTPACK) VALUES (:FLIGHTP...
5775214 Jun 2016 @ 08:59 PDTthsureshkumarAsterReplyFailed to start cluster activationHi,  Did anyone get the solution for the error. "Node not found in queenDb"   thanks
5775114 Jun 2016 @ 08:22 PDThagrdanDatabaseTopicDatabase per object type -- Best practice or over engineered?Hi there. I am an application developer (not a DBA), and we have a large OLAP Teradata database that we are writing a multi-tier application against.  I am brand new to Teradata. Our Teradat...
5775014 Jun 2016 @ 07:15 PDTcr255014Teradata StudioReplyInstalling Teradata Eclipse Plugin Breaks running DTD againsdt other platforms?Issue appears to be there with 15.11 Plugin for eclipse, I installed 15.11 plugin but execute query option is gryed out for non-Teradata systems.
5774914 Jun 2016 @ 04:19 PDTtomnolanDatabaseReplyGetting junk values for Latin column when using JDBCThe "junk values" might be non-ASCII characters stored in your LATIN column, that cannot be represented with CHARSET=ASCII.   We recommend that you use CHARSET=UTF8 in order to ens...
5774814 Jun 2016 @ 04:16 PDTtomnolanDatabaseReplySQL error using Teradata JDBCError 3536 is a Teradata Database error, not a Teradata JDBC Driver error, so this is not likely to be due to "inconsistent behavior" from the Teradata JDBC Driver.   It is more li...
5774714 Jun 2016 @ 03:28 PDTteradatauser2DatabaseReplyDegraded Query performance while performing insertionHi Is the select exeucting fast ? if true, then is the insert taking time ? This is a Insert sel query with no PI defined for the select part, so the first column will be the PI. If that is skewed...
5774614 Jun 2016 @ 03:20 PDTteradatauser2DatabaseReplyAlter table on huge tableHi, Whenever we have such a big table to alter, we dont use ALTER stmnt. We just drop and recreate it. Since the PI of source and target is same, it will be a fast path insert and would be fast. I...
5774514 Jun 2016 @ 02:54 PDTshiboo18Cloud ComputingTopicInstall XML tools on Teradata Express StudioHi, I am very new to Teradata Aster Express. I want to load XML files into Teradata database but I am unable to figure out how to install XML tools on express. Any guidance would be appreciated.&...
5774414 Jun 2016 @ 01:04 PDTamoyyangDatabaseTopiccreate mutiple tables from an existing table with while loopThis should be a common issue but cannot simply find an exact solution across forum. Thanks for hlep!   Here is what I need: create table tab1 as (select * from mydata w...
5774314 Jun 2016 @ 11:47 PDTtd_user001DatabaseTopicAlter table on huge tableThere is a requirement to add three NULLable columns at the end of existing table which is of volume about 1TB. I would like to know what is the best approach to perform this activity if there is ...
5774214 Jun 2016 @ 10:11 PDTfeinholzToolsReplyTDCH-TPT InterfaceIf you are writing the data to HDFS, why not just use TPT's HDFS interface?  

Pages