Jive SBS Recent Blog Comments Syndication Feed

RE: Netezza Variable ?

communityadmin@netezza.com — Thu, 15 Sep 2011 20:31:04 GMT

Hi Pedro -

This is pretty easy to do with a shell script wrapper:

#!/bin/sh

DATE_START=`date +%Y-%m-%d\ %H:%M:%S -d "2 days ago"`
DATE_END=`date +%Y-%m-%d\ %H:%M:%S`

nzsql BLAHDB -c "select blah, time2 from blahtable where time2 between '$DATE_START' and '$DATE_END'"

Probably a way to do it with by updating from an explicit temp table as well, but would need to work out the details.

RE: Why SPU fails

communityadmin@netezza.com — Wed, 25 May 2011 13:27:25 GMT

In versions of Mustang prior to 4.6.2 P20 there were cases , where a particular query may cause a SPU reset, but never a SPU failure. As jeskier said, wear and tear of disks and the read write head (FPGA) is the main reason for SPU failures.

RE: error:Unable to identify an operator '//' for types 'NUMERIC' and 'NUMERIC'

communityadmin@netezza.com — Thu, 10 Feb 2011 16:30:24 GMT

My suggestion would be to break down the query into smaller parts and isolate the problem spot. This query is very complex and honestly looks very proprietary as well.

Without isolating the problem spot, there's no way to determine what is wrong.

Likewise, we cannot determine what is wrong because only you have access to the underpinning DDL. Don't post the DDL here, as (again) this looks very proprietary.

Divide and conquer

RE: Why SPU fails

communityadmin@netezza.com — Mon, 29 Nov 2010 14:10:26 GMT

If you run checkspu it will likely point you at the cause of the SPU failure.

There is no SQL which can cause the SPU to fail. Likewise the number of records does not impact spu failure rates. Heat on the other hand does impact component life. SPU's are computers and like all computers they can fail for many reasons: memory, network, CPU, power supply, disk and other component failures. Most SPU failures are in fact disk failures. Disk like car tires have a useful lifetime and the disk in warehouse systems are very heavily exercised. This is true of all systems, but in the Netezza system SPU's have the disk attached so when a disk fails the SPU also fails.

RE: Encryption of data between Oracle and Netezza

communityadmin@netezza.com — Mon, 17 May 2010 09:17:23 GMT

It's my understanding that the AES algorithm is a well defined and publicly accessible standard and so providing there are no issues with differing charcater sets (especially little-endian vs big endian - though it's possible to code around this by byte swapping) between the 2 systems a string encoded on (say) oracle should be able to be decoded on a different system (e.g. Netezza) as long as the key is known

(BTW I implemented the AES algroithm in the Edge Associates 'ECLIPSE' library - see http://www.edge-a.co.uk/edgeeclipse.html for info)

Dave Shuttleworth

Edge Associates

www.edge-a.co.uk

RE: Encryption of data between Oracle and Netezza

communityadmin@netezza.com — Mon, 17 May 2010 05:29:18 GMT

Netezza do support AES encryption through add-on tool kits. However the implementation may differ between Netezza and Oracle. Therefore I think we cannot decrypt the passed values using keys.

-AD

RE: Deployment

communityadmin@netezza.com — Tue, 01 Dec 2009 05:39:16 GMT

Mike,

Good to hear from you. Last time I was down by Fort Gordon, I walked onto the 7th green and shook hands with Arnold Palmer during a Masters practice round. Bet you can't guess the year!

Anyway, if you stop by ATL before heading off for combat skills training, let me know. Dinner, beer and cigars on me!

Warmest regards,

Jeff

RE: Select data from table insert into flat file...

communityadmin@netezza.com — Fri, 06 Nov 2009 22:21:29 GMT

Or to land on a PC

CREATE EXTERNAL TABLE 'c:\temp\pc_example.csv'

USING( format 'text'

compress false

delimiter '|'

remotesource 'odbc'

)

select 1 anchor,decm_code,replace(condition_status_description,';',',') etg_desc from foo_etg_icd9 where lower(etg_desc) like '%diabetes%'

RE: Select data from table insert into flat file...

communityadmin@netezza.com — Tue, 20 Oct 2009 15:29:50 GMT

more spontaneously, try:

nzsql -d mydatabase -A -q -t -c "select * from tablename;" > flatfilename.dat

RE: Happy Belated Birthday Oracle Exadata (aka Database Machine)

communityadmin@netezza.com — Thu, 01 Oct 2009 12:36:31 GMT

You were definitely right re the performance ads being commissioned Tim - see http://www.theregister.co.uk/2009/09/29/tpc_slaps_oracle/

Maybe a bit to quick for their own good?