| 57766 | 15 Jun 2016 @ 01:57 PDT | M.Saeed Khurram | General | Reply | to remove duplicates | Workaround:
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
|
| 57765 | 15 Jun 2016 @ 01:34 PDT | M.Saeed Khurram | Aster | Reply | Failed to start cluster activation | Hi,
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... |
| 57764 | 15 Jun 2016 @ 01:24 PDT | mgazzato@gmail.com | Database | Topic | Concatenate Columns value ordered | Hi,
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... |
| 57763 | 15 Jun 2016 @ 01:22 PDT | mgazzato@gmail.com | Database | Topic | Concatenate Columns value ordered |
Hi,
I have a table that looks like this:
Column1 Column2 Column3
800 900 200
500 300 &... |
| 57762 | 15 Jun 2016 @ 01:21 PDT | mgazzato@gmail.com | Database | Topic | Concatenate Columns value ordered |
Hi,
I have a table that looks like this:
Column1 Column2 Column3
800 900 200
500 300 &... |
| 57761 | 15 Jun 2016 @ 12:47 PDT | sachins | Database | Reply | Degraded Query performance while performing insertion | Hi 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... |
| 57760 | 15 Jun 2016 @ 12:37 PDT | td_user001 | Database | Reply | Alter table on huge table | Thanks 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? ... |
| 57759 | 14 Jun 2016 @ 11:59 PDT | RaulFS | Data Modeling | Reply | Does Teradata have a probit or Normal dsitribution function | Hello,
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... |
| 57758 | 14 Jun 2016 @ 11:44 PDT | chungtq | Database | Reply | Getting junk values for Latin column when using JDBC | I tried without success, I received others "junk values", they are Polish character and I guess that, there must be solution for this
|
| 57757 | 14 Jun 2016 @ 11:15 PDT | yarekshy85 | Database | Topic | passing parameter to mload script and loading into target table | Do 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... |
| 57756 | 14 Jun 2016 @ 10:22 PDT | celinexu | Database | Topic | question about RANK and TOP | SELECT 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... |
| 57755 | 14 Jun 2016 @ 10:22 PDT | celinexu | Database | Topic | question about RANK and TOP | SELECT 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... |
| 57754 | 14 Jun 2016 @ 10:15 PDT | h.r.thejas@gmail.com | Tools | Reply | TDCH-TPT Interface | Do 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... |
| 57753 | 14 Jun 2016 @ 09:00 PDT | mario_rozario | Tools | Reply | TPT Data Connector Error reading JSON | Hello 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... |
| 57752 | 14 Jun 2016 @ 08:59 PDT | thsureshkumar | Aster | Reply | Failed to start cluster activation | Hi,
Did anyone get the solution for the error.
"Node not found in queenDb"
thanks
|
| 57751 | 14 Jun 2016 @ 08:22 PDT | hagrdan | Database | Topic | Database 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... |
| 57750 | 14 Jun 2016 @ 07:15 PDT | cr255014 | Teradata Studio | Reply | Installing 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.
|
| 57749 | 14 Jun 2016 @ 04:19 PDT | tomnolan | Database | Reply | Getting junk values for Latin column when using JDBC | The "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... |
| 57748 | 14 Jun 2016 @ 04:16 PDT | tomnolan | Database | Reply | SQL error using Teradata JDBC | Error 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... |
| 57747 | 14 Jun 2016 @ 03:28 PDT | teradatauser2 | Database | Reply | Degraded Query performance while performing insertion | Hi
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... |
| 57746 | 14 Jun 2016 @ 03:20 PDT | teradatauser2 | Database | Reply | Alter table on huge table | Hi,
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... |
| 57745 | 14 Jun 2016 @ 02:54 PDT | shiboo18 | Cloud Computing | Topic | Install XML tools on Teradata Express Studio | Hi,
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.&... |
| 57744 | 14 Jun 2016 @ 01:04 PDT | amoyyang | Database | Topic | create mutiple tables from an existing table with while loop | This 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... |
| 57743 | 14 Jun 2016 @ 11:47 PDT | td_user001 | Database | Topic | Alter table on huge table | There 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 ... |
| 57742 | 14 Jun 2016 @ 10:11 PDT | feinholz | Tools | Reply | TDCH-TPT Interface | If you are writing the data to HDFS, why not just use TPT's HDFS interface?
|
