Questions tagged [netezza]
A data warehouse and analytic appliance suite that IBM purchased around 2010. Utilizes SQL language to query data. It is a contender in the "big data" market and used comparable to Teradata or Hadoop. Pronounced Ne-Tease-Ah.
34
questions
0
votes
0
answers
17
views
Which of these SQL Queries is Correct?
I am working with Netezza SQL.
I have a table ("my_table") that contains information on:
student_id (e.g. 123, 124,etc.)
scholarship (1 = yes, 0 = no) : note that a student can receive a ...
- 143
0
votes
1
answer
218
views
Generating MD5 Hash for NVARCHAR and VARCHAR columns across different databases
I am building a utility that generates a single MD5 hash across all CONCATENATED column values for any table row. To make this work, I have to eliminate NULL values using COALESCE and must CAST NUMBER ...
- 69
0
votes
1
answer
209
views
How to generate each query in a separate SQL file using TPC-DS dsqgen tool?
I'm using TPC-DS dsqgen to translate its templates to runnable queries.
I tried the following argument variations to save each query in a dedicated .sql file, but they all save the runnable query in ...
- 135
-1
votes
1
answer
382
views
Need SQL query to update the column using case when by joining two tables in Netezza Database
There are 2 tables : Sales & Transaction. I need to update the INDICATOR column of the Sales table using CASE WHEN by joining these two tables in Netezza database.
Using below query but not ...
- 1
1
vote
1
answer
303
views
Netezza migration to Azure Synapse - Stored Procedures?
I have looked everywhere for useful documentation that comprehensively gives me the differences between Netezza stored procedures and functions so I can find Azure Synapse equivalents.
Is there any ...
- 69
0
votes
1
answer
22
views
Comparing 2 items at different dates
I have a Netezza database which gets a daily feed of account information.
I’m trying to write a query which will only return accounts when they experience a price change and advise what the price ...
- 1
0
votes
1
answer
1k
views
join a lookup table with a data table
I have the following schema in my database
Neighbors: ( central_id, neighbor_id)
Data: (central_id, value)
This schema is for a convolution algorithm which for each central_id I have 6 neighbors(it ...
- 101
1
vote
0
answers
82
views
Netezza Sequence error
I am new to Netezza and have a quick question.
I do a simple select of next val from sequence
SELECT NEXT VALUE FOR XX.XX.RUN_SEQ FROM _V_DUAL I
ERROR [HY000] ERROR: Sequence 46339885 not ...
0
votes
1
answer
58
views
Select based on list of pairs
I have a table with two main columns, id1 and id2:
drop table if exists pairs;
create table pairs (id1 int, id2 int);
insert into pairs values
(1,2), (1,3), (3,1), (2,4), (5,4), (3,6), (7,8);
I ...
- 101
1
vote
0
answers
322
views
Getting Error: invalid UTF-8 sequence - bad continuation byte
I'm inserting into a table from an external csv file and one of the fields in that file has non-ascii characters. An example of the character is this: É.
Here is my insert statement:
INSERT INTO ...
- 11
0
votes
1
answer
3k
views
How to find view dependencies in Netezza?
I want to find the dependent table of views in Netezza. Is there a table that provides the details?
- 1
2
votes
0
answers
377
views
In nzsql, how can I determine the path of the current sql file being executed?
How can I run a script with nzsql that calls other scripts using \i with paths specified relative to the path of the calling script?
The solution must work whether nzsql is being run interactively ...
1
vote
1
answer
1k
views
how to execute unix commands within nzsql?
I'm converting a script from Teradata to Netezza, and I'm stuck at the portion where BTEQ uses the functionality of the OS to check if a file contains any data. If it does, it is deleted. I want to ...
- 11
2
votes
0
answers
846
views
What would be the rule for parsing parameterized sql for Netezza to be used with nzsql?
I have a bunch of legacy parametrized SQL templates that were used by nzsql utility for Netezza. See examples here: http://queforum.com/netezza/347918-parameterized-sql-file-input-nzsql.html
What is ...
- 121
0
votes
1
answer
631
views
Windows ODBC Driver versions for Netezza
I am looking for information regarding the Netezza windows ODBC driver versions.
What are the supported/preferred windows ODBC driver versions for Netezza 7.2, Netezza 6.1 and Netezza 6.0.
Any ...
2
votes
2
answers
3k
views
How to increase ETL performance in Informatica for Netezza as a source and SQL Server as a target?
What settings or configuration on the Informatica server, in the Informatica software itself, or on the database servers can be changed to increase Informatica ETL throughput? What are some ...
- 2,072
6
votes
4
answers
20k
views
Netezza: What schema contains all the system tables / views?
Is there a schema I can look in or a query that I can run to see all the Netezza system or metadata tables?
I know about _v_table, _v_view, _v_relation_column, and _v_groupusers.
I know there are ...
- 61
1
vote
3
answers
3k
views
Last accessed timestamp of a Netezza table?
Does anyone know of a query that gives me details on the last time a Netezza table was accessed for any of the operations (select, insert or update) ?
Thanks
- 11
0
votes
3
answers
2k
views
Executing a script via Powershell possibility
Let's say I don't happen to have the ability to create a Stored Procedure, but I have to run the same query on a regular basis. Would I be able to put my query in a .txt document and be able to run it ...
- 261
0
votes
1
answer
4k
views
Query Netezza to find all tables in views
I am trying to recreate the following query in netezza and am struggling:
SELECT view_name, Table_Name
FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE View_Name = '<giveViewName>'
ORDER BY ...
1
vote
1
answer
1k
views
How to generate a random character string of length 8 in Netezza?
I am trying to generate a random character string of length 8 in Netezza, any suggestions?
- 11
0
votes
2
answers
6k
views
Netezza Error Record size 120000 exceeds internal limit of 65535 bytes
I have a column PARAM that has JSON data that looks like this:
JSON:{"Name":"RES_InformationalIssues","StepName":"Page_1","StepData":"f601e9fe-d68a-4ed7-bbaa-f40c9cbc4d12=General Product Information",...
0
votes
1
answer
1k
views
What does this error mean in IBM Netezza Administrator? - ERROR: Permission denied on "_VT_DISK_PARTITION"
What does this error mean when opening IBM Netezza Administrator?
ERROR: Permission denied on "_VT_DISK_PARTITION"
- 2,072
1
vote
1
answer
5k
views
how can I call nzsql or nzload from script without disclosing sensitive password?
I don't see this in the Netezza documentation.
We have lots of Linux scripts where we do this:
NZ_PASSWD_ENCRYPTED=29TY20T98=
NZ_PASSWD_CLEAR=`DecryptFunc $NZ_PASSWD_ENCRYPTED`
NzResult=$(nzsql -db $...
- 584
0
votes
1
answer
4k
views
Netezza LIKE operator not finding subsequent backslashes
Netezza is able to find records when using the LIKE operator when the first character contains a backslash character. But when subsequent characters contain a backslash character, it cannot. How can ...
- 2,072
2
votes
2
answers
34k
views
How to obtain row counts for all tables in Netezza?
Is there a system table or view in Netezza that shows the number of records for each table?
- 121
1
vote
1
answer
934
views
Netezza Equivalent to T-SQL ROWVERSION or PL/SQL ORA_ROWSCN
Is there a Netezza equivalent to the MSSQL ROWVERSION or the Oracle ORA_ROWSCN? Essentially I'd like to know if a record changed and be confident that it changed. Using a checksum isn't reliable 100%...
- 2,072
2
votes
1
answer
2k
views
Installing Netezza 6.0.8 ODBC driver on Windows Server 2008
Below are four Netezza drivers that are available for Netezza 6.0.8. I installed the second one on Windows Server 2008, and it placed it into the system32 folder (64 bit folder). However, when I set ...
- 2,072
1
vote
2
answers
2k
views
How do I migrate varbinary data to Netezza?
I got a warning message while migrating DDL from SQL Server to Netezza:
Warning: [dbo].[spec_binarymessage].[blobdata] data type [varbinary] is not supported the target system and will be scripted ...
- 11
1
vote
2
answers
3k
views
Obvious inefficiencies in this Netezza query?
Why might this query be taking nearly 2 hours to run when similar queries complete within a minute?
CREATE TABLE T3 AS
SELECT
A.*,
COALESCE(C.FIELD1,0) AS FIELD1A,
COALESCE(...
- 805
9
votes
4
answers
20k
views
What can speed up a SQL count query?
When doing a count (aggregate) SQL query, what can speed up the execution time in these 3 database systems? I'm sure many things could speed it up (hardware for one), but I'm just a novice DBA, so I'...
- 2,072
1
vote
1
answer
11k
views
Table schema column data type equivalents for Netezza 6 to SQL Server 2008
I'm trying to find a data type equivalents for data types in Netezza when migrating table schema to SQL Server. Where can I find a complete list? When getting down to brass tacks, I am specifically ...
- 2,072
1
vote
2
answers
8k
views
How can primary keys in a Netezza table be indexed?
What is the best way to index a Netezza fact table with lots of primary keys. For now, let's suppose we have 10 primary keys. This table is mainly used to store meta data about our database.
=====...
- 2,072
1
vote
1
answer
883
views
Tools for synchronizing database schema with Oracle, SQL-Server and Netezza databases [closed]
I'm looking for software tools to move database schema for Oracle, SQL Server and Netezza. We use Oracle for our ODS, Netezza for our Data Warehouse (for it's bulk loading capabilities) and SQL ...
- 2,072