59042 | 09 Aug 2016 @ 08:58 PDT | crazyrama5 | Database | Topic | Merge the continuous rows with date range( sequential rows should merge) |
Hi All,
Can somebody please help me with following scenario. I am looking for dynamic solution of SQL. Because number of rows are not static.
CUST, OLD_ST_DT, OLD_END_DT, AMT1... |
59041 | 09 Aug 2016 @ 08:46 PDT | feinholz | Tools | Reply | TPT load failure - Please suggest | What version of TPTAPI have you installed?
What version of CLI?
This sometimes can occur when mismatching components are installed.
|
59040 | 09 Aug 2016 @ 08:46 PDT | fgrimmer | Teradata Studio | Reply | Code Assist functionality questions | There is a menu option in the top level SQL Mmenu to toggle on Code Assist Autoactivation. It may be untoggled.
|
59039 | 09 Aug 2016 @ 08:38 PDT | BRIANH | Database | Reply | DBC - CURRENTPERM EXCEEDS MAXPERM | Hi Fred... sorry I took an extensive length of time to respond to you... fighting some gremlins... I reviewed the DBQL tables and they were fairly large, purged most of their contents and currentpe... |
59038 | 09 Aug 2016 @ 08:36 PDT | stami27 | Tools | Reply | TPT load failure - Please suggest | I forgot to communicate the platform where the TUs are installed:
cat /proc/version
Linux version 2.6.32-431.11.2.el6.x86_64 (mockbuild@x86-027.build.eng.bos.redhat.com)
(gcc version 4.... |
59037 | 09 Aug 2016 @ 08:36 PDT | tejakandikonda86 | Database | Topic | retrieve row count from Teradata Macro | Hi,
I have a Macro 'ABC' which would take one input parameter. I am executing the macro as execute ABC(?) through jdbc.
This Macro returns results with column values. However I ne... |
59036 | 09 Aug 2016 @ 08:29 PDT | feinholz | Tools | Reply | Queries for Teradata Fast Export Utility | 1. FastExport should be installed on the edge node. It should never be installed on the database server.
2. It has been shown that a max session count of 4 is generall the best setting, but you ca... |
59035 | 09 Aug 2016 @ 08:25 PDT | feinholz | Tools | Reply | TPT export into AWS S3 buckets. | We are currently developing an Amazon AWS S3 access module that will allow you to move data from S3 directly into Teradata (and vice versa) without landing the data to disk. It is not yet released.... |
59034 | 09 Aug 2016 @ 08:20 PDT | stami27 | Tools | Reply | TPT load failure - Please suggest | Hello Steve
We want to upgrade the RDBMS TD 15.10 soon.
Prepared, I have installed the Linux Tools 15.10.01.
...
tdodbc1510-15.10.01.01-1.noarch
tptstream1510-15.10.01.03-1.noarch
tpump15... |
59033 | 09 Aug 2016 @ 08:14 PDT | Glass | Database | Reply | How to do a random sample? | Random sample will return different results each time.
You could insert results into a work table and join to that each additional time.
Rglass
|
59032 | 09 Aug 2016 @ 05:42 PDT | ToddAWalter | General | Reply | Improve performance on an analytical query , mulitple columns using same set of partitions | As you can see, optimizer combines multiple ordered analytic functions with the same partition and order into a single execution. Two different ones are required because there are two d... |
59031 | 09 Aug 2016 @ 05:06 PDT | jester666 | Teradata Database on AWS | Reply | pkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0 | Address this issue by downgrading to python 2.6.
If someone find solution for running tdc-init on Python 2.7, would appreciate your comment.
|
59030 | 09 Aug 2016 @ 05:05 PDT | rajezkumar11511 | Connectivity | Reply | Teradata JDBC Connection Failure | Hi Tomnolan,
I'm also facing the same issue when I tried to create a new connection profile Teradata studio express 15.
How can I check database is running in my system? and I'm usi... |
59029 | 09 Aug 2016 @ 04:34 PDT | krishna1985 | Tools | Reply | Casting Date in Bteq utilities | Hi Team,
can anyone let me know syntax to convert date as above in fastload instead of bteq plzz
|
59028 | 09 Aug 2016 @ 03:15 PDT | Mohank1006 | Training | Reply | Immediat TERADATA Online training available...,Interested people drop a mail @navench@gmail.com | Hi All,
Good day.
This is Mohan, and I joined in this group just now.
Br,
Mohan
|
59027 | 09 Aug 2016 @ 02:53 PDT | Arpan.Roy | Aster | Topic | load_from_hcatalog --- error while selecting Varchar,Date,Timestamp column |
Hi All,
We are trying to read data from Hive table and load into teradata table after lots of transformation. So, we are trying to use "load_from_hcatalog". But while selecting dat... |
59026 | 09 Aug 2016 @ 02:35 PDT | Cesco | Database | Reply | User's DDL | Thank you all for your answers.
Unfortunatly, in my company we can't use the "Teradata studio", but I can obtain all the informations I need from DBC.logonrules, DBC.users and using ... |
59025 | 09 Aug 2016 @ 01:38 PDT | Priti_Kanal | Database | Topic | Numeric overflow occurred during computation in Teradata Stored procedure |
INSERT INTO TGT
SELECT
DECIMAL_C1,
DECIMAL_C2,
MAX(CAST(DATE_C3 AS DATE)) AS MAX_DATE_C3,
MAX(CAST(TIMETSAMP_C4 AS TIMESTAMP(6))) AS MAX_TIMETSAMP_C4
(
SELECT&nb... |
59024 | 09 Aug 2016 @ 01:08 PDT | Dan95 | Aster | Topic | Code Assist not working | Hi,
I'm trying to use code assist for displaying a list of table after writting my database name. However code assist is not working, i'm on teradata studio express v15.11, any help ?
-&g... |
59023 | 09 Aug 2016 @ 12:58 PDT | Dan95 | Teradata Studio | Reply | Code Assist functionality questions | Hi,
I have some problem with code completion, when writting database. i'm not getting a list of table. Is it working on teradata studio express v15.11 ?
Thanks a lot,
Dan
|
59022 | 09 Aug 2016 @ 12:31 PDT | Private Forum |
59021 | 08 Aug 2016 @ 11:01 PDT | Soumyatg | General | Reply | Improve performance on an analytical query , mulitple columns using same set of partitions |
We do an all-AMPs STAT FUNCTION step from Spool 2 (Last Use) by
way of an all-rows scan into Spool 6 (Last Use), which is assumed
to be redistr... |
59020 | 08 Aug 2016 @ 10:38 PDT | krishna1985 | Tools | Topic | Casting Date in Bteq utilities | Hi Team,
I am new to Teradata and I have a requirement to load the data FROM EXCEL using BTEQ UTILITIY. However as far as I know we cannot load data from excel but can load in CSV fo... |
59019 | 08 Aug 2016 @ 09:10 PDT | VandeBergB | Training | Reply | Need help to find out Teradata certification material | Read the manuals, get some experience and learn for yourself via hands on experience. Just passing the test has zero value in the real world.
If you can only regurgitate the manuals without ... |
59018 | 08 Aug 2016 @ 07:06 PDT | Yunfei Zhao | Database | Topic | How to do a random sample? | I want to do a simple random sample in Teradata. I have a table, My_Table, it has 2 columns, SSN and Tran_ID. This is for a bank, like Citibank, which has millions of customers (SSN), and... |