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
Variable Assignment Creating Empty Files (Shell/Netezza)
I have a shell script using variable assignments to hold values for comparison within if statements. These variables are generated via SQL statements. I put in echo's for debugging to confirm the location of the creations but I'm unsure what's…
Tara R
- 3
- 1
0
votes
1 answer
Creating a Netezza UDX from TSQL
I am an enzee newbie and need help to convert a MSSQL function we wrote to the new Netezza appliance. I do not know C++, so any help will be appreciated. Here is the sql code:
ALTER FUNCTION [dbo].[PMT]
(
-- Add the parameters for the…
0
votes
1 answer
How can I assign same row_number to rows in a table when ranking function called repeatedly and no unique keys
I have a table t1 on which I run analytic functions. Please consider Netezza database. This table is intermediate table so it has no keys. It is used for ETL/ELT processing before loading data to final table t2.
Now , I want to assign row_number()…
Vishal
- 279
- 3
- 8
- 18
0
votes
0 answers
Hive timestamp import from netezza
I an ETLing a Netezza DB into a Hive target DB but I keep getting issues when it concerns timestamps. The source DB for the ETL to Netezza is Oracle and the "dates" there are stored as varchar. When Etled to Netezza they undergo a transformation…
bR3nD4n
- 111
- 10
0
votes
1 answer
Generating NULL counts by looping over columns in Netezza
I'm trying to query a Netezza table to get count of rows where a column value is NULL -- for all columns. Concretely, assume we have the following table (titled, say, merchants)
business_name phone …
RDK
- 923
- 1
- 9
- 22
0
votes
1 answer
How to change date format in Netezza?
I have one datetime field(startdatetime) store in Netezza DB as varchar because SSIS is truncating milisec and I want datetime till milisec.
So now I have startdatetime value is like 2014-1-2 11:23:31.921000000
and I want it 2014-01-02 11:23:31.921…
user3498241
- 11
- 1
- 1
0
votes
1 answer
nzsql - Converting a subquery into columns for another select
Goal: Use a given subquery's results (a single column with many rows of names) to act as the outer select's selection field.
Currently, my subquery is the following:
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'test_table'…
Zhouster
- 746
- 3
- 13
- 23
0
votes
2 answers
SQL - Can Cursors be avoided in this case?
In case it matters for the following will use a Netezza backend + SPSS Modeler and/or Advanced Query Tool for the query itself. I have no access to the CLI. I'm trying to understand if cursors and walking through a sorted table is necessary to…
funkyb
- 17
- 3
0
votes
1 answer
Convert numeric time value to string in Netezza
I'm trying to convert a date key and a time key (both numeric) to a timestamp in yyyy-mm-dd hh:mm:ss format in Netezza.
e.g. date_key=20120711 time_key=61946 should be converted to '2012-07-11 06:19:46'
I tried to_date function…
user3889909
- 1
- 1
- 2
0
votes
1 answer
What is simplest query to display unique values in each column with their count?
Let's consider I have table like this :
id name addr_line 1 addr_line_2 rec_ins_dt rec_updt_dt
and I want to show output as follows :
rec_ins_dt rec_ins_dt_count rec_updt_dt rec_updt_dt_count
How can I achieve this result…
Vishal
- 279
- 3
- 8
- 18
0
votes
1 answer
LINQ to NETEZZA
Does anyone know if it is possible to use LINQ to query a NETEZZA back-end?
Update: I've tried both the ODBC and OLEDB Netezza drivers, but neither work. Both give a "The selected object(s) use an unsupported data source" error.
Craig Schwarze
- 11,367
- 15
- 60
- 80
0
votes
1 answer
SQL group by to concatenate text
Never ran into this before. I'd like to do it in SQL, but I can in Excel as a fall-back... It's a relatively small set of data.
Suppose I have the following data:
foo | val
----+-----
A | red
A | blue
B | up
B | down
...and I want the…
Chris
- 1,421
- 3
- 18
- 31
0
votes
3 answers
Purge records from netezza tables
Delete record older than 20 days from Netezza tables.
Procedure will take table_name and timestamp as an input.
Does any one know procedure for this?
user3726851
- 1
- 1
0
votes
1 answer
Determine load date of rows in netezza
I'm a systems analyst. I'm pretty new to the field.
I am trying to find the load date for rows in a Netezza table.
Is there a standard query I could use? Like looking up the names of tables or columns (I've done this).
Thanks.
Agileskunk
- 1
- 5
0
votes
3 answers
How to work with nzsql in Netezza
I'm completely new to Netezza. I've connected to Netezza server through a putty access and need to run an nzsql command in the Linux terminal but when I give nzsql, it says command not found. Can someone tell me how to get started with nzsql and…
user3660232
- 1
- 1
- 1
- 1