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
2 answers
Using wildcards
Can anyone help me out with this-
There is a column in the database as "TEXT".
This column hold some string value.
I want to search any row that is having '%' in this column .
For eg how will i search for a row having value 'Vivek%123' in the column…
Vivek Rana
- 1
- 3
0
votes
1 answer
"intck" SAS analogus in Netezza
Im looking for a way in which I can derive the same results in Netezza if I had used the "intck" function in SAS.
Question eg: INTCK('QTR',FIN_YR,CNT_DATE)+5
What would provide me with the same answer in a SQL-Netzza code.
Thanks :)
Manaswi Mishra
- 23
- 5
0
votes
1 answer
WITH CLAUSE in Netezza
Unable to use JOIN inside the WITH CLAUSE
WITH EmpCTE(empid, empname, mgrid, lvl)
AS
(
-- Anchor Member (AM)
SELECT empid, empname, mgrid, 0
FROM Employees
WHERE empid = 7
UNION ALL
-- Recursive Member (RM)
SELECT E.empid, E.empname,…
Sayeekrishnan Subramaniam
- 55
- 3
- 7
0
votes
1 answer
Oracle to Netezza Migration - Connect Prior ...START WITH Equivalent in Netezza
Can some one help me to get Oracle 11g CONNECT PRIOR ...START WITH equivalent
SQL in Netezza
Below SQL not working in Netezza
CREATE TABLE Employees
(
empid int NOT NULL,
mgrid int NULL,
empname varchar(25) NOT…
Sayeekrishnan Subramaniam
- 55
- 3
- 7
0
votes
0 answers
Sybase assigning datatype to variable?
Hello I don't quite understand this syntax could someone explain me what this does to the variable x? Variable x is defined as x VARCHAR(250);
SET x= res || CHAR(39)
or SET x= CHAR(39)
Im trying to convert this sybase line to Netezza and this far…
hidross
- 123
- 3
- 16
0
votes
1 answer
Are multiple correlated queries unsupported in Netezza?
This might be easier to explain with the code first, so I'm currently using something that looks like this:
'A' in
(
SELECT DISTINCT b.col1
FROM table b
WHERE b.ky1 = a.ky1
AND b.ky2 = a.ky2
AND…
charles
- 547
- 1
- 3
- 11
0
votes
1 answer
Equivalent months_between function for HiveQL
I'm trying to use HIVE to calcuate the months between two dates that are years and sometimes decades apart. In Netezza I used: months_between(this_month('Date_1'),this_month(Date_2))
I am trying to translate to HIVE and don't think there is an…
user2822055
- 119
- 2
- 9
0
votes
1 answer
Convert a Recursive CTE in SQL Server to netezza
I have a requirement like i need to convert a recursive CTE in sql server into netezza !
Will netezza even support Recursive CTE ?
Can anyone help me on this ?
Thanks in advance,
Manirathinam.
Mani
- 187
- 2
- 5
- 14
0
votes
1 answer
Is it possible to use Netezza ODBC driver on Ubuntu?
The Netezza ODBC Drivers are officially supported on SUSE and RedHat. I'm trying to get the driver to work on Ubuntu 14.04.
I've been testing the connection via:
sudo isql -v NZSQL
Which initially returned:
[unixODBC]Error occurred while loading…
NAD
- 615
- 1
- 7
- 20
0
votes
1 answer
Command not found in one method(python) but not the other(shell script)
I am sshed into another machine. Within that machine, I have a script called get_count.sh
#!/bin/sh
nzsql -u user -pw password -host hostname -port 1234 -db database -c "query"
run this script when I am sshed in and it works as expected.…
Liondancer
- 15,721
- 51
- 149
- 255
0
votes
2 answers
inner joined based on every attribute
I know I can do:
SELECT COUNT(*) FROM table_a INNER JOIN table_b ON (table_a.attribute = table_b.attribute)
To do an inner join based on the same attributes in table_a and table_b.
But what if I have over 100 attributes and I want to do an inner…
Liondancer
- 15,721
- 51
- 149
- 255
0
votes
1 answer
Checking that all records from a table has been included into the main table
I new to SQL but I have been practicing JOIN a bit. I want to check if all the records from another table(small_table) has been included in my current table(base_table).
For example:
SELECT * FROM base_table WHERE year = 2015 AND month = 3 AND day =…
Liondancer
- 15,721
- 51
- 149
- 255
0
votes
2 answers
Difference Between Minus and subquery
i want to know what is the difference between Minus and subquery in the below example. I got 2 different results for both. Basically i am trying to find records that exist in the first but not the 2nd table.
Query 1:
select count(*) from (
(select…
user4611239
- 1
- 1
0
votes
1 answer
Joining Transaction Tables and Populating Null Values in Netezza / PDA
I've got two transaction tables in Netezza set up like the below. When joining the tables on ID and transactionCount, and trying to return Answer, there will be nulls for row 9998, 9996, 9995 etc. How would I return all transactionCount values with…
GaBBaii
- 29
- 8
0
votes
0 answers
Sqoop connecting between EMR and Netezza
We are not able to connect to Netezza from EMR via sqoop connection. Below is the error message. I am wondering if there is some port need to be open in Netezza host. Thanks.
./sqoop-1.4.5.bin__hadoop-1.0.0/bin/sqoop list-tables --connect…
vycon
- 139
- 2
- 12