59342 | 22 Aug 2016 @ 03:13 PDT | feinholz | Tools | Reply | Easy Loader Error - 2 Teradata Systems | Please change the job variable "SelectStmt" to "SourceSelectStmt" and let me know if the job is successful.
|
59341 | 22 Aug 2016 @ 03:02 PDT | feinholz | Tools | Reply | Zero records are fetching when using where statement in TPT | You need to escape (double) the single quote characters around the date.
|
59340 | 22 Aug 2016 @ 02:36 PDT | aaibinder | Tools | Topic | TPT Script, Only Pull Entries Within Last 6 Months? | So my original query in Sqoop was included the condition
BROADCAST_DT > DATE - INTERVAL '6' MONTH
I've been trying to put this into my TPT script, inside the S... |
59339 | 22 Aug 2016 @ 02:18 PDT | cgermain904 | Database | Reply | Convert date > xx/01/xxxx of given month to first of following month | Thanks Dieter!
|
59338 | 22 Aug 2016 @ 01:52 PDT | dlcook | Tools | Topic | Easy Loader Error - 2 Teradata Systems | I'm following (somewhat) the example on http://developer.teradata.com/tools/articles/using-tpt-easy-loader-to-move-data-within-the-database-environment , but I'm running into an error ... |
59337 | 22 Aug 2016 @ 01:36 PDT | toadrw | Tools | Reply | Easyloader Schema Error 15.10 Only | On 15.00 you are correct everything is varchar. Moving the same file on 15.10 is not.
15.00 Private Log - Success
TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Teradata Paralle... |
59336 | 22 Aug 2016 @ 01:13 PDT | Naresh12 | Tools | Reply | Zero records are fetching when using where statement in TPT | SelectStmt='SELECT * FROM TABLE_NAME WHERE EFF_DT='2016-08-12' '
Unable to Enclose date inside single quotes while passing the variable in job_variable file for tdload scri... |
59335 | 22 Aug 2016 @ 12:30 PDT | ZackHowe | Teradata Database on VMWare | Reply | Setting up Teradata Python Module on VMware image | I decided I didn't like the Python version from the OSS package (3.3.2) since I wanted to use subprocess.run() so I went back to the install drawing board.
using the OSS repo, I found the righ... |
59334 | 22 Aug 2016 @ 11:29 PDT | feinholz | Tools | Reply | Easyloader Schema Error 15.10 Only | You will have to show me a job run with TPT 15.0 and a schema with FLOAT.
It should not have worked.
We have been pretty strict about this since Day 1.
|
59333 | 22 Aug 2016 @ 11:13 PDT | dnoeth | Database | Reply | Convert date > xx/01/xxxx of given month to first of following month | The calculation might be simplified to:
if it's not the first day of a month calculate the last day and add one day
CASE
WHEN EXTRACT (DAY FROM COLUMNNAME) = 1
THEN COLUMNNAME
... |
59332 | 22 Aug 2016 @ 11:03 PDT | tomnolan | Connectivity | Reply | Querying Teradata from JavaScript/jQuery? | Teradata REST Services is available from AWS: https://aws.amazon.com/marketplace/pp/B01DJUOW10
Also, if you're a customer, Teradata REST Services is available from "Teradata at Yo... |
59331 | 22 Aug 2016 @ 10:53 PDT | toadrw | Tools | Reply | Easyloader Schema Error 15.10 Only | Sorry about that. It doesn't work with the new DDL. We don't have a problem on 15.00 even with the original DDL where there are float columns. Here is the new test. ... |
59330 | 22 Aug 2016 @ 10:51 PDT | Jayant2306 | Database | Topic | Need information about | Hi All,
I am trying to tune a query.
Basically I joinning two table A,B on columns Col1. both having different Indexes
Example: select * from Table1 A
inner join Table2 B
on A.Col1 = B.Col1
a... |
59329 | 22 Aug 2016 @ 10:27 PDT | tomnolan | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | Correction: In my post above, where I said that the nullability for column c2 is inaccurate -- it's actually the nullability for column c1 that is inaccurate.
Column c1 doesn't hav... |
59328 | 22 Aug 2016 @ 10:22 PDT | tomnolan | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | >>> Maybe it's related to sub-queries messing up the nullability? Is this a known limitation?
In short, Yes.
Your subquery is used as a derived table. Here is a... |
59327 | 22 Aug 2016 @ 10:10 PDT | cgermain904 | Database | Reply | Convert date > xx/01/xxxx of given month to first of following month | You, my friend, are awesome! Thanks so much, this worked great!
I read more about the ADD_MONTHS and EXTRACT functions to help understand what is happening. Great learning from my first post. I lo... |
59326 | 22 Aug 2016 @ 09:52 PDT | sachin.sebastian | Database | Reply | Convert date > xx/01/xxxx of given month to first of following month | SEL CASE WHEN EXTRACT (DAY FROM COLUMNNAME) > 2 THEN ADD_MONTHS((COLUMNNAME - EXTRACT(DAY FROM COLUMNNAME)) +1,1) ELSE COLUMNNAME END
Use your column name inplace of 'COLUMNNAME'
|
59325 | 22 Aug 2016 @ 09:35 PDT | cgermain904 | Database | Reply | Convert date > xx/01/xxxx of given month to first of following month | Correction to above on 'however, could I just modify that expression to be "> 2"?'
|
59324 | 22 Aug 2016 @ 09:34 PDT | cgermain904 | Database | Reply | Convert date > xx/01/xxxx of given month to first of following month | Thank you for your response, Sachin. This CASE yields the date as the first of that particular month, not the following month which is what I need. I've also noticed that records will store on ... |
59323 | 22 Aug 2016 @ 09:11 PDT | sachin.sebastian | Database | Reply | Convert date > xx/01/xxxx of given month to first of following month | Try this
SEL CASE WHEN EXTRACT (DAY FROM CURRENT_DATE) <> 1 THEN (CURRENT_DATE - EXTRACT(DAY FROM CURRENT_DATE)) +1 END
Just replace the CURRENT_DATE with your column name
|
59322 | 22 Aug 2016 @ 08:59 PDT | fgrimmer | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | Vinoth, I think there is a problem in selecting the conneciton profile in the SQL Editor. A workaround is mentioned above. As a work around, can you try creating another connection profile wit... |
59321 | 22 Aug 2016 @ 08:58 PDT | feinholz | Tools | Reply | Easyloader Schema Error 15.10 Only | SUBSCRIBER_NO is defined as FLOAT.
It needs to be VARCHAR.
|
59320 | 22 Aug 2016 @ 08:56 PDT | feinholz | Tools | Reply | Zero records are fetching when using where statement in TPT | If you tried to put the SELECT statement in the script, please send me your script and I will make adjustments as necessary.
|
59319 | 22 Aug 2016 @ 08:55 PDT | fgrimmer | Teradata Studio | Reply | Looking for a TD Studio 14.10 install package | Brian, You can get older versions of Studio on the Teradata Patch Server. Just a reminder that if you have any support issues, you will need to move to the latest version.
|
59318 | 22 Aug 2016 @ 08:26 PDT | alokku55 | General | Reply | interview help | Hi Anand,
If you dont mind, could you please upload in google doc share and share the link.
This is just to avoid any spam on our personal email by not sharing it on the web.
Thanks in advance!
... |