58592 | 20 Jul 2016 @ 01:20 PDT | aneelkumar04 | Database | Reply | Fastload Duplicate Records issues | Hi CarlosAL
Thank you for reply, i checked your command,but i didn't get duplicate records
Thanks in advanced
|
58591 | 20 Jul 2016 @ 01:04 PDT | Ghalia | Analytics | Reply | MAX() and MAX() OVER (PARTITION BY ....) in the same query produces error 3504 | Maybe you just need to group also by course_code ( the field in the partition part)...
|
58590 | 20 Jul 2016 @ 12:59 PDT | CarlosAL | Database | Reply | Fastload Duplicate Records issues | Hi.
Fastload DOES NOT put full duplicate rows in an ERROR TABLE. Fastload puts UNIQUE PRIMARY INDEX violations in ERROR TABLE 2.
To the OP:
You can check duplicates in the file using something l... |
58589 | 20 Jul 2016 @ 12:35 PDT | M.Saeed Khurram | Database | Reply | Fastload Duplicate Records issues | Hi,
Fastload do not load full row duplicate records, rather put them in a separate error table by default.
As per the log, there are 5 duplicates but no dups in error table, So one reason c... |
58588 | 20 Jul 2016 @ 12:34 PDT | Karthikeyan_dsk | Analytics | Reply | Replacing duplicates while transpose in Teradata | Making Tables Proper
TBL_RULES
TBL_NM VLD_ID COL_NM
TABLE1 1000 COL_1
TABLE1 1001 COL_2
TABLE1 1002 COL_2
TABLE1 1003 COL_3
TABLE_LOG
TBL_NM VLD_ID REC_NBR SUCCESS_FLAG
TABLE1 1... |
58587 | 20 Jul 2016 @ 12:27 PDT | Karthikeyan_dsk | Analytics | Topic | Replacing duplicates while transpose in Teradata | Hi,
I have two tables as below.
TBL_RULES
TBL_NM
VLD_ID
COL_NM
TABLE1
1000
COL_1
T... |
58586 | 20 Jul 2016 @ 12:19 PDT | Karthikeyan_dsk | Jobs | Reply | Terradata developer opportunity in Toronto, Canada | Hi,
To which ID I should send. Do you expect profiles from within Canada?
|
58585 | 20 Jul 2016 @ 12:14 PDT | aneelkumar04 | Database | Reply | Fastload Duplicate Records issues | Hi,
Thnaks for reply, But its production database.
|
58584 | 20 Jul 2016 @ 12:08 PDT | AtardecerR0j0 | Database | Reply | Fastload Duplicate Records issues | You can load data again using a NOPI table, so that you'll load duplicate rows. Then you can use sql to check about duplicate rows.
|
58583 | 19 Jul 2016 @ 11:58 PDT | aneelkumar04 | Database | Topic | Fastload Duplicate Records issues | Hi All,
I am loading data from file to Db using fastload. My file got aborted due to duplciate records,but when i chcecked in file there is no duplicate records in file. I am confusinng.&n... |
58582 | 19 Jul 2016 @ 11:16 PDT | KN | Tools | Reply | TPT - Scripting | Thank you all for the pointers...
We are on DBS version is on 14.10 currently.. I have set up a Teradata Sandpit environment on VM infrastructure and that is on TD 15.0..Basically We wanted to off... |
58581 | 19 Jul 2016 @ 10:42 PDT | Johannes Vink | Viewpoint | Reply | Moving Data from One Viewpoint Server to a new Viewpoint Server | If you want to move everything: move everything in the /backup folder to the new server in the /backup folder there and restore the data/configuration. The restore process is described in chapter 6... |
58580 | 19 Jul 2016 @ 10:15 PDT | AVOT | Viewpoint | Topic | Moving Data from One Viewpoint Server to a new Viewpoint Server | Hi Techos,
We have three VP 15.00 servers in the DEV environment. Assume S1, S2, and S3. S1 is currently used as a standalone VP server and is collecting the data. I have set up S2(primary) and S3... |
58579 | 19 Jul 2016 @ 09:30 PDT | tisenhart | Teradata Database on AWS | Topic | AWS instance unreachable for Teradata Database Developer (Single Node) | I've launched the AWS Teradata Database Developer (Single Node) , and can't connect with ssh to start the DB ; not sure why i can't ssh.
The AWS instance state shows the instance ... |
58578 | 19 Jul 2016 @ 06:14 PDT | zhenwuyang | Database | Reply | Function quantile throws a numeric overflow error in a large table | Thank you Fred and Dnoeth. I tried the OLAP option, but it takes too long. I worked with my busessiness user and reduced the amount of data we are pulling. That works for now.
For Dnoeth's sug... |
58577 | 19 Jul 2016 @ 04:54 PDT | sudarmo | Teradata Studio | Reply | Kerberos Authentication | Hi Francine,
Where can I find the "Studio Help Content" that explained Kerberos Authentication as you described above?
I tried Teradata Studio Help Content but couldn't locate any s... |
58576 | 19 Jul 2016 @ 02:44 PDT | g_rodrig | Aster | Reply | Aster 6.0 to HDP 2.1 select does not work | Hello , i am receiving a similar error when running a query from aster 6.20 to Cloudera 5.4.
ERROR: SQL-MR function LOAD_FROM_HCATALOG failed: Failed to initiate data reading from hcatalog t... |
58575 | 19 Jul 2016 @ 02:16 PDT | HF | Database | Reply | Consolidate rows | I have version 15.1, but your query worked perfectly. Thank you.
|
58574 | 19 Jul 2016 @ 02:06 PDT | dnoeth | Database | Reply | Consolidate rows | What's your Teradata version?
14.10 has a quite unknown syntax using NORMALIZE over PERIODs:
SELECT CATEGORY, TYPE,
-- split the period in start and end again
BEGIN(pd), LAST(pd)
F... |
58573 | 19 Jul 2016 @ 01:42 PDT | HF | Database | Reply | Consolidate rows | 2016-02-01 is February 1st. There are no gaps in time. My example END_TS should really have been the last second prior to the start_ts of the following row.
For instance the 1st row in... |
58572 | 19 Jul 2016 @ 12:00 PDT | dnoeth | Database | Reply | Consolidate rows | Is "2016-02-01" Feb. 1st or Jan. 2nd, i.e. do you want to combine only periods without gaps?
|
58571 | 19 Jul 2016 @ 11:23 PDT | feinholz | Tools | Reply | Zero records are fetching when using where statement in TPT | I have enough information.
I needed to know if the single-quotes were being stripped.
|
58570 | 19 Jul 2016 @ 11:18 PDT | venkata_k01 | Tools | Reply | Zero records are fetching when using where statement in TPT | Hi Steve,
I am facing issue while uploading complete .out file.
Please let me know if the above information is enough for furthur analysis before my attempt to upload the file is successf... |
58569 | 19 Jul 2016 @ 10:38 PDT | venkata_k01 | Tools | Reply | Zero records are fetching when using where statement in TPT | Hi Steve,
PFB the select statement from the .out file.
Single quote before & after the date value is missing and that is why it is fetching 0 records.
k ==========... |
58568 | 19 Jul 2016 @ 10:30 PDT | HF | Database | Topic | Consolidate rows | I'm looking to consilidate rows in my table by combining similar consecutive rows together.
In the example I have category "A" where the type "X" is the 1st... |