Netezza is a line of high-performance data warehouse appliances and advanced in-database analytics applications for uses including enterprise data warehousing, business intelligence, and predictive analytics. In 2010, Netezza became a subsidiary of IBM, and the product was subsequently rebranded as "PDA” In 2019 IBM launched a new generation of Netezza/PDA on the CloudPack for data stack. It runs on both cloud and on-prem specialized CP4D hardware.
Questions tagged [netezza]
1344 questions
0
votes
0 answers
Netezza jpa update not called
Working with netezza through jpa. Trying to update row in a simple table, but nothing happens in database. Updating using merge command.
Select works fine. Any ideas?
jinalu
- 21
- 1
- 4
0
votes
1 answer
Invoke Netezza Stored Procedure From SAS
Is it possible to invoke a Netezza Stored procedure from SAS?If Yes, how it can be done?
Ben
- 45
- 1
- 6
0
votes
1 answer
Select Statement Complicated data transformation
Ok I have 2 tables.
Table A is has a list of transactions for a given client, looks like this
ClientID Transaction Start Stop
1 1 2014-01-01 2014-01-25
Table B is a list of events, looks like this:
ClientID Event StartE …
boomoto
- 311
- 1
- 9
0
votes
1 answer
Netezza SQL: Specify an offset in a window frame
When making the "frame" for a windowed analytic function, one can specify a literal number of rows to "look back" over. E.g., the following will get the trailing 26 weeks weekly sales for a households.
,sum(sales) over (partition by household_id…
Chris
- 1,421
- 3
- 18
- 31
0
votes
1 answer
How to check the data and time that a table was transacted in IBM Netezza SQL from Aginity workbench?
My question may be simple, but, I have been searching the answer for a long time.
How to check the data and time that a table was transacted in IBM Netezza SQL from Aginity workbench?
It is very easy to find this in MS SQL server, but, I cannot…
user1644154
- 54
- 1
- 4
0
votes
2 answers
Netezza - Schedule Stored Procedure
How to schedule a stored procedure in Netezza to run in specific intervals? Looking for replacement of DBMS_JOB or DBMS_SCHEDULER in Oracle . Or is it possible to invoke Netezza stored procedure through shell script?
Thanks
Ben
- 45
- 1
- 6
0
votes
1 answer
error of creating a stored procedure in netezza database from python by pypyodbc
I am working on python (pydev) in Eclipse on win7.
I need to access netezza SQL database from python (pypyodbc) to create a stored procedure.
I can create the stored procedure well from IBM Aginity workbench.
But, I got error of I do this from…
user3601704
- 753
- 1
- 14
- 46
0
votes
1 answer
error of running a stored proceudre in IBM netezza SQL database
I need to create a stored procedure in IBM netezza SQL database from IBM Aginity workbench.
This is my SQL code to create the SP:
CREATE OR REPLACE PROCEDURE "SP_drop_a_table_if_exists"(varchar(128))
RETURNS boolean
EXECUTE AS OWNER
LANGUAGE…
user3601704
- 753
- 1
- 14
- 46
0
votes
2 answers
Netezza/PureData - Bad distribution key chosen in HASH JOIN
I am using Netezza/Pure Data for a query. I have a INNER JOIN (which became a HASH JOIN) on two columns A and B. A is a column that has good distribution and B is a column that has bad distribution. For some reason, my query plan always uses B…
user1836155
- 858
- 14
- 29
0
votes
2 answers
Write a tool to programmatically check Netezza (Pure Data) for skew and get query plan
I am pondering on the idea of writing a .NET tool that connects to a Netezza box with the following functionality:
1. Check distribution/skew of an input list of tables
2. Check query plan of an input query
I know can do that using Aginity Workbench…
Some Newbie
- 1,059
- 3
- 14
- 33
0
votes
1 answer
Sybase to Netezza - attempt to update a target row with values from multiple join rows
im exporting procedures from sybase to netezza and in some of the procedures there is query that keeps giving me the "Update canceled: attempt to update a target row with values from multiple join rows"
Data and table structure on both databases is…
hidross
- 123
- 3
- 16
0
votes
1 answer
Can someone guide on looping from a select statement in netezza
Create or replace procedure total_test_inside()
RETURNS REFTABLE(testtabl)
LANGUAGE NZPLSQL
AS
BEGIN_PROC
DECLARE
prod_id integer;
lkp_weighted_prc numeric(20,3);
rec record;
BEGIN
FOR rec IN select prod_id from weight
LOOP
select weightprice into…
Shruthi Nayak Prabhu
- 1
- 1
- 1
0
votes
1 answer
error if importing a 47G data file to IBM netezza database from Aginity workbench
I need to import a data txt file (47 GB) to IBM netezza SQL database but I gor error:
netezza database error HY000 error: 8 : data partition full
I work from IBM Aginity workbench on win 7.
The netezza server still have enough space.
Any help…
user3601704
- 753
- 1
- 14
- 46
0
votes
2 answers
PowerDesigner: Write Netezza distribution type via VBScript
I'm working with PowerDesigner 16.5 and I'm making a physical model for Netezza 5.0.
I need to place a 'Distribution Type' in the 'Options' tab for each table, which is naturally very important. I'm however looking for a more organized way to place…
DWH Data Modeler
- 13
- 2
0
votes
4 answers
How to resolve the "Error occurred while loading translation library" Linux ODBC connection issue?
After installing unixODBC and the Netezza drivers on a Linux client and configuring ~/.odbcinst.ini and ~/.odbc.ini data sources according to the documentation, attempting to connect to a Netezza PureData warehouse via some tools may yield an error…
DavidJ
- 4,369
- 4
- 26
- 42