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
use Python to read txt file with SQL code in it and execute that code
I have a series of SQL scripts. I want to use Python to read each of those files and execute that code against Netezza.
Here's what I've got so far, but it doesn't seem to actually do anything.
My SQL script (this table starts with plenty data in…
ADJ
- 4,892
- 10
- 50
- 83
0
votes
1 answer
How to use row_number and partition function in sqldf
Update
I can run below sql query in netezza database, but it goes wrong in sqldf package in R
> sqldf("SELECT TEXT,
+ VEH_MAKE_NM,
+ NEW_USED_CD,
+ PRODUCT,
+ OVERALL_SUBV_IND,
+ AS_OF_DATE,
+ CATEGORY,
+ ROW_NUMBER() OVER(PARTITION BY TEXT,…
WayToNinja
- 285
- 4
- 14
0
votes
1 answer
check for the completion of a SQL script
I want to automate a process that in its simplest form would involve running a sequence of SQL script. Each script depends on the results of the previous.
I use Netezza Aginity on a W7 box.
I can run one script with a command…
ADJ
- 4,892
- 10
- 50
- 83
0
votes
1 answer
Convert Exponential to Varchar in Netezza
I have this 12241089001 value read as 1.2241089001E10 in Netezza. Actually the data type is Varchar. How can this read as exponential?
When I convert 1.2241089001E10 into Varchar, it's only cut the E10. Example : 1.2241089001. How to save this value…
colintobing
- 167
- 2
- 14
0
votes
1 answer
How distribution key affects the distribution of data in netezza
If I specify the distribution key to be the primary key of a table, then is it fair to assume that the data will be distributed evenly across all nodes?
And if I specify the distribution key to be a column with only one value, then all the data will…
Victor
- 16,609
- 71
- 229
- 409
0
votes
2 answers
comparing each record of a table for some columns
I have a table TEST which has like this records
ID USERNAME IPADDRS CONNTIME country
8238237 XYZ 10.16.199.20 11:00:00 USA
8255237 XYZ 10.16.199.20 11:00:00 UK
485337 ABC 10.16.199.22 …
user3085928
- 1
- 2
0
votes
2 answers
Function 'PRECENTILE_CONT' error #Netezza
When I run the below query:
select PRECENTILE_CONT(0.5) WITHIN GROUP (ORDER BY X) AS MEDIAN_X
from table;
I get the following error:
Function 'PRECENTILE_CONT' is not an analytic aggregate but is called
with a window spec
Please let me know if…
Macopare
- 155
- 1
- 3
- 11
0
votes
1 answer
how to specify database user credentials in a connection array string (Excel VBA)
Please help in modifying the connection array string (Excel 2010) to be able to receive the input from a cell reference for fields UID=;PWD= and Initial Catalog.
.Connection= Array("OLEDB;Provider=MSDASQL.1;Persist Security Info=True;Extended…
Prashant
- 13
- 2
0
votes
1 answer
Type casting in Netezza
Basically, I have Netezza at source as well as Target. In source every column is defined as NVARCHAR.
While loading the data through Informatica(ETL), we have to make different type conversions such as:
NVARCHAR -> Timestamp
NVARCHAR ->…
Biswajeet Ghosh
- 11
- 1
- 2
- 2
0
votes
2 answers
CASE statement in Netezza
I am new to Netezza so may be I am not able to figure out the issue.
I have a scenario to implement in informatica with Netezza as the database. As few functions are not available/supported by informatica, so decided to make some netezza views and…
Biswajeet Ghosh
- 11
- 1
- 2
- 2
0
votes
2 answers
Netezza /SQL ..temp table creation with random characters
I am sure there is a very quick way of doing this, but I am a little stumped right now
Is there a way to select a bunch of characters such as('3232345','224225','234234234','533225') and insert each character into a new row of a temp table
I wanted…
vbala2014
- 161
- 2
- 6
- 15
0
votes
2 answers
netezza how to reorder table after data has been loaded
my table in netezza looks something like this:
b,2
b,1
a,2
a,1
a,3
c,1
c,2
I want to reorder it by the first coloumn so it looks like this:
a,2
a,1
a,3
b,2
b,1
c,1
c,2
How do i reorder the table without creating a new one?
shecode
- 1,716
- 6
- 32
- 50
0
votes
1 answer
Not able to create a table in netezza
I am new to Netezza,
I have a Physical Machine which is installed with Ubuntu 14.04. In Ubuntu 14.04, I have installed vmware player and on top of it I created netezza virtual host.
The above process is successful and I am able to login to netezza.…
bhanu
- 76
- 10
0
votes
0 answers
Netezza Record value Assignment
I have a specific query. In Netezza, I need to assign the value of one record to another record. I am trying as below,
record1 := record2;
But it is not working this way. While if I try to assign individual values, it is working.…
Sonal Nath
- 3
- 1
0
votes
1 answer
Netezza GOTO statement
I have a specific query. Can we implement GOTO logic in Netezza Stored Procedure. I need to implement a labelled block inside a netezza procedure. Then I want to execute a GOTO statement from inside the same procedure, which will jump and execute…
Sonal Nath
- 3
- 1