#DateForumTypeThreadPost
1523 Aug 2016 @ 02:20 PDTTeradata Database on VMWareReplySetting up Teradata Python Module on VMware imageSpoke too soon.  When I tried to install my teradata module in the new python install it yacked because I didn't have SSL support, so the setup couldn't figure out an https address. I...
1422 Aug 2016 @ 12:30 PDTTeradata Database on VMWareReplySetting up Teradata Python Module on VMware imageI decided I didn't like the Python version from the OSS package (3.3.2) since I wanted to use subprocess.run() so I went back to the install drawing board. using the OSS repo, I found the righ...
1319 Aug 2016 @ 01:37 PDTTeradata Database on VMWareTopicSetting up Teradata Python Module on VMware imageI was trying to run the Python module on my VMware instance, and ran into a stack of problems. The python version on the VM instance (TDExpress15.10.0.7_Sles11_40GB_vp) was 2.6.9 which doesn't...
1225 Jul 2016 @ 02:16 PDTDatabaseReplyUDF Default DatabaseI am looking for the exact same thing.  We have a library of functions that we want to be able to use without having to qualify them.  I was hoping there was a way to add my own database ...
1126 Oct 2015 @ 11:08 PDTTeradata StudioReplyTeradata Studio BugGreat.  If I can be of some kind of help, let me know.  but I hope you can reproduce it easily enough :)  
1022 Oct 2015 @ 12:39 PDTTeradata StudioReplyTeradata Studio BugFrancine,   The problem is that there is no error.  It shows that the query completes successfully, and no rows were returned.  but in fact there are 3+ billion rows in the table....
922 Oct 2015 @ 08:16 PDTTeradata StudioTopicTeradata Studio BugUsing Studio 15.10.4 if I issue select * from very_big_table it will think a while and then return no rows.  with a success code. if I select * from very_big_table sample 2147483646 I get th...
803 Sep 2015 @ 11:41 PDTDatabaseReplyTable Size/NoPI vs PIThanks Todd, That is pretty much the conclusion that I came to.  Interestingly, as I added more months of data do the table, the compression ratio seems to have improved again.  I am gue...
702 Sep 2015 @ 01:25 PDTDatabaseReplyTable Size/NoPI vs PIForcing no BLC turned the NoPI table to 386GB, and the PI table to 386GB also, so I can only assume it is a difference in the ratio of BLC.  Interesting the TPT seems to get very good BLC, and...
602 Sep 2015 @ 12:39 PDTDatabaseReplyTable Size/NoPI vs PISo the oddness continues. Insert/Select from NoPI to NoPI, size remains about 123GB. Insert/Select NoPI to PI, size grows to 218GB.  Insert/Select from PI back to NoPI, size remains around 2...
502 Sep 2015 @ 08:50 PDTDatabaseReplyTable Size/NoPI vs PII copied the table back to a NoPI and it resulted in a 219.77GB .044 skewed table. So now the question is why is the TPT loaded table so much smaller than the insert/selected table?  it will ...
402 Sep 2015 @ 08:40 PDTDatabaseTopicTable Size/NoPI vs PII have a 3 billion record table, which I staged into a NoPI table, with BLC.  the table shows as 123.39 GB, skew factor .077   when I insert/select that into a table with a PI on a col...
326 Apr 2012 @ 12:17 PDTToolsReplyFastload DateTime, Timestamp How about throw away the time portion with a unused field? data 30,2011-01-01 00:00:00 40,2011-11-21 00:00:00   fastload script sessions 20; errlimit 10225; sleep 6;...
215 Mar 2012 @ 10:49 PDTDatabaseReplyError 7691 P1 :Table used in cursor select is restructured from compile-time to run-time I ran into the same problem.  I tried: SET SESSION DATEFORM=INTEGERDATE; Replace Proc.... Call Proc... And got another fun error: CALL Failed: [100047] Unsupported Terad...
113 Jul 2006 @ 12:50 PDTThird Party SoftwareReplyIssue using Informatica to load Teradata tables.It has been a while since I did informatic, but you set up a Teradata loader as a "writer" in the session tool.you then set your target to file instead of database, and choose your teradata writer....