All forum activity

#DateUserForumTypeThreadPost
4827803 Mar 2015 @ 12:13 PSTronaldcheng6ConnectivityReplyConnecting 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....
4827702 Mar 2015 @ 11:57 PSTTeradata_SADatabaseReplyCOLLECT STATS TD V14.10I 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...
4827602 Mar 2015 @ 09:58 PSTronaldcheng6DatabaseReplyHibernate Teradata dialect issueDear 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...
4827502 Mar 2015 @ 04:05 PSTFredDatabaseReply'at time zone' not working in UPDATE/INSERTstatementAT 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...
4827402 Mar 2015 @ 03:08 PSTFredDatabaseReplyCollecting Statistics on Global Temporary TablesThe 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...
4827302 Mar 2015 @ 01:50 PSTssriniDatabaseReplyCOLLECT STATS TD V14.10The below link will help.   http://developer.teradata.com/blog/carrie/2012/08/new-opportunities-for-statistics-collection-in-teradata-14-0#comment-132990
4827202 Mar 2015 @ 01:48 PSTdnoethCloud ComputingReplyVM Express GDO file isf.gdo is corrupted(?)You shouldn't have to send beer to Munich :-)
4827102 Mar 2015 @ 01:21 PSTdnoethDatabaseReplyFailure 9128 The transaction exceeded the maximum number of rowhash locks allowedEvery 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 ...
4827002 Mar 2015 @ 12:54 PSTNetFxConnectivityReplySlow Record Loading into Teradata - with or without PKThis 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....
4826902 Mar 2015 @ 11:44 PSTykazarovDatabaseReplyFailure 9128 The transaction exceeded the maximum number of rowhash locks allowedI am having the same issue. Using .NET to insert one million rows into teradata - errors out as follows: Teradata.Client.Provider.TdException was caught   HResult=-2147467259  ...
4826802 Mar 2015 @ 11:35 PSTmlachlanDatabaseReplyTranspose rows to columnsI'm having a Table called Test_Pivot which looks like ID   VALUE  MONTH 1    5          201501 1    ...
4826702 Mar 2015 @ 11:31 PSTykazarovConnectivityReplySlow Record Loading into Teradata - with or without PKAnother update:  Getting error trying to insert 1,000,000 rows into a table using UpdateBatchSize = 10 Teradata.Client.Provider.TdException was caught   HResult=-2147467259 &...
4826602 Mar 2015 @ 10:54 PSTykazarovConnectivityReplySlow Record Loading into Teradata - with or without PKNetFx, 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 ...
4826502 Mar 2015 @ 10:36 PSTLeonardBurkhardtTeradata StudioTopicMissing tablesAfter 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...
4826402 Mar 2015 @ 10:22 PSTjwh_wsCloud ComputingReplyVM 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...
4826302 Mar 2015 @ 10:04 PSTtomnolanConnectivityReplyDoes 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...
4826202 Mar 2015 @ 05:12 PSTTeradata_SADatabaseTopicCOLLECT STATS TD V14.10Consider 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 ; COLLEC...
4826102 Mar 2015 @ 05:06 PSTgunnUDAReplyPass Through in SASPlease answer if there is a way to keep connection alive between multiple proc sql's? For example: proc sql; connect to teradata as tera (user=testuser pass=testpass); quit; and then...
4826002 Mar 2015 @ 04:32 PSTTeradata_SADatabaseReplyALTER TO CURRENTThanks Dieter !
4825902 Mar 2015 @ 12:13 PSTJens.bertelsenGeneralTopicCan 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...
4825801 Mar 2015 @ 11:37 PSTdnoethCloud ComputingReplyError while opening downloaded TD14 expressHi 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...
4825701 Mar 2015 @ 11:11 PSTdnoethCloud ComputingReplyVM 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...
4825601 Mar 2015 @ 10:49 PSTMaheshJessyDatabaseReplyPatching and Versioning Hi Team, 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...
4825501 Mar 2015 @ 09:28 PSTs_reddyConnectivityTopicDoes 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?
4825401 Mar 2015 @ 09:17 PSTyashaDatabaseTopic'at time zone' not working in UPDATE/INSERTstatementHi-   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...

Pages