Questions tagged [netezza]
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.
netezza
1,370
questions
-1
votes
1
answer
63
views
Combining SQL and Regex together?
I have a table pizza_orders with a column ingredients that looks like this:
order_no
ingredients
1
cheese-olives-peppers-olives
2
cheese-olives
3
cheese-tomatoes-olives
4
cheese
I want to make 3 ...
0
votes
1
answer
49
views
Calcualting Medians in SQL
I am trying to figure out how to calculate MEDIAN in GROUPS within SQL (i.e. required to use NTILE() functions to indirectly calculate the median).
I read somewhere on the internet that some SQL ...
0
votes
0
answers
22
views
SHA256 hash for Netezza
I am working on an application that provides connectivity to Netezza Performance Server(NPS) 7.2 and trying to use SHA256 authentication mechanism to achieve the same. I have tried using the SHA256 ...
-6
votes
1
answer
65
views
Finding out the cumulative number of missing rows per group [closed]
I have this table in SQL about the years in which students were studying in a school:
CREATE TABLE myt (
student_name VARCHAR(50),
student_year INT
);
INSERT INTO myt (student_name, student_year) ...
-1
votes
2
answers
39
views
SQL: Comparing Identical Rows in Different Tables and then Updating
I have these two tables : old_table was created on 2020-01-01 and new_table was created on 2020-01-02.
CREATE TABLE old_table (
name1 VARCHAR(50),
name2 VARCHAR(50),
origin_date DATE,
...
0
votes
3
answers
71
views
SQL; Ensuring a Condition is Met After the Join
I have these two tables:
CREATE TABLE my_table1 (
name VARCHAR(50),
var1 DATE,
var2 INT
);
INSERT INTO my_table1 (name, var1, var2) VALUES
('john', '2010-01-01', 94),
('john', '2010-01-04'...
0
votes
2
answers
58
views
SQL: Counting Number of Occurrences Past a Certain Date
I have these two tables:
CREATE TABLE my_table1 (
name VARCHAR(50),
var1 DATE,
var2 INT
);
INSERT INTO my_table1 (name, var1, var2) VALUES
('john', '2010-01-01', 94),
('john', '2010-01-04'...
-1
votes
1
answer
44
views
SQL: Join based on closest date
I have the two following tables:
CREATE TABLE my_table1 (
color VARCHAR(50),
d1 DATE,
var1 VARCHAR(50)
);
INSERT INTO my_table1 (color, d1, var1)
VALUES
('red', '2010-01-01', 'a'),
...
0
votes
1
answer
42
views
Automate queries in NETEZZA using Azure Data Factory
I have a complex process that occurs monthly and want to automate the process.
I have approximately 10 queries that I manually run in Netezza to output a dataset which can take around 2 days to ...
0
votes
2
answers
42
views
Error retreiving database 'NZPYIDA' with NZFunApply function
I'm trying to run this code via jupyter notebook to apply a function on the table in netezza server, so I can apply this code on the table inside without getting data out of table/database.
from ...
0
votes
1
answer
71
views
Can't load plugin: sqlalchemy.dialects:netezza.nzpy
I have some worries with using nzalchemy together with SQLAlchemy. I tried using version 1.4.52 and the latest 2.0 version, but the failure remains always the same.
Whenever I try to connect to some ...
0
votes
0
answers
55
views
convert a Julian date to gregorian date in netezza
I need to convert a integer column with Julian date values to gregorian date in netezza sql. The source column has values like '41606', '100702', please help
3
votes
2
answers
165
views
Finding out Neighbors of a Node using SQL
I have the following table in SQL:
CREATE TABLE friendships
(
id INT PRIMARY KEY,
person VARCHAR(50),
friend VARCHAR(50)
);
INSERT INTO friendships (id, person, friend) VALUES
(1, '...
0
votes
1
answer
82
views
Decode binary file in AWS environment using PySpark
Is it possible to consume a Netezza backup file in AWS environment and load it to Redshift.
File is a compressed binary file created using the below query. This file can also be produced using ...
0
votes
2
answers
39
views
Why can Netezza admin see a table saved to Netezza via Coginiti Pro
I created a table from an excel file in Coginiti Pro and then saved it to the Netezza. I can see the table and can query from it in Coginiti Pro, Excel, and Power BI Desktop. However, the Netezza ...