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
6
votes
1 answer
Netezza UPDATE from one table to another
This is my query that does not work in Netezza:
UPDATE TABLE1 A
SET A.COL1= (SELECT DISTINCT B.COL1 FROM TABLE2 B WHERE B.ID= A.ID AND B.DeptID=104)
WHERE A.DeptID=3
How do I re-write this query?
Please help.
ozzboy
- 2,672
- 8
- 42
- 69
6
votes
3 answers
How do I limit the number of rows returned in a Netezza query?
I want to run a basic query, but return only the first ten rows of the table from Netezza
select a.*
from some_schema.some_table a
where rownum < 10
What is the Netezza way of looking at just those few rows?
mcpeterson
- 4,894
- 4
- 24
- 24
6
votes
4 answers
Netezza ODBC connection - equivalent of "use database"
After connecting to a Netezza system is there any way to switch the database? For instance, in MSSQL one could send the command use database_name in order to switch to the database_name.
Is there anything in Netezza like "use" on…
joefromct
- 1,506
- 13
- 33
6
votes
4 answers
create external table with headers in netezza (postgres)
I am creating an external table as shown below
CREATE EXTERNAL TABLE '~\test.csv'
USING ( DELIMITER ',' Y2BASE 2000 ENCODING 'internal' REMOTESOURCE 'ODBC' ESCAPECHAR '\' )
AS SELECT * FROM TEST_TABLE;
It works fine. My question is :
Is there a…
Nikhil Das Nomula
- 1,863
- 5
- 31
- 50
5
votes
2 answers
SQL select if a certian number of WHERE clauses satisfied
So I have a SQL statement of the following form with multiple WHERE clauses:
SELECT cols FROM table
WHERE
CONDITION1 OR
CONDITION2 OR
...
CONDITIONN
I know that if I run this, then I will get all rows that satisfy at least one of the above n…
Relma2
- 108
- 5
5
votes
2 answers
String encode/decode issue - missing character from end
I am having NVARCHAR type column in my database. I am unable to convert the content of this column to plain string in my code. (I am using pyodbc for the database connection).
# This unicode string is returned by the database
>>> my_string =…
user7001260
- 71
- 7
5
votes
4 answers
Validate syntax of CREATE TABLE DDLs using EXPLAIN Command
I have some create table scripts which I need to pre-validate in my application. I can think of two ways:
CREATE table using that script and immediately DROP table.
Use EXPLAIN command to find syntactical errors without creating it.
I found 2nd…
Dev
- 13,492
- 19
- 81
- 174
5
votes
5 answers
Netezza Sql query
I have a list of tables in a Netezza database and I want to get the name of primary key for each of the tables.
Can anyone provide me the query.
Akshay J
- 5,362
- 13
- 68
- 105
5
votes
3 answers
Netezza SQL convert VARCHAR to binary string
I have a bitmap stored as a VARCHAR in Netteza. Need to convert that VARCHAR to a binary string in Netezza.
Input (Netezza col value - VARCHAR ) = '0xFFFFFFFFFFFFFFFF'
Desired output (VARCHAR)->…
user3206440
- 4,749
- 15
- 75
- 132
5
votes
2 answers
Creating Temporary Table on Netezza from Pandas DataFrame
I am looking to change over my workflow from SAS to Python, and have been prety successful thus far except for one pretty big thing. I cannot figure out how to upload Pandas DataFrames to my company's Netezza for use in later queries. This is…
invoker
- 507
- 3
- 7
- 18
5
votes
6 answers
Data Warehouse: One Database or many?
At my new company, they keep all data associated with the data warehouse, including import, staging, audit, dimension and fact tables, together in the same physical database.
I've been a database developer for a number of years now and this…
drrollins
- 51
- 1
- 3
5
votes
2 answers
Netezza “[08S01] Communication link failure” Loading External Data
Am getting:
ERROR [HY008] Operation canceled
ERROR [08S01] Communication link failure
When trying to upload external .txt file to Netezza database. I have done this in the past (just last week), but today receive this error. Am able to connect to…
thagraybush
- 131
- 1
- 6
5
votes
2 answers
Setting a variable in ANSI SQL
I am new to SQL and have been searching for a way to set variables in ANSI SQL. I have this:
select * from table1
where first_date > '2014-01-01'
and where second_date = '2014-01-01'
and where third_date < '2014-01-01'
but I am hoping for something…
slaw
- 6,591
- 16
- 56
- 109
5
votes
1 answer
In Netezza I'm trying to use a sequence in a case statement but the sequence value doesn't increment
Here is the sequence creation syntax used:
CREATE SEQUENCE BD_ID_SEQ AS INTEGER
START WITH 999
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
NO CYCLE;
I have a table with the following values…
user3254441
- 51
- 1
- 2
5
votes
2 answers
Sub-Queries in Netezza
I am trying to port a SQL from Oracle 11 G to Netezza.
Here is my query in Oracle:
SELECT
ID, TEACHERID, CLASS, SECTION, MAJOR, SUPERVISOR, COURSE, SCORE, SCOREDATE,
(select SCORE from STUDENT_SCORES d2 where d2.ID=d1.ID and d2.SCOREDATE…
ozzboy
- 2,672
- 8
- 42
- 69