360 | 09 Jan 2014 @ 05:08 PST | Tools | Teradata Studio Express | @Gopal, In the Teradata Datatools Preferences, open (click) the Data Source Explorer Load Preferences and you will see the option Show Databases and Users in Hierarchical Display. You can uncheck t... |
359 | 09 Jan 2014 @ 10:00 PST | Tools | Teradata Studio Express | @sk73, We used to get the actual row count from the result set but this can cause long delays when the rows returned is very large. So this was removed. You can manually get the row count via a Sel... |
358 | 07 Jan 2014 @ 09:38 PST | Tools | Teradata Studio 14.10 now available | We are looking into the problem with the drag and drop for Aster.
As each SQL statement execution completes, the results are displayed and the status is posted to the SQL History. Statements... |
357 | 06 Jan 2014 @ 11:21 PST | Tools | Teradata Studio Express | Yes. Connect to both database servers, open the Compare View and drag and drop the table to open the Copy Compare Dialog.
|
356 | 05 Jan 2014 @ 01:32 PST | Tools | Teradata Studio Express | Gopal, the default preference is to show databases and users in hierarchy display with child databases and users nested within the parent. To change to flat display, change the preference. Go to Wi... |
355 | 24 Dec 2013 @ 08:35 PST | Tools | Teradata Studio Express 14.10 now available | @paroul, What is the Teradata Database that you are trying to connect to? Teradata Studio Express is a client tool that allows you to connect to your Teradata Database and run queries. If you do no... |
354 | 23 Dec 2013 @ 01:45 PST | Tools | Teradata Studio Express 14.10 now available | @paroul, The example in the article is just an example. You would replace 'testServer' with the name of your Teradata Database server. If you are testing with Teradata Express, that you dow... |
353 | 22 Dec 2013 @ 11:52 PST | Tools | Teradata Studio Express | @hammadmn, I don't know what the credentials are for you to connect to your Teradata Database. If this is a TD Express VM system, you can try using the IP address of the VM and the username dbc... |
352 | 20 Dec 2013 @ 01:53 PST | Tools | Teradata Studio Express 14.10 now available | Can you try with the current release of JRE 7. Follow this link and grab JRE 7 Download: http://www.oracle.com/technetwork/java/javase/downloads/server-jre7-downloads-1931105.html and give th... |
351 | 20 Dec 2013 @ 01:23 PST | Tools | Teradata Studio Express 14.10 now available | @paroul, Please send me the output from running the java -version command in a DOS window so I can see what version your system will run with.
It should look something like this:
C:\Windows\Syste... |
350 | 20 Dec 2013 @ 09:18 PST | Tools | Teradata Studio Express | @hammadmn, The error message means that the host testServer is unknown to the client. Can you ping the system testServer? It is in your host file. Can you try the IP address to connect to the Terad... |
349 | 19 Dec 2013 @ 02:04 PST | Tools | Teradata Studio Express 14.10 now available | Is it 64 bit version or 32-bit?
|
348 | 19 Dec 2013 @ 01:15 PST | Tools | Teradata Studio Express 14.10 now available | @paroul, What is the version of Java when you run the java -version command from a DOS window?
|
347 | 19 Dec 2013 @ 09:05 PST | Tools | Teradata Studio Express 14.10 now available | Make sure you are running the 64 bit JRE. Look in your TeradataStudioExpress.ini file to see what JRE was chosen during install.
|
346 | 18 Dec 2013 @ 02:37 PST | Tools | Teradata Studio Express 14.10 now available | My first thought is that there is a bitness issues. Can you verify that you are running either the 32-bit JRE and 32-bit Studio or 64-bit JRE and 64-bit Studio. There may also be a log file in the ... |
345 | 18 Dec 2013 @ 09:19 PST | Tools | Teradata Studio | What happens if you run the SQL from Studio? I was able to recreate your problem by entering a bad port number. The default port number is 2406. Are you able to obtain the connection successfully?
|
344 | 17 Dec 2013 @ 10:11 PST | Tools | Teradata Studio Express | @Darcy, I have seen this issue reported within Eclipse. It seems to be that something has become corrupted running Teradata Studio Express within the VM. Can you try to remove the following d... |
343 | 17 Dec 2013 @ 08:51 PST | Tools | Teradata Studio | @Anubeig, If you connecting to Aster from Teradata Studio, you would use the Connection Wizard and we will create the connection string for you. In the last screen of the connection wizard we displ... |
342 | 16 Dec 2013 @ 01:56 PST | Tools | Smart Loader for Hadoop | You would download the ConfigureOozie script to your HDP system and run it as root. It is creating the scripts so probably run in a subdirectory so you can see what it created.
|
341 | 16 Dec 2013 @ 08:47 PST | Tools | Smart Loader for Hadoop | @Qionglinnewbie, As mentioned above, the procedure has changed for Studio 14.10.01. You must download a new version of TDCH (1.0.9a or greater), as well as run the ConfigureOozie script. Please ref... |
340 | 11 Dec 2013 @ 09:00 PST | Tools | Teradata Studio's Copy Objects via Drag and Drop | The copy is intended as a direct copy of the table, including any indexes. Your steps look correct.
|
339 | 06 Dec 2013 @ 09:47 PST | Tools | Teradata Studio Express 14.10 now available | @RFM099, Connecting to the database has not changed so not sure why the performance would be slower. A change was made in the loading of databases, using a hierarchy display. We have fixed an issue... |
338 | 06 Dec 2013 @ 09:40 PST | Tools | Teradata Studio | @tsalonia, Current valid TMODE values are either ANSI, TERA, or DEFAULT. You can set the value to DEFAULT and save your JDBC properties and share with other users to be their default. In the ... |
337 | 04 Dec 2013 @ 03:33 PST | Tools | Teradata Studio products - choosing the right client tool | @anhngo56, The problem is that we don't have a parser for Aster and so the question mark is mistaken for a parameterized query. When I tried the same query on my 14.10.01 Studio, I got a differ... |
336 | 04 Dec 2013 @ 03:05 PST | Tools | Teradata Studio products - choosing the right client tool | @anhngo56, What is the error you are getting when running the query?
|