59092 | 11 Aug 2016 @ 02:32 PDT | AtardecerR0j0 | Database | Reply | Capturing Versions when there is a Change in a Column Value else keep the Earliest if Consecutive | Very important: Read the documentation to understand Row_Number and min functions
http://www.info.teradata.com/htmlpubs/DB_TTU_15_10/index.html#page/SQL_Reference/B035_1145_151K/ROW_NUMBER.html
A... |
59091 | 11 Aug 2016 @ 02:09 PDT | spetmp | UDA | Reply | Cast and format | hi,
I want to diplay 011 as 'zero one one ' in teradata. can you help me out !!
eg: 011- i need to display as 'zero one one'
012- i need to display as 'zero one two' like... |
59090 | 11 Aug 2016 @ 01:47 PDT | sam141988 | Database | Topic | Capturing MAX marks for Each Student when the MArks are in Columns |
Consider the Below Scenario -
ID|MATHS|PHYSICS|CHEMISTRY
1|50|60|70
2|70|60|40
3|50|80|70
4|50|100|70
5|90|60|70
I want to get the Result where it will display the maxi... |
59089 | 11 Aug 2016 @ 01:42 PDT | sam141988 | Database | Reply | Capturing Versions when there is a Change in a Column Value else keep the Earliest if Consecutive | Hi @AtardecerR0j0
Thank You So Much for the Solution this is Exactly what i was looking for !
I am New to Teradata can you please explain me once how it is working in Steps?
... |
59088 | 11 Aug 2016 @ 01:41 PDT | sharonn | Teradata Studio | Topic | Why is the first dynamic result set in a procedure is empty? | Hi,
I have a procedure that has 1 dynamic result set defined in it.
When i call the procedure from TD studio i get 2 result sets:
1) Empty - no rows and no columns
2) My result set
Whe... |
59087 | 11 Aug 2016 @ 01:21 PDT | stami27 | Tools | Reply | TPT load failure - Please suggest | Anyway, I thank you.
I have seen, there are some Linux tools with newer version on the Teradata SW Server..
I'll install it first and try again.
GSC recommends in the incident setting env... |
59086 | 11 Aug 2016 @ 12:31 PDT | AtardecerR0j0 | Database | Reply | Lock a table row by rowhash | Yes it is possible, here you have an example:
BT;
LOCKING ROW FOR WRITE SELECT NULL FROM TABLE1 WHERE COL1 = 'XXXX';
....
ET;
If one session has 1 rowhash blocked and another one do ... |
59085 | 11 Aug 2016 @ 12:03 PDT | AtardecerR0j0 | Database | Reply | Capturing Versions when there is a Change in a Column Value else keep the Earliest if Consecutive |
drop table table1;
create multiset volatile table table1
(
id integer,
start_date timestamp,
valor decimal (5,2)
)primary index( id )
on commit preserve rows;
insert into table1 values(... |
59084 | 10 Aug 2016 @ 10:32 PDT | sureshb79 | Connectivity | Topic | Teradata Presto Driver Connectivity INT Datatype Limitation | Hello,
We are using Teradata ODBC driver for Presto to connect to Hive data.
We observed that, SELECT query with INTEGER Column just hungs. If we cast the column with Varchar/BIGINT we are ... |
59083 | 10 Aug 2016 @ 09:00 PDT | zakyw | Aster | Reply | Alternative to Strtok in Teradata Aster | Hy Dieter
i want to ask you something about error in aster
i've a problem with the query extract load from teradata to aster , but any something wrong with this query ,
-- que... |
59082 | 10 Aug 2016 @ 08:48 PDT | zakyw | Analytics | Reply | QUERY IN ASTER | Hy guys
i want to ask you something about error in aster
i've a problem with the query extract load from teradata to aster , but any something wrong with this query ,
-- query fo... |
59081 | 10 Aug 2016 @ 06:10 PDT | Private Forum |
59080 | 10 Aug 2016 @ 03:56 PDT | srikanth471 | Database | Topic | TimeZone conversion | Hi All,
I have a scenario here as below
TAB1 has 100Bn rows with timestamp(RPTG_TS) in 'America Pacific' and need to convert this timestamp column to GMT timestamp.
For n... |
59079 | 10 Aug 2016 @ 03:25 PDT | BRIANH | Tools | Reply | ARCMAIN | OK.. finally resorted to a recycle of Teradata and Windows... reran my Arcmain scripts as is and voila.... success.... go figure that....I'll certainly keep close watch on my arc jobs and see i... |
59078 | 10 Aug 2016 @ 02:08 PDT | franceszhu | Database | Topic | How to add a new spatial reference system to SYSSPATIAL.SPATIAL_REF_SYS | I want to add a new SRS record to the table SYSSPATIAL.SPATIAL_REF_SYS. However, the manual doesn't have more description on it. There are 4 columns in the table:
SRID: Spatial re... |
59077 | 10 Aug 2016 @ 01:24 PDT | BRIANH | Tools | Topic | ARCMAIN | I have attempted several times to run some ARCMAIN tests under Windows 10 via a batch job and have failed. The .BAT file is this : ARCMAIN CHECKPOINT=50 OUTLOG=ARCALL.OUT <... |
59076 | 10 Aug 2016 @ 12:58 PDT | gp19380 | Connectivity | Topic | ODBC Driver Suite - Windows 2008 missing for v14.10 |
https://downloads.teradata.com/download/connectivity/odbc-driver/windows
I am trying to download version 14.10.17 driver but I noticed ... |
59075 | 10 Aug 2016 @ 12:52 PDT | blue_eyed_byte | Database | Reply | Options to compare contents of two tables | Thanks Inguva! |
59074 | 10 Aug 2016 @ 11:46 PDT | feinholz | Tools | Reply | TPT load failure - Please suggest | Since an incident has been opened for this, I will let the GSC handle it for now.
If they need to come to engineering, then I will get involved to help them.
(That message it provided by the DBS ... |
59073 | 10 Aug 2016 @ 08:20 PDT | Private Forum |
59072 | 10 Aug 2016 @ 07:18 PDT | Dinesh1975 | Tools | Topic | bteq help needed | I am new to TD. Can someone please tell me what this line does.
bteq << ! >> /export/home/din/dba/dbc_hist.log_ 'date '+%m%d%y_%H%M' ' 2>&... |
59071 | 10 Aug 2016 @ 05:51 PDT | abhishank18 | UDA | Reply | BT/ET | Hi, While submitting request as BT;stmt 1;stmt 2;stmt 3;ET; in Teradata SQL ASSISTANT and Unix has different behaiour, in SQL ASSISTANT after failure of one statement transaction rollsback but... |
59070 | 10 Aug 2016 @ 03:16 PDT | sam141988 | Database | Topic | Capturing Versions when there is a Change in a Column Value else keep the Earliest if Consecutive | Hi Experts Can you All please suggest how this can be achived in TD-
Consider the Sample Source Data -
ID|START_DATE|VALUE
110333005|2000-05-03 00:00:00.000000|0.00
110333005|2014-01-08 12:38:4... |
59069 | 10 Aug 2016 @ 02:33 PDT | Inguva | Database | Reply | Options to compare contents of two tables | In our project we use minus, so i feel its good way.
|
59068 | 10 Aug 2016 @ 02:25 PDT | vijitv | Hadoop | Topic | TDCH to Hive inserts NULL values | I have been trying to import Teradata Tables into Hive using the TDCH utility. The utility seems to be working fine since the connection is successful. However after the job completes and when I ch... |