|39746||09 Mar 2014 @ 10:25 PDT||terdatacareer||Database||Reply||AMP Down||i am using teradata in my local system.when i am selceting some quries i am also getting same error .how can i slove this error.please help me
|39745||09 Mar 2014 @ 09:42 PDT||dnoeth||Database||Reply||finding links between two col values..||If there are cycles you need to detect them, the only way is to built a materialized path and check if the current value is already included. And if there's no way to find out the actual start ... |
|39744||09 Mar 2014 @ 12:38 PST||paulxia39||Database||Reply||Cannot start Teradata on VM. Using non-admin logon of the computer.||@dnoeth,I have this question too.
|39743||08 Mar 2014 @ 11:48 PST||asmr_psgtech||Database||Topic||Holding a state of variable||Hi,
I have a scenario where we need to capture the state of the first records. The first field is the key(id) . Status can be 1(Active) or 0(Inactive), From the input, as the eff_to date for the f... |
|39742||08 Mar 2014 @ 09:34 PST||taruntrehan||Database||Reply||Teradata Express for WIN 32 BIT||Hi All,
After reading this discussion and all support from the posts; i was able to setup TD on my personal laptop.
Wrote a post of my experience here :
|39741||08 Mar 2014 @ 11:31 PST||BPP||Database||Reply||finding links between two col values..||Dieter, may be I did not understand when you said circular reference and may be it found me :-((
here is real dataset.. we got case 1) a= b and b = a and then case 2) we got a =... |
|39740||08 Mar 2014 @ 07:29 PST||VandeBergB||Database||Reply||How is the Node Decided||Hi Mithun,
It's all about the Primary Index. Teradata uses a fixed hash map to determine where to put each row, based upon the hash result of the primary index column(s).
The pars... |
|39739||08 Mar 2014 @ 05:29 PSTemail@example.com||Training||Reply||Any best Training Centres you guys know in Hyderabad??||Hi sudheer,
How was the training with Manohar and how long days it took.
I am planing for teradata training.
Can you give ur contact details so that i can call you and g... |
|39738||08 Mar 2014 @ 02:58 PST||dnoeth||Database||Reply||COMPRESSION for TIMESTAMP field in TD14||Compression for TIME and TIMESTAMP was introduced in TD14.10
|39737||08 Mar 2014 @ 02:55 PST||dnoeth||Database||Reply||qualify rank() over (partition.....question||Hi John,
- is rnk based on the same sort as start and end date, i.e. are the dates for the first row within the group always the lowest?
- is rnk actually a unique number without... |
|39736||08 Mar 2014 @ 12:42 PST||mithunganguly||Database||Topic||How is the Node Decided||Hi,
I am new to teradata and reading the Teradata Architecture. I understand the concept of nodes and AMP. But I am unbale to figure out, when I am running an SQL Query, how does the Physic... |
|39735||07 Mar 2014 @ 11:22 PST||newb1||Cloud Computing||Reply||Teradata Express for VMware Player Are Downloads Working ?||Teradata Studio Express is too complicated. Surely this a more simple platform to perform SQL queries on.
|39734||07 Mar 2014 @ 11:19 PST||newb1||Cloud Computing||Reply||Teradata Express for VMware Player Are Downloads Working ?||
Could not connect to Test Teradata Database.
Error creating SQL Model Connection connection to Test Teradata Database. (Error: [Teradata JDBC Driver] [TeraJDBC 14.00.00.01] [Error 1000] [SQLStat... |
|39733||07 Mar 2014 @ 09:11 PST||BPP||Database||Reply||finding links between two col values..||thank you Dieter. grouping them is key for me and you made it look so simple. I am eliminating circular references, I do not need them.
This is one of the many knots I got to resolve.. thanks agai... |
|39732||07 Mar 2014 @ 08:07 PST||n_shashi||Database||Topic||COMPRESSION for TIMESTAMP field in TD14||Hi,
Can we compress Timestamp field in TD14 (I know that Timestamp fields for only NULL values can be compressed in earlier versions). If yes, can the syntax also be provided?
|39731||07 Mar 2014 @ 03:06 PST||teradatauser2||Enterprise||Reply||TaraGui||1. For restore, the table/object should already be present ( the definition ). While copying, the table will be dropped and created if already present and will be created as per backup defn, if not... |
|39730||07 Mar 2014 @ 01:48 PST||dnoeth||Database||Reply||utf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding?||UTF8TO16? There's no such function built-in.
There's only TransUnicodeToUTF8 and TransUTF8ToUnicode, but those are compression UDFs (changing internal storage from UTF6 to UTF8 to sav... |
|39729||07 Mar 2014 @ 01:42 PST||dnoeth||Database||Reply||finding links between two col values..||You just have to find the root level, then i's easy :-)
WITH RECURSIVE match(grp, col1, col2, levl) AS
SELECT col1, col1, col2, 0 AS levl
FROM val AS t1
WHERE NOT EXISTS
|39728||07 Mar 2014 @ 11:46 PST||BPP||Database||Reply||finding links between two col values..||Santanu84: thought about it but dont know where I am going with it.. If someone can play with this code and try it out that would be very helpful...
CREATE VOLATILE TABLE val
|39727||07 Mar 2014 @ 11:21 PST||fgrimmer||Teradata Studio||Reply||Teradata Studio stuck||Can you try deleting the Teradata Studio Express workspace and try to launch again? It gets created in your <User> directory and called workspace.
|39726||07 Mar 2014 @ 11:17 PST||fgrimmer||Teradata Studio||Reply||Studio Express 14.10 Startup Error||Can you verify that you have the correct 32-bit or 64-bit version of Studio Express and JRE. Is there an error log in your configuration directory?
|39725||07 Mar 2014 @ 10:59 PST||mauro49||Training||Reply||Teradata Training Material available||
thanks to the availability of the material, I have to prepare 2/3 people to work on a Teradata DB, introduction and advanced SQL, all the material to educate new employees.... |
|39724||07 Mar 2014 @ 10:51 PST||kallu2020||Database||Topic||utf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding?||UDF : utf8to16 function:
why is it known as Latin to Unicode conversion function when utf8 and 16 both represent unicode encoding?
|39723||07 Mar 2014 @ 09:22 PST||tgattone||Teradata Studio||Topic||Studio Express 14.10 Startup Error||I was able to run 14.01 on my Windows 7 laptop but after installing 14.10 today, I just get a popup window saying "Java was started but returned exit code=1".
I have both Java 1.6 and 1.... |
|39722||07 Mar 2014 @ 05:53 PST||ftatarli||Teradata Studio||Topic||Teradata Studio stuck||Everytime I open Teradata Studio Express 14.0, I got 98% CPU usage (the name of process in System Monitor is Java) and then stuck.
If I try close I got the message "The window Teradata Studio... |