http://www.enzeecommunity.com/index.jspa All Content in The Netezza Community en Wed, 08 Sep 2010 23:19:11 GMT Clearspace 2.5.3 (http://jivesoftware.com/products/clearspace/) 2010-09-08T23:19:11Z en http://www.enzeecommunity.com/message/4925 It has to be 15MB per dataslice (at least).  Use "select count(*) from _v_dslice" to determine the number of dataslices on your system.   Also you wouldn't see any performance gain unless your source table is physically ordered on the column you Wed, 08 Sep 2010 23:19:11 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4925 2010-09-08T23:19:11Z 1 hour, 47 minutes ago 3 http://www.enzeecommunity.com/message/4915 Netezza does not support CONNECT BY or the recursive version of the WITH statement at this time (not in 6.0 either).  The best way to resolve the issue is at data load time.  Just create multiple tables instead of shoving everything into a single Wed, 08 Sep 2010 20:15:40 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4915 2010-09-08T20:15:40Z 4 hours, 51 minutes ago 1 http://www.enzeecommunity.com/message/4907 I think you might want to try the \o [file] command. That will redirect query output to a file. Wed, 08 Sep 2010 13:49:08 GMT joey.foley@va.gov http://www.enzeecommunity.com/message/4907 2010-09-08T13:49:08Z 11 hours, 18 minutes ago 2 http://www.enzeecommunity.com/message/4906 In Netezza DECIMAL is the same as NUMERIC - they can be used interchangeably and require the same amount of storage etc.   D. Wed, 08 Sep 2010 10:55:03 GMT dave.shuttleworth@edge-a.co.uk http://www.enzeecommunity.com/message/4906 2010-09-08T10:55:03Z 14 hours, 12 minutes ago 1 http://www.enzeecommunity.com/blogs/grill/2010/09/07/exadatas-soa-secondhand-on-arrival I've recently been involved in a rousing exchange out on Linked-In with one of Oracle's employees - on the Exadata machine and how it compares to Netezza. The conversation simply had to stop when the Oracle employee implied that I might be biased. exadata rdbms rac performance oracle secondhand Tue, 07 Sep 2010 19:44:06 GMT dbirmingham@virtualmach.com http://www.enzeecommunity.com/blogs/grill/2010/09/07/exadatas-soa-secondhand-on-arrival 2010-09-07T19:44:06Z 1 day, 5 hours ago http://www.enzeecommunity.com/message/4901 there are otions to show skew in the nzadmin tool - see System Administrattors guide. (search for 'skew')   Also there's a support script (nz_skew) that show the same info.   D. Mon, 06 Sep 2010 14:26:43 GMT dave.shuttleworth@edge-a.co.uk http://www.enzeecommunity.com/message/4901 2010-09-06T14:26:43Z 2 days, 10 hours ago 1 http://www.enzeecommunity.com/message/4899 Has anyone seen or know how to resolve this error: "Not enough memory to partition hash join".  The query that is producing this error runs everyday and has been fine.  While the tables have grown the dataset that is being worked on is pretty constant Sun, 05 Sep 2010 19:07:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4899 2010-09-05T19:07:31Z 3 days, 5 hours ago http://www.enzeecommunity.com/message/4898 I am currently running nzrestore on a 2TB database.  The backup itself is on a snap drive and the new machine where the db is being created is a TwinFin P12.  The utility is being run with -v (verbose) option. Four tables in this db have 2billion+ rec Sun, 05 Sep 2010 14:10:35 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4898 2010-09-05T14:10:35Z 3 days, 10 hours ago http://www.enzeecommunity.com/message/4897 There is no function named "date_trunc" that takes a single argument.  The date_trunc function takes two arguments:   select date_trunc('day', current_timestamp)   If you want to create a custom function that does the same thing as the Oracle Fri, 03 Sep 2010 15:55:49 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/message/4897 2010-09-03T15:55:49Z 5 days, 8 hours ago 4 http://www.enzeecommunity.com/docs/DOC-1172 Hi,   We have a table in the database having CHAR as the key Columns. In few of the forums, I learnt that Netezza provides better performance with Integer Data Type as Key Column while selecting the record or updating the record.   I tried Thu, 02 Sep 2010 18:38:25 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/docs/DOC-1172 2010-09-02T18:38:25Z 6 days, 6 hours ago 1