|48278||03 Mar 2015 @ 12:13 PST||ronaldcheng6||Connectivity||Reply||Connecting to Teradata is very solwly(5 sec)||Dear Tomnolan,
Thank for your replying, I have used System.out.println(new Date()) to prove what process get many sec and then getting "stmt = conn.createStatement()" takeing 5 Sec long.... |
|48277||02 Mar 2015 @ 11:57 PST||Teradata_SA||Database||Reply||COLLECT STATS TD V14.10||I see there is a question posted in that feed :
Will existing table level collect stats statements utilize multiple stats in one scan when possible?
Carrie Answered :
1. First, you have to re... |
|48276||02 Mar 2015 @ 09:58 PST||ronaldcheng6||Database||Reply||Hibernate Teradata dialect issue||Dear Drepshas,
I saw log messages show DB connect to Teradata Db,default Schema is PAD, but it should connect to Schema PCORE and concern if it set “spring.jpa.hibernate.ddl-auto:create... |
|48275||02 Mar 2015 @ 04:05 PST||Fred||Database||Reply||'at time zone' not working in UPDATE/INSERTstatement||AT time zone offset '+3:00' only appears to work in the SELECT because your session time zone offset is +00:00 and you are ignoring the time zone of the result.
Internally, timestamps... |
|48274||02 Mar 2015 @ 03:08 PST||Fred||Database||Reply||Collecting Statistics on Global Temporary Tables||The second form (with TEMPORARY keyword) collects statistics on your session's materialized instance of the GTT.
For a GTT, the first form only defines (dummy) statistics on the base... |
|48273||02 Mar 2015 @ 01:50 PST||ssrini||Database||Reply||COLLECT STATS TD V14.10||The below link will help.
|48272||02 Mar 2015 @ 01:48 PST||dnoeth||Cloud Computing||Reply||VM Express GDO file isf.gdo is corrupted(?)||You shouldn't have to send beer to Munich :-)
|48271||02 Mar 2015 @ 01:21 PST||dnoeth||Database||Reply||Failure 9128 The transaction exceeded the maximum number of rowhash locks allowed||Every single row Insert needs a RowHash-lock.
If there's one million rows inserted within a single transaction this will result in one million RowHash-locks.
So either don't do it within ... |
|48270||02 Mar 2015 @ 12:54 PST||NetFx||Connectivity||Reply||Slow Record Loading into Teradata - with or without PK||This is a Teradata Database error/limit. The application starts a transaction and then attempts to load 1,000,000 rows; each row inserated results in a rowhash lock (the table has a primary-key; i.... |
|48269||02 Mar 2015 @ 11:44 PST||ykazarov||Database||Reply||Failure 9128 The transaction exceeded the maximum number of rowhash locks allowed||I am having the same issue. Using .NET to insert one million rows into teradata - errors out as follows:
Teradata.Client.Provider.TdException was caught
|48268||02 Mar 2015 @ 11:35 PST||mlachlan||Database||Reply||Transpose rows to columns||I'm having a Table called Test_Pivot which looks like
ID VALUE MONTH
1 5 201501
1 ... |
|48267||02 Mar 2015 @ 11:31 PST||ykazarov||Connectivity||Reply||Slow Record Loading into Teradata - with or without PK||Another update:
Getting error trying to insert 1,000,000 rows into a table using UpdateBatchSize = 10
Teradata.Client.Provider.TdException was caught
|48266||02 Mar 2015 @ 10:54 PST||ykazarov||Connectivity||Reply||Slow Record Loading into Teradata - with or without PK||NetFx,
Thank you for the response.
First suggestion cut the load time in half. Thank you!
One thing I found about the second was that precision and scale are not contained in DataColumn objects ... |
|48265||02 Mar 2015 @ 10:36 PST||LeonardBurkhardt||Teradata Studio||Topic||Missing tables||After successfully connecting to the teradata server. I do not see any of the tables in the database.
it pings successfully. I can connect to the data all... |
|48264||02 Mar 2015 @ 10:22 PST||jwh_ws||Cloud Computing||Reply||VM Express GDO file isf.gdo is corrupted(?)||Thanks Dieter! I can verify that deleting the file and restarting PDE as you suggested did the trick. Whew! I've been using these VM's since they were released on all vers... |
|48263||02 Mar 2015 @ 10:04 PST||tomnolan||Connectivity||Reply||Does TeraJDBC works with JDK/JRE 8 version?||We are currently in the process of testing Teradata JDBC Driver 15.0 with JDK 8 on all our supported platforms. When that process is done, we will update the Supported Platforms matrix here on Deve... |
|48262||02 Mar 2015 @ 05:12 PST||Teradata_SA||Database||Topic||COLLECT STATS TD V14.10||Consider the following.
I create an employee_table and then create and execute individual collect stats commands as follows
COLLECT STATISTICS on Employee_Table COLUMN Employee_No ;
|48261||02 Mar 2015 @ 05:06 PST||gunn||UDA||Reply||Pass Through in SAS||Please answer if there is a way to keep connection alive between multiple proc sql's?
connect to teradata as tera (user=testuser pass=testpass);
and then... |
|48260||02 Mar 2015 @ 04:32 PST||Teradata_SA||Database||Reply||ALTER TO CURRENT||Thanks Dieter !
|48259||02 Mar 2015 @ 12:13 PST||Jens.bertelsen||General||Topic||Can we run Teradata/Aster Express on VMWare ESXi?? ||Hi
Can we run Teradata/Aster Express on VMWare ESXi??
Anyone having experience with that reasent years? I can see old treads taking about not possible to do, but have things c... |
|48258||01 Mar 2015 @ 11:37 PST||dnoeth||Cloud Computing||Reply||Error while opening downloaded TD14 express||Hi Samir,
did you unzip using the 7zip utility or Windows built-in? Windows unzip chokes on large files...
This is from http://developer.teradata.com/database/articles/introduction-to-terada... |
|48257||01 Mar 2015 @ 11:11 PST||dnoeth||Cloud Computing||Reply||VM Express GDO file isf.gdo is corrupted(?)||Check /etc/opt/teradata/tdconfig/Backup for a copy of the gdo.
Otherwise you might simply delete the gdo, it will be automatically recreated with default values when the PDE starts. Of course... |
|48256||01 Mar 2015 @ 10:49 PST||MaheshJessy||Database||Reply||Patching and Versioning||
Can you pls let me know if you have any impact due to the patch Installation…any impact to the current work or next releases
1. Teradata minor patch... |
|48255||01 Mar 2015 @ 09:28 PST||s_reddy||Connectivity||Topic||Does TeraJDBC works with JDK/JRE 8 version?||From the latest version of TeraJDBC .It's currently works with JDK/JRE 1.4.2, 5.0, 6.0, or 7.0.
Is there any TeraJDBC version that is supporteed and works with JRE8?
|48254||01 Mar 2015 @ 09:17 PST||yasha||Database||Topic||'at time zone' not working in UPDATE/INSERTstatement||Hi-
Iam trying to convert timestamp column from PST to EST. In order to achieve that, I used at time zone '+3:00' to add 3 hours. But it is not helping out. The same... |