All comment activity

#DateUserWhereItemComment
707208 Sep 2016 @ 04:07 PDTfgrimmerToolsNew Teradata Studio Administration User ExperienceBryan, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
707108 Sep 2016 @ 02:49 PDTfgrimmerToolsStudio 15.11 Available for DownloadSantiago, Can you include the entire stack trace? I am not aware of any problems with loading a volatile table.
707008 Sep 2016 @ 01:26 PDTcarriecarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Nazy,   If you don't collect stats for each separate combination, then there will no histogram where the optimizer can see the number of uniques and the interval values.  So if y...
706908 Sep 2016 @ 10:16 PDTsblanco5ToolsStudio 15.11 Available for DownloadHi, I'm using the Teradata Studio Version 15.11, version 32 and 64 bits, and I was testing the option to load a volatile table. My table is very simple: CREATE VOLATILE TABLE PRUEBA &...
706808 Sep 2016 @ 12:54 PDTsamy@7ToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskHi, I am trying to install oracle ODBC drivers(PROGRESS_DATADIRECT_ODBC_ORACLE_SOL_SPARC_32.tar) in unix to connect to teradata.When I was trying for 1st time,up to some steps it was correctly...
706707 Sep 2016 @ 12:26 PDTcsbandi5426carrie's blogEasing Into Using the New AutoStats FeatureThank you Carrie!! I will go ahead and  enable USECOUNT logging on all required permanent databases to make use of it on DR system as well. Our latest collect job run after we enabled U...
706607 Sep 2016 @ 11:09 PDTnazygholizadehcarrie's blogNew opportunities for statistics collection in Teradata 14.0 Hi Carrie,  Thanks for the explanation... We sometimes have tables with several multicolumn stats having the same number of unique values. In this example: collect stats column (A,...
706507 Sep 2016 @ 09:37 PDTcarriecarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Nazy,   The 32 bytes I mentioned is not directly related to MAXVALUELENGTH.   MAXVALUELENGTH only applies to the number of characters that are stored in the histogram intervals ...
706407 Sep 2016 @ 09:14 PDTDiEgoRToolsTeradata Python ModuleWouldn't it be a good idea to add to the tutorial the recepy for setting the dataframe names to the sql resultset column names? gabnash 2 comments Joined 10/15 16 Oct 2015 cols = [] ...
706307 Sep 2016 @ 08:25 PDTcarriecarrie's blogEasing Into Using the New AutoStats FeatureChandra,   USECOUNT logging is not just used for skipping stats.  It is also used for statistics extrapolation.   You will not get skipping if USECOUNT logging is off, and the...
706207 Sep 2016 @ 06:56 PDTchakradhar.challaConnectivityTeradata Connector for Hadoop now available Hi, I am trying to Import/Export From/To teradata to Hive using TDCH , But getting below issue with CHAR,VARCHAR and DATE data types not supported in TDCH. As an alternate if we change those dat...
706106 Sep 2016 @ 09:25 PDTnazygholizadehcarrie's blogNew opportunities for statistics collection in Teradata 14.0Thanks For the clarification on ROWID......   I have another question.  In the original blog you have the explanation below.  Could you please expand  eon this?  I am not...
706005 Sep 2016 @ 06:08 PDTrajasekhar tToolsStudio 15.11 Available for Downloadhi, please help... how to install sql assitant on windows 7 64-bit .      Thanks Rajasekhar  
705903 Sep 2016 @ 09:32 PDTAbhishek_asterAsterUsing Aster Express: ACT 2, Loading DataThanx Mike for wonderful article, I have completed act-part1 and act-part2, its very informative and well presented. One silly question how we copy and paste(keyboard shortcut) on aster-queen cons...
705802 Sep 2016 @ 09:49 PDTfgrimmerToolsNew Teradata Studio Administration User ExperienceBryan, We are working on getting the statistics display back in the table property form. This is planned for our 16.00 release by end of year. We have added the Drop back to the Query Development&...
705702 Sep 2016 @ 09:24 PDTcsbandi5426carrie's blogEasing Into Using the New AutoStats FeatureThank you very much Carrie!!. We are currently on Release 15.00.04.05 . We recenlty started stats collection using statsmanager on prod system and started with one database to check the runtimes ...
705601 Sep 2016 @ 05:31 PDTBP185029ToolsNew Teradata Studio Administration User ExperienceHi Francine, Is there a way to show the currently collected statistics on a table? As far as I can tell the "Collect Summary" option collects summary statistics on a table while the &quo...
705501 Sep 2016 @ 04:00 PDTcarriecarrie's blogEasing Into Using the New AutoStats FeatureResponse to the comment from 2 days ago:   Chandra,   The amount of time before skipping will be considered by the optimizer depends.  The optimizer usually looks for at least 5 ...
705401 Sep 2016 @ 03:55 PDTcarriecarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerSamir,   Just to be sure that I understand what you mean when you say   " In workload distribution, i see that we have only tactical and timeshare defined"  Are you ...
705301 Sep 2016 @ 11:14 PDTSiva2003ToolsTeradata Python Module@ericscheie .Thanks a lot . It is working just as expected.
705201 Sep 2016 @ 10:27 PDTcsbandi5426carrie's blogEasing Into Using the New AutoStats FeatureHi Carrie, We have primary and DR production systems. I am looking to see any options on copy stats from one prod system to another system since same tables exists both and in sync. Can you please...
705131 Aug 2016 @ 05:02 PDTericscheieToolsTeradata Python Module@Radsubra1 -  Here is a simple example that writes the string representation of the row to a file named "result.txt". with open ('result.txt', 'w') as file: fo...
705031 Aug 2016 @ 02:57 PDTfgrimmerToolsStudio 15.11 Available for DownloadGreg, If you have a version of Studio prior to 15.11, the path to your JRE was stored in the TeradataStudio.ini file. The .ini file is located in your install directory. You can change this to refl...
704931 Aug 2016 @ 02:38 PDTSiva2003ToolsTeradata Python ModuleHi, I want to connect to teradata and execute a sql from  flat file and edirect the output of the file to another sql file. Iam able to connect to teradata and execute a sql from file but in...
704831 Aug 2016 @ 01:30 PDTgbethardyToolsStudio 15.11 Available for Downloadhow do we make this work with the latest version of java?

Pages