All comment activity

#DateUserWhereItemComment
648520 Jan 2016 @ 09:37 PSTmannkothariToolsTransitioning from SQL Assistant to Studio ExpressHi -  I am using SQL Assistant 14.10.0.02, and i want to chnage settings for multiple answerset. Currently its opening in multiple tiles, making 4 tiles - 1 for Query,1 for History and 2 for ...
648419 Jan 2016 @ 03:25 PSTcarriecarrie's blogNew opportunities for statistics collection in Teradata 14.0If you want to collect statistics on the instance of a global temp table within your session, you would need to include the word TEMPORARY.  If you do not include TEMPORARY, then stats wi...
648318 Jan 2016 @ 09:12 PSTvic.mirandaToolsGetting Started with Teradata Plug-in for EclipseHi Francine,   I am trying to do a LOB migration SP in JAVA. The SP works with the embedded teradata jdbc driver. However, the moment i start using our external jdbc drivers for my source a...
648218 Jan 2016 @ 07:03 PSTsuhailmemon84Paul Sinclair's Blog on PartitioningTeradata ColumnarGreat explanation Paul. Thanks a lot for answering my questions. -Suhail
648118 Jan 2016 @ 04:32 PSTPaulSinclairPaul Sinclair's Blog on PartitioningTeradata ColumnarFrom a user point of view, either way ends up doing the same thing. The differences are subtle differences in performance due to the way the values are ordered in combination with how data is ...
648018 Jan 2016 @ 01:25 PSTsuhailmemon84Paul Sinclair's Blog on PartitioningTeradata ColumnarI apologize Paul. I still don't understand the difference between the 2 schemes. You mentioned: "1. Row partitioning at first level and column partition at the next level   Column...
647918 Jan 2016 @ 12:23 PSTPaulSinclairPaul Sinclair's Blog on PartitioningTeradata ColumnarTable rows are not sorted by rowid since when dealing with rowids in a CP table, we are talking about the ordering of column partition values by rowid (or in your case with single-column ...
647818 Jan 2016 @ 10:34 PSTsuhailmemon84Paul Sinclair's Blog on PartitioningTeradata ColumnarThanks Paul. I am having a hard time understanding what Teradata does when a table is both row and column partitioned. Especially when column is at first level and row is at second level. I have a...
647718 Jan 2016 @ 09:56 PSTPaulSinclairPaul Sinclair's Blog on PartitioningTeradata Columnarselect * from CPPA table where PA_COLUMN='x';   For a row-partitioned or non-row-partitioned CPPA table (assuming PA_COLUMN is not also a partitioning column), Teradata performs...
647618 Jan 2016 @ 08:30 PSTsuhailmemon84Paul Sinclair's Blog on PartitioningTeradata ColumnarThanks Paul. So if there is a non row partitioned CPPA table with column partition in column format on every single column solely and there is a  select query like:   select * from notr...
647518 Jan 2016 @ 03:19 PSTjammy19031989ToolsEasy Loader for Teradata Parallel Transporter I had rectified the error. I am able to process multiple files using wildcard character.    THanks!! please reply on "Job Variable file" issue alone.
647418 Jan 2016 @ 01:41 PSTjammy19031989ToolsEasy Loader for Teradata Parallel Transportercould you please reply for my above 2 questions?. Early reply would be very much appreciated.   Thanks in advance!
647317 Jan 2016 @ 06:31 PSTPaulSinclairPaul Sinclair's Blog on PartitioningTeradata Columnar1. Does this mean that if there are 2 table rows with the same PA value and the table is column partitioned on the PA column alone with column format, the 2 values may not necessarily share consecu...
647216 Jan 2016 @ 08:03 PSTankitpToolsTeradata Python ModuleHi @Ericscheie, I changed as told, below is the error now.  session = udaExec.connect("TeradataPY");   File "build/bdist.linux-x86_64/egg/teradata/udaexec.py...
647115 Jan 2016 @ 09:24 PSTsuhailmemon84Paul Sinclair's Blog on PartitioningTeradata ColumnarHi Paul, Thank you for the detailed responses. You mentioned: "However, on an AMP, those table rows or their column partition values with the same PA value are not necessarily ...
647015 Jan 2016 @ 07:10 PSTPaulSinclairPaul Sinclair's Blog on PartitioningTeradata ColumnarSuhail, glad to hear from you again and your interest in CPPA. I'll try to answer your questions (plus a little bit more) in the following: 1. If we have a CPPA table, how are the rows on...
646915 Jan 2016 @ 04:34 PSTPaulSinclairPaul Sinclair's Blog on PartitioningTeradata ColumnarTeradata 15.10 introduces column partitioning with a primary index (CPPI) and with a primary AMP index (CPPA). A primary AMP index can be thought of as being halfway between a PI and NoPI -- r...
646815 Jan 2016 @ 02:32 PSTsuhailmemon84Paul Sinclair's Blog on PartitioningTeradata ColumnarAlso, if a CP table has row partition, then is the row partition number stored in the container row header too?
646715 Jan 2016 @ 02:27 PSTsuhailmemon84Paul Sinclair's Blog on PartitioningTeradata ColumnarHi Paul, If we have a CPPA table, then how are the rows on the different AMPS are sorted? All rows with same PA column value go the same AMP? Are rows with the same PA column values colocated to...
646614 Jan 2016 @ 08:25 PSTfirstjcarrie's blogNew opportunities for statistics collection in Teradata 14.0Carrie Just wanted to check whether there is a need to use the key word TEMPORARY when collecting stats on GLOBAL TEMPORARY tables under V14.0 onwards?   COLLECT STATISTICS   &nb...
646514 Jan 2016 @ 03:59 PSTjammy19031989ToolsEasy Loader for Teradata Parallel TransporterIn addition to the above concern, i would like to clarify 1 more concern.   The job variable file looks like below. this is for loading a file into table SourceFileName='/export/home...
646414 Jan 2016 @ 03:49 PSTjammy19031989ToolsEasy Loader for Teradata Parallel Transporteryeah I have tried that but it is throwing an error like the file "X*.txt" is not found. it seems like considering '*' as literal character.  could you please verify once an...
646313 Jan 2016 @ 01:14 PSTericscheieToolsTeradata Python Module@stk8806 - From the stack trace, it appears the connection was successful but the python modules call to "SELECT SESSION" to get the session ID for logging purposes is not returning any d...
646213 Jan 2016 @ 01:02 PSTericscheieToolsTeradata Python Module@ankitp - Try changing  session = udaExec.connect(method="odbc", system="TeradataPY", username="XXXX", password="XXXX"); to session = ud...
646113 Jan 2016 @ 12:37 PSTfeinholzToolsEasy Loader for Teradata Parallel TransporterTry specifying "X*.txt". Error tables are stored on the database, most likely in the same database as your target table.  

Pages