#DateForumTypeThreadPost
5303 Oct 2014 @ 02:54 PDTTeradata StudioReplyTools > Create > Database, User etc. dialogs missing in Teradata Studio Express 15I think you are really asking about a change to Teradata Studio (not Studio Express).  Studio was reworked in 15.0 to make many actions appear in the perspective they are appropriate to. There...
5227 Aug 2014 @ 10:26 PDTTeradata StudioReplyTeradata Studio Express V14.10 java.lang.Long cannot be cast to java.lang.Integer The reason is that in Teradata 14.10 the database column holding various objects' Access Count was change from an INTEGER to a BIGINT. Studio Express was reading the objects' access count a...
5123 Jul 2014 @ 04:49 PDTTeradata StudioReplyStudio Express Crashes Immediately After StartingWell, you've uncovered an interesting problem.   What has happened is that you apparently closed the "Data Source Explorer" view then quit Studio Express. Each time you run Stu...
5023 Jul 2014 @ 04:02 PDTTeradata StudioReplyTeradata Studio 15.0 connecting to Hadoop using JDBC failsHave you followed the instructions in the "Teradata Connector for Hadoop Setup" section at the bottom of the Teradata Studio download page (http://downloads.teradata.com/download/too...
4921 Jul 2014 @ 03:58 PDTTeradata StudioReplyMultiple DDL/queries at one time? (Error: Only a COMMIT WORK or null statement is legal after a DDL Statement)There are several ways to run the SQL in the SQL Editor in Studio Express. The toolbar has two Execute buttons. The button with a single triangle (Execute SQL statements as individual statements) s...
4803 Jul 2014 @ 10:14 PDTTeradata StudioReplyUnable to Inlcude Code Comments in Views within Teradata StudioSince you've got multiple CREATE VIEW statements in your script, the statements have to be run individually. It appears to me that you've got the statements in a SQL Editor in Studio and ar...
4706 Jun 2014 @ 08:43 PDTTeradata StudioReplyWhere to see table created in Teradata StudioThe default setting of the preference "Show Databases and Users in Hierarchical Display" is to have the Data Source Explorer show databases that have a database other than DBC as its owne...
4604 Jun 2014 @ 08:45 PDTTeradata StudioReplyWhere to see table created in Teradata StudioYou have to expand the Data Source Explorer a couple of more layers: -Profile name --test ----databases ------All ------bim_services ..... ------test...
4507 Apr 2014 @ 09:43 PDTTeradata StudioReplyHadoop profile creation fails@umerbaig, Do you have the same situation as discussed earlier, that is, where the WebHCatalog service is not running on the Name Node? If so, things might not work even with the workaround I menti...
4403 Apr 2014 @ 10:07 PDTTeradata StudioReplyExport to Hadoop table failsWe noticed that TDCH 1.2.1 fails with the bad parameter. The 1.0.9 (the version we support...we don't yet support TDCH 1.2.1) ignored the parmeter. The configureOozie script for our upcoming r...
4327 Mar 2014 @ 01:32 PDTTeradata StudioReplyHadoop profile creation failsThe Oozie Configure Script does indeed set the WebHCatalog and WebHDFS hosts to be the same as the Name Node. A workaround if either is on a host other than the Name Node is to modify the file in H...
4220 Mar 2014 @ 11:45 PDTTeradata StudioReplyHadoop profile creation failsIs it possible that your Oozie service is not configured to allow your system or user to use the service? What version of Hadoop are you using? In HDP 1.3.2, the Oozie configuration file oozie-sit...
4117 Mar 2014 @ 09:34 PDTTeradata StudioReplyHadoop profile creation failsThe Exception in the first post is the result of a bug in the code that is checking to see that the Hadoop system has been configured to run the import/export jobs. It is indeed a result of the fac...
4006 Mar 2014 @ 08:33 PSTToolsReplyConnect to Microsoft SQL Server from Teradata Studio 14.10The JDBC jars are provided by Microsoft. Try their Microsoft JDBC Driver for SQL Server page at http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx  
3905 Mar 2014 @ 11:13 PSTToolsReplyConnect to Microsoft SQL Server from Teradata Studio 14.10You need to specify the full path names to the SQL Server jars in the "JAR List" tab of the New Driver Definition dialog. You'll need to remove the default jar file names (that don...
3819 Dec 2013 @ 08:40 PSTTeradata StudioReplyUnable to parse simple query: version 14.10.01As Dieter said, there isn't a YEAR function in Teradata. Your SQL appears to be using the ODBC escape function "YEAR". Studio uses JDBC to run queries. The JDBC driver supports JDBC e...
3720 Nov 2013 @ 10:22 PSTTeradata StudioReplyLocation of stored SQL queries inexplicably changesThe Studio workspace by default is created in the directory "workspace-studio" in your user's home directory. Is it possible that your home directory has changed from somewhere on the...
3617 Sep 2013 @ 01:44 PDTTeradata StudioReplyTeradata Studio 14.02 - How can I resort a result set w/o requerying the DB?The Result Set Viewer already has the ability to sort the results on multiple columns. You can click on a column header to sort with respect to the selected column. (Clicking a second time reverse...
3505 Aug 2013 @ 09:49 PDTTeradata StudioReplyAttempting to stop a query or to close connection always hangsWe haven't certified the program on ubuntu and don't have the resources to deal with that distribution. Perhaps the problem is related to an issue with that distribution of Linux. The opera...
3431 Jul 2013 @ 01:38 PDTTeradata StudioReplyGeneral stuff with StudioThe "New Editor" menu item is confusing and is being renamed in future versions. What it does is duplicate the current editor. This gives you the ability to have a large file open in two ...
3331 Jul 2013 @ 11:35 PDTTeradata StudioReplyUsing SQL History tab slows Studio to a crawlWe have seen issues with Studio and Studio Express becoming slow when a query has been run and many more than the default limit of 2000 rows are displayed in the Result Set Viewer. Have you by any ...
3231 Jul 2013 @ 09:06 PDTTeradata StudioReplyAttempting to stop a query or to close connection always hangsWe're going to need more information about the hanging...canceling long-running queries and disconnecting behave well for us. What platform are you running on (Windows, Linux, Mac)? ...
3115 Jul 2013 @ 02:44 PDTTeradata StudioReplyJVM is not suitable for this product error - Taradata Studio ExpressThe problem probably is that the java executable isn't in the path. You can try modifying your PATH environment variable to include the location of java. Another thing you can do that will be ...
3001 Jul 2013 @ 09:17 PDTTeradata StudioReplyUnable To Create Stored Procedure Using JDBC !!Rajeev, I am able to run the DDL you posted (after changing the database name to a valid name). It got created even though the table being inserted into doesn't exist. Running the SP results i...
2929 May 2013 @ 10:22 PDTToolsReplyUnable to open Teradata SQL assistantSorry I didn't notice this message since it didn't reference the tool you're having troubles with (Teradata Studio Express).   Could you post the contents of the log file the mes...

Pages