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
System table or stored procedure for finding UDF code/definition in IBM Netezza
I have created a UDF (user-defined function) in IBM Netezza. I would like to extract the underlying C++ class code, and/or the SQL script that creates this UDF. I need to extract these using a SQL query in IBM Netezza.
Any help in reaching this goal…
Nishanth Reddy
- 589
- 2
- 14
- 27
0
votes
0 answers
Why full outer join returns less results than join?
I have two sql in netezza:
1.
SELECT T1.Col1, T2.Col2 FROM TableA T1 JOIN TableB T2 ON T1.Col3 = T2.Col3
2.
SELECT T1.Col1, T2.Col2 FROM TableA T1 FULL OUTER JOIN TableB T2 ON T1.Col3 = T2.Col3
I assume that 2 should return more or equal results…
user3768354
- 517
- 2
- 5
- 5
0
votes
1 answer
error of exporting a sql data table from IBM netezza database to a txt file on win 7
I would like to export a data table from IBM netezza SQL daatbase in Aginity workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\\path\\my_name.txt'
USING
(
Y2BASE 2000
…
user3601704
- 753
- 1
- 14
- 46
0
votes
1 answer
find partial duplicated rows in a SQL table in IBM netezza database
This question is related to my previous question :
error of finding distinct cobinations of muiltiple columns in IBM netezza SQL table
Now, I need to find some partial duplicated rows in the table in SQL IBM netteza Aiginity workbench.
The table…
user3601704
- 753
- 1
- 14
- 46
0
votes
1 answer
create unique primary key in IBM netezza sql server ?
I need to create a unique primary key that can also be indexed in IBM netezza sql server ?
I find that netezza does not support UNIQUE key.
Are there some ways to get around this problem ?
Thanks
user3601704
- 753
- 1
- 14
- 46
0
votes
1 answer
generate a unique integer ID from multiple columns of a SQL table
I need to generate a new column in a table in a sql database.
the given table is:
id1 value1 value2 value3 value4
9465 387 801 1990 20
All columns are integer. value1 and value2 are always 3 digits, value3 are…
user3601704
- 753
- 1
- 14
- 46
0
votes
1 answer
error of changing a tablename in IBM netezza aginity workbench
I am trying to change a table name in IBM netezza Aginity workbench on win7.
I can read the table but I cannot change its name.
When I run :
ALTER table my_database.username.my_table rename to my_database.username.my_table_new
I got error:
…
user3601704
- 753
- 1
- 14
- 46
0
votes
1 answer
error of finding size of database in IBM netezza Aginity workbench on win 7
I need to find the size of a database in Aginity Workbench for Netezza on win 7.
The SQL does not work for me:
select orx.database::nvarchar(64) as "databasename" ,
case when sum(sod.used_bytes) is null then 0 else…
user3601704
- 753
- 1
- 14
- 46
0
votes
1 answer
copy a SQL database from one server to another server on IBM netezza Aginity workbench
I need to copy a sql database from one server to another server on IBM netezza Aginity workbench.
I know how to do it in MS SQL server.
But, I am not familiar with IBM netezza.
Do I need to copy the database to a local drive and then copy it to…
user3601704
- 753
- 1
- 14
- 46
0
votes
1 answer
netezza nzsql script INSERT output
if this is my output to the terminal from an nzsql insert command being read from a file:
INSERT 0 1
what does the 0 mean?
thanks.
Loletariat
- 3
- 3
0
votes
0 answers
reading from CSV and batch inserting to database Netezza
I am reading a CSV file and inserting the data to Netezza DB. I would like to do a batch INSERT.
Some thing is wrong in my code and fails to INSERT the data.
No errors though.
while((row = csvReader.readNext()) != null)
{
…
ozzboy
- 2,672
- 8
- 42
- 69
0
votes
1 answer
Call netezza query from Visual Studio 2008' Execute SQL Task
I pass a parameter into the Execute SQL Task tool in Visual Studio 2008 and i need to execute the follow:
DECLARE CurrentFileName VARCHAR(200) := (?);
DECLARE TableToTruncate VARCHAR(200);
TableToTruncate := CurrentFileName+'_TABLE_VAR'; …
BYC
- 33
- 4
0
votes
1 answer
RJDBC limiting rows from Netezza
I have an RJDBC connection to Netezza. Queries that should return more than 256 rows are getting truncated to 256 rows. I have tested the queries in SQuirrel and they work fine (return the correct number of rows - 600+).
I have also tried the…
briano1945849
- 101
- 1
- 2
- 9
0
votes
1 answer
Are Netezza and Hive for Hadoop ACID compliant?
I have read that Netezza is ACID compliant. While I have also read that Netezza doesn't enforce foreign keys which means C of ACID is violated. Also Netezza (until version 7.1.0.0 ) didn't support commit/rollback in stored procedure like in Oracle.…
chemicalkt2
- 37
- 5
0
votes
1 answer
Can't update table off ST_INTERSECT Query in Netezza
So basically I have two simple line datasets in Netezza, I want to create a table which just includes lines from dataset 1 that do not intersect any lines from dataset 2.
ST_DISJOINT doesn't seem to work, it returns thousands and thousands of…
rfreeman92
- 3
- 2