| 58116 | 29 Jun 2016 @ 06:26 PDT | sachin.sebastian | General | Reply | Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS |
DBC.RoleInfo view provides information of all roles defined (It is derived from DBC.Roles table)
DBC.AllRoleRights view provides information about the rights granted to each role
You can fi... |
| 58115 | 29 Jun 2016 @ 05:55 PDT | arkaprava.chandra | General | Topic | Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS | HI All,
Could you please tell us, what is the basic difference between DBC.ROLEINFO and DBC.ALLROLERIGHTS?
Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS.
Thanks,
A... |
| 58114 | 29 Jun 2016 @ 04:08 PDT | M.Saeed Khurram | Extensibility | Reply | urgent : xml conversion | Hi,
This is a very strange issue. I tried to multiple solutions but this problem is something need to be reported to CS. I was able to get only the folowing information from TD docs.
7504 in U... |
| 58113 | 29 Jun 2016 @ 03:27 PDT | CarlosAL | Database | Reply | Difference between NOT IN() AN NOT(COL1 IN)) | Hi.
The two "IN" expresions are equivalent. Have you experienced any performance difference? If so, post the execution plan.
NOT IN is not the same as NOT EXISTS if NULLs are prese... |
| 58112 | 28 Jun 2016 @ 11:03 PDT | M.Saeed Khurram | Tools | Reply | Look up in TPT | NO. As you will be using two separate operators: FileReader to read the file and export to select data from table.
Why dont you load the file in step-1 into a temp table, and use that table ... |
| 58111 | 28 Jun 2016 @ 10:57 PDT | kchinnad | Teradata Studio | Reply | Terdata Studio - Connection to Hive - Database is not listing | Teradata Workspace Log:
2016-06-29 13:55:18,872 Teradata Datatools [Worker-8] ERROR c.teradata.datatools.hadoop.catalog - null
java.lang.NullPointerException: null
at com.teradata.datat... |
| 58110 | 28 Jun 2016 @ 10:20 PDT | M.Saeed Khurram | Database | Reply | Transaction control in BTEQ script | Is there a limitation to write this complex logic in BTEQ? Why dont you write a stored procedure and call that SP in BTEQ script?
|
| 58109 | 28 Jun 2016 @ 10:17 PDT | M.Saeed Khurram | Aster | Reply | using Teradata Stored Procedures to pull data into Aster | One possible option is to execute the procedure on Teradata and store the results in a table, then use that table as source in load_from_teradata MR function.
|
| 58108 | 28 Jun 2016 @ 10:04 PDT | Niruban | Tools | Topic | Look up in TPT | Hi All,
Can anyone kindly let me know is it possible to perform look up in TPT ? I am having around 100K record in a file. I want to load it into a table by looking up another table(by joining a c... |
| 58107 | 28 Jun 2016 @ 09:51 PDT | Niruban | Tools | Reply | TPT load failure on Interval datatype - Error code 7452 | Hi All,
Is it possible to join data from a flat file with table in TPT? I am having around 1K records in flat file and I need to look up a column in the file with a table and load it into another ... |
| 58106 | 28 Jun 2016 @ 09:35 PDT | ssavoye | Tools | Reply | TPT load failure on Interval datatype - Error code 7452 | It actually loads if data is formatted without the plus (+). Negative works. I am not sure why, but looks like I will have to replace the plus with null when I pull from Oracle. S... |
| 58105 | 28 Jun 2016 @ 09:04 PDT | pushkarcse | Database | Reply | COLUMNAR TABLE- SELECT TOP N* FROM COLUMNAR TABLE NOT GIVING OUTPUT | Please find the ticket details.
RECGVS2J6
Please let me know if any other information is required.
|
| 58104 | 28 Jun 2016 @ 08:54 PDT | pushkarcse | Database | Reply | COLUMNAR TABLE- SELECT TOP N* FROM COLUMNAR TABLE NOT GIVING OUTPUT | Hi Todd,
I have created one incident to Teradata support Team. They are still analysing the issue.I will share the ticket as soon as possible.
|
| 58103 | 28 Jun 2016 @ 08:45 PDT | ToddAWalter | Database | Reply | COLUMNAR TABLE- SELECT TOP N* FROM COLUMNAR TABLE NOT GIVING OUTPUT | Was it possible to create an incident for this?
We did some testing and were unable to reproduce the issue. If there is an incident, please share the incident #. If not, perhaps some... |
| 58102 | 28 Jun 2016 @ 08:14 PDT | kchinnad | Teradata Studio | Topic | Terdata Studio - Connection to Hive - Database is not listing |
OS : Windows 7 Professional
system type : 64-bit OS
Memory : 4 GB
TD Studio version : Teradata Studio nt-x8664 15.10.00.04 - TERADATA_STUDIO_1510_X64_V1_INSTALL
Hadoop Distributi... |
| 58101 | 28 Jun 2016 @ 02:46 PDT | mm185159 | Viewpoint | Reply | Impact CPU | Thank-you for your response. That is fundamentally all I was looking for, a general rule of thumb or best practices guideline. 3x seems fair, although on long running jobs, 2x might be a significan... |
| 58100 | 28 Jun 2016 @ 02:44 PDT | fgrimmer | Teradata Studio | Reply | Issue Downloading Studio even After Java installed | Since this is a new install, you may want to use the latest version of Studio Express which 15.11. It is available on the Teradata Developer Exchange Download site.
|
| 58099 | 28 Jun 2016 @ 02:44 PDT | ssavoye | Tools | Topic | TPT load failure on Interval datatype - Error code 7452 | Any assistance would be welcomed. I cannot seem to put the Interval in a format that Teradata likes. The column data looks like "00 02:00:00.000000". We are extracting i... |
| 58098 | 28 Jun 2016 @ 02:43 PDT | fgrimmer | Teradata Studio | Reply | Issue Downloading Studio even After Java installed | Because your system is a 64-bit system, 64-bit applications will go in Program Files and 32-bit applications will go in Program Files (x86).
The problem looks like Studio Express is being executed... |
| 58097 | 28 Jun 2016 @ 02:41 PDT | mm185159 | Aster | Reply | using Teradata Stored Procedures to pull data into Aster | So, I am trying to call a teradata stored procedure due to complex processing that works best on teradata (push-down). The stored procedure then returns a result set (dynamic data set) which needs ... |
| 58096 | 28 Jun 2016 @ 02:37 PDT | emchisholm | Teradata Studio | Reply | Issue Downloading Studio even After Java installed | looks like some sort of issue with TeradataStudioExpress__win64_x86.15.10.01.01 ... TeradataStudio__win64_x86.15.10.00.02 installed and works fine.
|
| 58095 | 28 Jun 2016 @ 02:02 PDT | don.brown | Tools | Topic | TDwallet installation | I'm new to using Teradata and would like to use tdwallet in some of the scripts I am creating. The person who installed our client software (RedHat Linux) did not install tdwallet. ... |
| 58094 | 28 Jun 2016 @ 01:58 PDT | emchisholm | Teradata Studio | Reply | Issue Downloading Studio even After Java installed | Ughh ... I swear from what we determined that is was the 64 bit version ... I got another version and got it to install .. but it installed in the "C:\Program Files" folder and I wou... |
| 58093 | 28 Jun 2016 @ 11:55 PDT | boagus1 | Database | Topic | Difference between NOT IN() AN NOT(COL1 IN)) | A developer on our project is using logic that I can't find in any Teradata documentation, so I was hoping for some insight on it's performance.
NOT(ORDER_ID IN (2,3,4) is how it's cod... |
| 58092 | 28 Jun 2016 @ 11:34 PDT | Ivyuan | Tools | Reply | FastExport : SET SESSION SEARCHUIFDBPATH | Hi,
You can send the SQL after the LOGON statement and before .BEGIN EXPORT statement. Here is an example:
.LOGTABLE fexplog;
.LOGON <the tdpid>/<the user id>, <the user password&... |
