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
-2
votes
1 answer
kmeans implementation with mixed variable at database level
I have a table with columns of different datatypes (columns like: ProductId, Name, size, color, class, dept etc) as not all columns are numeric, how can I cluster similar products together. The data sits in Netezza and for the purpose of fast…
Abhishek Gupta
- 77
- 1
- 2
- 9
-2
votes
2 answers
SQL query Exists AND NOT Exists
I have a table where I need to insert the data from a view which has 2 conditions :
1) Insert those data in a table where pk is unavailable in a transaction table but is available in the view 2) if pk is there but data is different from the view…
mehtat_90
- 586
- 9
- 29
-2
votes
1 answer
Netezza CI/CD tool
Is there any CI/CD tool for Netezza that can manage versions and can be used for migrating code across environments? We have used flywaydb for other databases and are happy with it, but that does not support Netezza. I have already googled and did…
Ram
- 173
- 2
- 11
-2
votes
1 answer
What does :: mean in ::BOOL?
I have a SQL case statement and wanted to know what ::BOOL means. In my example it is used in a case...when statement. Please guide me as to what it means in that context. My database is Netezza.
case
when...
then 't' ::BOOL.
Faisal
- 7
- 3
-2
votes
1 answer
Update canceled: attempt to update a target row with values from multiple join rows
I am getting the below issue while running a update statement:
Update canceled: attempt to update a target row with values from multiple join rows
braj
- 2,545
- 2
- 29
- 40
-2
votes
1 answer
Grouping the date columns in week range
i have a table and the columns like
Start_date timestamp,
end_date timestamp,
id number,
cost number(10,2).
And the data which i inserted into the table 'll be like this
1,'2013-02-03 00:00:00','2013-02-03 00:00:00',75*0.06
1,'2013-02-04…
Dileep
- 624
- 3
- 10
- 20
-2
votes
3 answers
Find column Value by dividing with sum of a column
I have a table with the following columns in a Netezza Database
Id field1 field2
1 0.9 sum(field1)/0.9
2 1.7 sum(field1)/1.7
3 6.9 sum(field1)/6.9
4 0.4 sum(field1)/0.4
5 0.2 sum(field1)/0.2
6 2.8 …
Gallop
- 1,365
- 3
- 16
- 28
-4
votes
1 answer
NETEZZA: Can LEFT JOIN be faster than INNER JOIN?
Query:
SELECT * FROM TABLE1 TBL
INNER JOIN CROSS_REF_TABLE XREF
ON TBL.COL = XREF.COL
VS
SELECT * FROM TABLE1 TBL
LEFT JOIN CROSS_REF_TABLE XREF
ON TBL.COL = XREF.COL
WHERE XREF.COL IS NOT NULL
Can Left join be faster than inner join ? In my case…
anayabu
- 31
- 1
- 7
-6
votes
1 answer
How to find grandparents using SQL?
I have table which has two columns
----------------------
| NAME | FATHER_NAME |
----------------------
DDL :
CREATE TABLE RELATION (NAME VARCHAR(20), FATHER_NAME VARCHAR(20));
INSERT INTO RELATION VALUES ('ADESH','ASHOK');
INSERT INTO…
adesh
- 832
- 4
- 14
- 23