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
1 answer
Slow execution of sas program in sasgrid platform
I use Unix sas in executing the sas code using sasplex platform.there is always a need to upload huge records into netezza database.i use the following script to connect/upload data into to netezza-
Connect to netezza (user=s password=m…
0
votes
0 answers
Netezza , Create table with more than 4 organizing keys
I need to know if i can create a table with more than 4 organizing keys in Netezza.
I understand CBTs only allow upto 4 organizing keys but my client has a huge table with enormous data and they wanted to have multiple access points for fast data…
user3046781
- 1
- 1
0
votes
1 answer
How to parse all instances of an event from a string using SQL
I am trying to find an instance of '17' in a string.
For eg, it could exist as 10,11,12,17,217
or 17,11,34,23 or 117,18,17,10
117,217,320 is no match, only the ones with '17' in the string
I need to do this using Oracle SQL.
I was thinking of using…
user2917012
- 61
- 4
0
votes
2 answers
Error handling or Exception handling in Netezza
I'm running a netezza sql process as part of a shell script and in one of the sql codes, I want it to raise an ERROR or exception if the number of rows from 2 different tables don't match.
SQL Code:
/* The following 2 tables should return the same…
ML_Passion
- 1,031
- 3
- 15
- 33
0
votes
1 answer
Update Using Double Quotes
I have issue in running the following sql:
update personal_view test set session_state=""
I know it is because of the double quotes within the double quotes and symbols like ; /…
Jude
- 87
- 1
- 9
0
votes
1 answer
Pentaho not retaining the log and temp files
I am running a pentaho ETL kettle transformation(.ktr) to load data from a source db2 database into a destination netezza database.
When I run the transformation, I specify the directory to store the log files and temp .txt files. But after the…
Victor
- 16,609
- 71
- 229
- 409
0
votes
0 answers
Create table in Netezza
Can I create a table in Netezza such that the number of columns are created dynamically that is based on the user input?
Backgroud -
I am trying to implement Pearson Coefficient using Netezza system. This is my homework problem.
My Approch -
I will…
Atul Gupta
- 207
- 1
- 5
- 17
0
votes
1 answer
Aggregate function calls may not be nested ERROR
I am trying to run this query in postgresql but getting this error: "ERROR: Aggregate function calls may not be nested". I am not sure what the problem or a solution for this.
Here is my query:
select a.KEY_NBR, a.MAIN_ID
,
…
moe
- 5,149
- 38
- 130
- 197
0
votes
1 answer
Netezza built insert using dotnet
In my application, instead of using unix am creating user interface using dotnet with backend netezza.
In this scenario i want to load data from excel to netezza db using nzload.
Is this possible?
Anboo
- 103
- 2
- 17
0
votes
1 answer
Columns from mutiple tables in ROW_NUMBER() OVER (PARTITION BY .... ORDER BY ...)
I am using the ROW_NUMBER function like this
SELECT ROW_NUMBER() OVER (PARTITION BY TABLE1.COL1, TABLE2.COL1 ORDER BY TABLE1.COL4) as ROWNUM
FROM TABLE1
JOIN TABLE2
ON ......
The data that I am running this query with returns only one row but the…
cooperjv
- 43
- 2
- 5
0
votes
1 answer
how to finding max of a column which has same values in different rows in netezza
i have a netezza table(transactions table)where there are multiple entries for one account number. i have to pick the latest entry for that account number based on the latest transaction date.if transaction dates are different for that account…
user2893953
- 1
- 1
0
votes
1 answer
issue with add_month date using PostgreSQL
I am trying to use the add_month function but getting an error. I want to get the number of visits between [CAL_DATE - 13 months] and [CAL_DATE]. The format of the dates are as following: 2007-14, 2010-05, 2009-04 and etc. this is the error I am…
moe
- 5,149
- 38
- 130
- 197
0
votes
1 answer
executing query inside column in a table
I have a table A with columns 1.Column 1 contains a query select * from tableD;
I need to execute the query inside column1 using single query if possible..How to do this..
Database is netezza.If u provide ans for oracle Db also fine.
user2819115
- 1
- 1
0
votes
2 answers
extracting a parameter using regexp
I have the data like
U=ms&sv1=5xdUE3w0&sv2=3150912100&sv3=kuqd1nwca0&sv4= altima
U=ms&sv1=5xdUE3w0&sv2=3150912100&sv3=kuqd1nwca0&sv4= altima_dhfdbf&
U=ms&sv1=5xdUE3w0&sv2=3150912100&sv3=kuqd1nwca0&sv4= altima&ddhfy6574dfx
when i use…
Dileep
- 624
- 3
- 10
- 20
0
votes
1 answer
format at Netezza? and the error message is that the data was damaged
I have the following question about my error message. I tried to format first then insert into dw to use.
26 proc sql noprint;
27 connect to netezza (user=jfan0001 pwd=Xw9b548s SERVER=bsnet01z database=PDWAPPRP …
user1238178
- 135
- 3
- 10