0 - 11 of 11 tags for # teradata

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 check the values in the respective hive table I get all NULL values. The separator and delimiters are fine.

I'm trying to find the sum of amount for an 'ID' trailing 365 days from the 'DT'. Below is a sample from the data I'm working on. The below table consists of dates when purchase was made , id and the amount. I wanted to calculate amount spent by an id trailing 365 days from the 'DT'. Any help on this will be appreciated. Thanks.

I have installed python from Anaconda Continuum and later installed teradata module

conda install teradata

It installed successfully then ran the hello world program like this



In my BTEQ statement, I'm selecting two columns of a table and I'm exporting the output to local file. When I check that file only one column is present. I even tried giving the maximum value for .set width option (65531). It was not working. Please help me on this.


Thanks in advance,


We have a decimal value column, can anyone please advice how to do partitioning using that column.
Thanks in advance. 

I am trying to delete the non PI column from the pi column of the same table.
Query as below.

delete From A tbl1  

Where  Exists(

                Select 1 

                From A tbl2

                Where tbl1.non_pi = tbl2.PI

Select Region,Store,Sales,
   Rank()over(partition by Region Order by sales desc) as SalesRank 
from SalesTable 
Qualify SalesRank>=4

Region	Store	Sales	SalesRank
2	821	82224	1
2	615	5323	2
2	143	5323	2
2	242	4123	4

Desired Output	
Region	Store	Sales	SalesRank
2	821	82224	1
2	615	5323	2
2	143	5323	2
2	242	4123	3

Hi All,
When i tried finding the Row hash value for the unique column which have all unique values ,i saw that all row hash value matches for every single record present there.
http://www.teradatatech.com/?p=470 this link suggest that row hash values cannot be same for unique as well as non unique columns.

=Year(DateAdd("m", -5, DateValue(Parameters!PD2.Value & "/01/" & Parameters!FY.Value))) & "-" & iif(Month(DateAdd("m", -5, DateValue(Parameters!PD2.Value & "/01/" & Parameters!FY.Value)))>9,Month(DateAdd("m", -5, DateValue(Parameters!PD2.Value & "/01/" & Parameters!FY.Value))), "0" & Month(DateAdd("m", -5, DateValue(

I have recently moved to Teradata Studios for Teradata SQL Assistant, when I ran queries within Teradata SQL Assistant the screen went pink after I sent off a query. Is there a way to configure the UI to do this in Teradata Studios. Everything is done in the backgroud which is rather annoying when your use to Teradata SQL Assistant.

hi all ,
I increased the varchar length from 255 to 1500 in a table:
before :the column was declared with varchar(255) in table_A
after :i changed it to varchar(1500) in table_A
but this simple change degraded fexp's performence.
FEXP was something like :