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
-1
votes
2 answers
First Day of nth Week of the Year in Netezza
How can I find the date of the first day of the nth week of the year? For example, all of the following queries:
SELECT DATE_PART('WEEK', '2019-07-22 01:12:07'::timestamp);
SELECT DATE_PART('WEEK', '2019-07-23 01:12:07'::timestamp);
SELECT…
FatihAkici
- 4,679
- 2
- 31
- 48
-1
votes
1 answer
Python parsing json data to Netezza table
[
{
"id": 1,
"name": "Lea",
"username": "Bret",
"email": "hhaa@gma",
"address": {
"street": "Light",
"suite": "Apt. 5",
"city": "Gwen",
"zipcode": "3874",
"geo": {
"lat": "-37.3159",
…
Dedipya B
- 1
- 3
-1
votes
1 answer
SQL: tricky question for finding lockout dates
Hope you can help. We have a table with two columns Customer_ID and Trip_Date. The customer receives 15% off on their first visit and on every visit where they haven't received the 15% off offer in the past thirty days. How do I write a single…
Grandpa Funk
- 11
- 1
-1
votes
2 answers
SQL to split a column values into rows in Netezza
I have data in the below way in a column. The data within the column is separated by two spaces.
4EG C6CC C6DE 6MM C6LL L3BC C3
I need to split it into as beloW. I tried using REGEXP_SUBSTR to do it but looks like it's not in the SQL…
rick
- 21
- 3
-1
votes
2 answers
SQL-max in the group and sum with compound key
I have two tables..
1-Identity(id, ref1,ref2, address)
2-details(ref1,ref2,amount,u_no,u_date)
I want to extract the each id with sum of amount having highest u_date and highest u_no
i tried below--
Select I.id, d.amount
From identity I Inner…
Django
- 11
- 3
-1
votes
1 answer
Fetch record countr from a list of tables in Netezza using Python
I have to fetch record counts from tables starting with WC_* from database "TEST_DB".
Currently I'm using below code to do that, but it's taking too long as there are billions of records in many tables. Is there any way to improve performance
for…
J K
- 165
- 2
- 14
-1
votes
1 answer
Netezza connection wtih C++
I am developing an application and i need to migrate data from netezza database into another database. For that i need to write an application in C++ or java to read from netezza database. Can anyone guide if there are any native API available for…
Saad Ahmed
- 1
- 1
-1
votes
1 answer
ERROR [HY000] ERROR: Aggregate function calls may not be nested */
I cannot get the below line to work when adding to my query, any thoughts?
stddev(stat) bias
with c as (
SELECT A.ENGINE_ASOF_CALENDAR_DATE, A.LEVEL_1_CODE CURR, CNTR_TO_ACTIVE_RISK, A.PRICE, a.ACTIVE_WEIGHT_PCT,
lag(a.PRICE, 1)…
Tim Cooper
- 11
- 4
-1
votes
3 answers
How to populate columns as rows in Netezza
I am new to Netezza and I need your help in converting 15 columns to rows in the target table.
I have come across REGEXP functions but I am not sure of exact syntax.
Here is the example :
Source has it as
Col 1 Col 2 Col 3 Col 4 Col 5 Col…
Anusha
- 1
- 1
- 1
-1
votes
1 answer
Matching records between Hive table and Netezza table
This is my first question here and I would be really grateful if y'all could help me out.
I ran a sqoop import to transfer a table from Netezza to Hive. Now I have to match the records from the Netezza table to Hive table to check that all the…
Shaunte
- 1
-1
votes
1 answer
netezza sql, how to come true?
create table p(pid int, st int, v int,hid int,ht varchar(2));
data:
insert into p(pid,st,hid, ht,v )
select 1 ,20160131 ,100 ,'FO' ,10
union select 1 ,20160131 ,101 ,'FO' ,20
union select 1 ,20160131 ,102 ,'FO' ,30
union…
caoxp930
- 1
-1
votes
1 answer
How to generate GROUP BY script based on priamry key in Netezza
In Netezza, primary key is not enforced. Thread How to overcome Netezza's lack of unique constraint/referential integrity enforcement? answers how to write to stored procedure to enforce it.
In our case, we don't want to enforce it using a stored…
Hongfa Wu
- 94
- 6
-1
votes
2 answers
Can anyone help me write a sql query
jkdfhdjfhjh&name=ijkjkjkjkjkjk&id=kdjkjkjkjkjkjjjd&class=kdfjjfjdhfjhf
The above string has some characters starting with & and ending with =
for example we have &name= and I just need this from the above string.
similarly I need &id=, &class=
I…
user338292
- 105
- 1
- 3
- 10
-1
votes
3 answers
To Remove Duplicates from Netezza Table
I have a scenario for a type2 table where I have to remove duplicates on total row level.
Lets consider below example as the data in table.
A|B|C|D|E
100|12-01-2016|2|3|4
100|13-01-2016|3|4|5
100|14-01-2016|2|3|4
100|15-01-2016|5|6|7 …
Raghav
- 1
- 1
- 2
-1
votes
1 answer
sql closing distinct counts at end of each day
Hi I have a requirement to calculate the closing counts of distinct House Numbers with status = 'AA' at the end of each day.
So at end of day on 19/03/2016 - if we have 3 distinct house H1, H2, H3 with AA count = 3
On 20/03/2016 if we have H2…
JellyBean
- 39
- 1
- 6