58617 | 21 Jul 2016 @ 01:13 PDT | zakyw | Analytics | Topic | QUERY IN ASTER | Hi Guys
I'm Zaky
In here , i've a problem with query in aster , because this the first moment for me ,
so , my question is , can you give me references or tell me how t... |
58616 | 21 Jul 2016 @ 01:04 PDT | gtmmaj | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | I am getting the following error message:
Failed to execute SQL:
org.eclipse.datatools.sqltools.db.service.GenericSQLService cannot be cast to com.teradata.datatools.dtp.sqltools.db.teradata.s... |
58615 | 21 Jul 2016 @ 01:03 PDT | gtmmaj | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | Isroxas, how did you fix this issue? Could you please share.
|
58614 | 21 Jul 2016 @ 12:29 PDT | KN | Tools | Reply | Determine #sessions to set for load / exp jobs | Thank you... Todd and Steve..
In our Tasm the no of session set for for default,large and small fexp jobs have been set to 4 ,4 & 2 respectively..
TASM will not auto calculate the no of ... |
58613 | 21 Jul 2016 @ 12:28 PDT | drmkd17 | Database | Reply | Using WITH Statement Modifier instead of Temp Tables? | How better is the CTE approach than a derived table .??Any recommendations when to use a CTE instead of a derived table.
|
58612 | 21 Jul 2016 @ 12:13 PDT | zakyw | Aster | Reply | Aster 6.0 to HDP 2.1 select does not work | Hai All
i will introduce myself ,
my name is zaky wibowo
in here , i have a question about query in aster , currently i have some problem about query in aster
cause , i... |
58611 | 20 Jul 2016 @ 11:56 PDT | dnoeth | Analytics | Reply | How to create churn data for customers by transaction in month? | Answered on StackOverflow: How to by pass case not when exists in teradata?
Btw, recursive is not bad in Teradata if it's done the right way :)
|
58610 | 20 Jul 2016 @ 10:06 PDT | pmoosh | Teradata Database on AWS | Reply | AWS instance unreachable for Teradata Database Developer (Single Node) | Have the same issue and I think @tisenhart is right. It's fs check that takes so long, I didn't have the issue before. I would like to deploy an instance via an automation tool, so this is ... |
58609 | 20 Jul 2016 @ 07:28 PDT | AMIT@TD | Database | Reply | Data Dictionary | thanks Dieter for your help. :)
|
58608 | 20 Jul 2016 @ 07:06 PDT | tisenhart | Teradata Database on AWS | Reply | AWS instance unreachable for Teradata Database Developer (Single Node) | Thank you for the replies, i tried them all and was still having an issue. However, after leaving the instance up for about an hour while trying to debug and write this reply, finally my ssh ... |
58607 | 20 Jul 2016 @ 06:43 PDT | mc200018 | Teradata Database on AWS | Reply | AWS instance unreachable for Teradata Database Developer (Single Node) | To connect the instance, please check follows from AWS instance console.
1. The Instance State should "running" state
2. The Status Checks shoule "2/2 checks passed" state
&n... |
58606 | 20 Jul 2016 @ 06:06 PDT | mints | Tools | Reply | TPT Export vs Fast Export | does TPT support case below
100,000 records from one single table, and when doing export, automatically split 100,000 records into mutiple files, say into 10 files, each file contains 10000 ... |
58605 | 20 Jul 2016 @ 03:35 PDT | ac110057 | Teradata Database on AWS | Reply | AWS instance unreachable for Teradata Database Developer (Single Node) | Also double check that you opened port 22 to your IP address or your compainies IP address. When it is a company IP address it is usually autodetected in the drop down menu. It is usually not the e... |
58604 | 20 Jul 2016 @ 02:38 PDT | au185006 | Teradata Database on AWS | Reply | AWS instance unreachable for Teradata Database Developer (Single Node) | When you state that "The AWS instance state shows the instance is unreachable" this sounds like a problem with the deploy from AWS side. I would drop the instance and re... |
58603 | 20 Jul 2016 @ 01:39 PDT | feinholz | Tools | Reply | Zero records are fetching when using where statement in TPT | If you write a script and put the SELECT statement in the script, the single quotes will not be stripped.
|
58602 | 20 Jul 2016 @ 01:26 PDT | basshead | Analytics | Topic | How to create churn data for customers by transaction in month? | So I have created a table that has the following columns from a transaction table with all customer purchase records: 1. Month-Year, 2.Customer ID, 3. Number of Transactions in that month.
I... |
58601 | 20 Jul 2016 @ 08:27 PDT | k_jalev | Viewpoint | Topic | Limit a role to only one Teradata system of several active | Hi,
We have several systems managed through single installation of Viewpoint, version is V14.10.00.08-b61
We are trying to create a User role and to give it full administrative ac... |
58600 | 20 Jul 2016 @ 08:06 PDT | VandeBergB | Tools | Reply | FOR EACH clause in Teratada SQL | are you looking for the first day of each month for the year ?
if so , join to the sys_calendar.calendar view on the date, with the additional condition of where day_of_month = 1
|
58599 | 20 Jul 2016 @ 07:25 PDT | rmrossi | Tools | Topic | FOR EACH clause in Teratada SQL | I have the statment below:
INSERT INTO P_WENL.RR_tmpParque2
SELECT
Prqe.dt_foto_lnha
,Pssa.cdCliente
... |
58598 | 20 Jul 2016 @ 03:43 PDT | dnoeth | Database | Reply | Data Dictionary | The size of the actual Data Dictionary tables (excluding TransientJournal, AccessLog, QueryLog, ResUsage) is way less than 1% of the system's perm space.
Best practices recommend to reduce the... |
58597 | 20 Jul 2016 @ 03:13 PDT | AMIT@TD | Database | Reply | Data Dictionary | Thanks dnoeth. please eleborate Q2. and if space is more then why do we bother to save data dictionary space.??
|
58596 | 20 Jul 2016 @ 02:13 PDT | Abhijeet.Shah | Teradata Database on AWS | Reply | AWS instance unreachable for Teradata Database Developer (Single Node) | Please use Public IP address or Public DNS of instance for ssh connection.
Note that "ec2-user" is the user you need to use for ssh connection as shown below,
:~# ssh -i private-key-fil... |
58595 | 20 Jul 2016 @ 02:03 PDT | M.Saeed Khurram | Aster | Reply | Aster 6.0 to HDP 2.1 select does not work | Hi,
It seems to be a problem from Cloudera. have you made any upgrade to Cloudera server?
Are you able to ping the server 'smp200-8_eth4' from Aster machine?
|
58594 | 20 Jul 2016 @ 01:42 PDT | venkata_k01 | Tools | Reply | Zero records are fetching when using where statement in TPT | Any way to make sure single-quotes present in the SELECT statement that is sent to Teradata and overcome this issue?
Thanks,
Hanu
|
58593 | 20 Jul 2016 @ 01:39 PDT | M.Saeed Khurram | Database | Reply | Fastload Duplicate Records issues | As you told earliar the fastload script got aborted. Fastoad only load into an empty table.
Can you check if there is no data in the Target table?
Otherwise the best option is to use NOPI t... |