58141 | 30 Jun 2016 @ 08:12 PDT | jkurdsjuk | Database | Reply | Create NUPI and USI having the same Column | Is this a question or a quiz? ;)
Only thing I can think of is on a partitioned table where the partitioning column is not part of the PPI and therefore the PI cannot be unique.
|
58140 | 30 Jun 2016 @ 07:05 PDT | hyma | Database | Topic | Create NUPI and USI having the same Column | Hi
Under which circumstances does it make sense to define NUPI and USI having the same column?
It sounds curious, isn't it?
Thanks.
|
58139 | 30 Jun 2016 @ 03:50 PDT | M.Saeed Khurram | Extensibility | Reply | urgent : xml conversion | Hi,
This issue has been resolved. The issue ocurred due to a tag in annotatedschema definition.
There is a tag <defaultDatabase>Databasename</defaultDatabase>.
Update this tag w... |
58138 | 30 Jun 2016 @ 03:35 PDT | M.Saeed Khurram | Tools | Reply | 2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD- | Hi,
Do the following:
execute the following statment:
release mload tablename;
delete the log table. and restart the job.
Br,
Khurram
|
58137 | 30 Jun 2016 @ 01:06 PDT | arkaprava.chandra | General | Topic | how to find frequently used data in a table of Teradata Database | Hi All,
could you please tell me, how to find frequently used data in a table of Teradata Database?
Portions of data within tables that were accessed within last 2 years – Ex, if ... |
58136 | 30 Jun 2016 @ 12:04 PDT | prem.rpk | Database | Reply | Analytical Function for deriving dates | Hi Everyone,
I had tried the below query and its working for scenario when parent level from 3,2,1 is having dates less than 4... |
58135 | 29 Jun 2016 @ 11:57 PDT | arkaprava.chandra | General | Reply | Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS | Thanks Sachin,
it's like untill the role is not assigned/granted to any databases, we cannot see the same in 'ALLROLERIGHTS'.
|
58134 | 29 Jun 2016 @ 11:51 PDT | anilkumar922 | Tools | Topic | 2555:TABLE DOES NOT BELONG TO THE MLOAD JOB. | Hi all,
When I tried to load the table I got below error
2555:TABLE DOES NOT BELONG TO THE MLOAD JOB.
I defined all required tables to this load
But still I'm getting this error.
Please su... |
58133 | 29 Jun 2016 @ 11:48 PDT | anilkumar922 | Tools | Topic | 2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD- | Hi all,
When I tried to load the table using mload I'm getting below error
2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD-
could you please suggest how I can overcome this issue??
|
58132 | 29 Jun 2016 @ 08:01 PDT | kchinnad | Teradata Studio | Reply | Terdata Studio - Connection to Hive - Database is not listing | @fgrimmer , Thanks for your response and greatly appreciate your support & guidance on this. In our organisation , we have only this version 15.10.00.04 available at the moment. It will take a ... |
58131 | 29 Jun 2016 @ 04:59 PDT | ddmaddo | Teradata Applications | Reply | Linking/Joining Different Databases in Teradata |
Question to clarify about the QueryGrid T2T CREATE FOREIGN SERVER Command
ip_device / local_ips - The DNS name of the local Teradata nodes or the IP addresses of the local Teradat... |
58130 | 29 Jun 2016 @ 02:54 PDT | CarlosAL | Database | Reply | Syntax Error: WHERE "a"."Field1" IN("b"."Test1", "b"."Test2") | You can turn the "b" SELECT into a subquery and then use the IN clause. You could spare the rest of the "b" columns if you only need Var1 and Var5 and your select list is only a.SITE_ID.
The IN... |
58129 | 29 Jun 2016 @ 02:47 PDT | teradatatester | Database | Topic | Shapefile doesn't load the GEOM part for 1 out of 4 rows? | I have a shapefile that has 4 territories. Three of the territories have a territory name and one is null because it is the row for everything that is outside of the 3 territories.
The shape file ... |
58128 | 29 Jun 2016 @ 01:34 PDT | KellnerK | Database | Reply | Syntax Error: WHERE "a"."Field1" IN("b"."Test1", "b"."Test2") | So is this just a limitation of IN within Teradata? The OR solution works but the real query I'm writing has multiple IN statements already mixed with a bunch of OR and AND, so I was tryi... |
58127 | 29 Jun 2016 @ 01:30 PDT | CarlosAL | Database | Reply | Syntax Error: WHERE "a"."Field1" IN("b"."Test1", "b"."Test2") | Hi.
Replace "CROSS JOIN" with a comma "," and change the IN clause to:
WHERE a.SITE_ID = b.Var1 OR a.SITE_ID = b.Var5
Cheers.
Carlos.
|
58126 | 29 Jun 2016 @ 01:25 PDT | prem.rpk | Database | Topic | Analytical Function for deriving dates | Hi Everyone,
I am new to Teradata forum. Could anyone in forum please help out in deriving an analytical function.
Trying to ... |
58125 | 29 Jun 2016 @ 12:39 PDT | KellnerK | Database | Topic | Syntax Error: WHERE "a"."Field1" IN("b"."Test1", "b"."Test2") | I have a query that cross joins a table of information against a table of dynamic dates that I create on the fly.
For some reason, when using IN, I cannot list multiple fields. It will run a... |
58124 | 29 Jun 2016 @ 12:12 PDT | sham5 | Tools | Reply | bteq export and import for _ET dataparcel | Hi Feinholz,
I tried using the TWBERTBL utility to extract the DataParcel Column in the error table and noticed special characters in the output file. Below is the command thats been used .... |
58123 | 29 Jun 2016 @ 11:44 PDT | ac110057 | Teradata Database on VMWare | Reply | Authentication failure while log in the SUSE Linux Enterprise Server 11 | Which TVME version (15.10, 15.01, 15.0, etc...) and which flavor (Community/Developer/Base edition)? Try logging in directly through the console of your image.
|
58122 | 29 Jun 2016 @ 10:41 PDT | ssavoye | Tools | Reply | TPT load failure on Interval datatype - Error code 7452 | I just reformatted and replaced the plus sign when pulling data out of ORacle as such:
,REPLACE(TO_CHAR(CAST(MAX_HOURS as interval day( 4) to second( 6))),'+',null)
... |
58121 | 29 Jun 2016 @ 10:26 PDT | fgrimmer | Teradata Studio | Reply | Terdata Studio - Connection to Hive - Database is not listing | @kchinnad, Can you upgrade Studio to the latest 15.11 release. We have added additional error checking for Hadoop connections which may help to understand what the problem is. Also, you do not need... |
58120 | 29 Jun 2016 @ 08:37 PDT | longqilong | Teradata Database on VMWare | Topic | Authentication failure while log in the SUSE Linux Enterprise Server 11 | Authentication failure while log in the SUSE Linux Enterprise Server 11
username : root
password : root
Someone help me, please!
|
58119 | 29 Jun 2016 @ 08:02 PDT | poptcorn | Tools | Topic | SQL Assistant: Shortcut creation for "Sel top 10 * from" | Hi all,
I'm fairly new to SQL assistant as I have mostly used SSMS previously. In SSMS you were able to assign queries to shortcuts, and one of the queries I used religiously was "Select ... |
58118 | 29 Jun 2016 @ 07:52 PDT | loafob | Database | Reply | OREPLACE issues between environments | just realized i put this in the wrong sub-forum, apologies, and feel free to move if warranted.
Thanks
|
58117 | 29 Jun 2016 @ 07:49 PDT | loafob | Database | Topic | OREPLACE issues between environments | Hello,
I have a query using OREPLACE that runs in one environment, but fails in another with:
Executed as Single statement. Failed [7509 : HY000] Result Exceeded maximum length... |