Questions tagged [aginity]
88 questions
1
vote
1 answer
Netezza Performance Optimization
I'm starting to work with Netezza on Aginity to handle millions of records per table. I've been reading up online on how to optimize tables so that loading the data and running queries on it will be relatively quick and I have a few questions.
1)…
tee
- 1,286
- 2
- 19
- 35
1
vote
1 answer
Loading sas files into netezza on Aginity
I'm trying to load data with over 50 million records into Netezza using Aginity. The problem is that my data table is a sas format with extension .sas7bdat that I open on SAS Enterprise Guide. So currently I have a script that transforms the sas…
tee
- 1,286
- 2
- 19
- 35
1
vote
2 answers
Redshift Aginity Workbench - ERROR: 42703: column "XXX" does not exist in table_y
I've been using MySQL Workbench for a while and now I need to work on Aginity - I'm trying to run a simple script:
select min(date)
from table_y
where column_header = "XXX"
Yet I get this error:
ERROR: 42703: column "XXX" does not exist in…
Christián De Achával
- 53
- 8
1
vote
1 answer
How to conditionally count rows from another table WITHOUT USING A CORRELATED SUBQUERY?
I have a dataset for which I have to conditionally count rows from table B that are between two dates in table A. I have to do this without the use of a correlated subquery in the SELECT clause, as this is not supported in Netezza - docs:…
psrpsrpsr
- 457
- 1
- 4
- 12
1
vote
1 answer
Cumulative count of repeated values, starting at 1
I have a list of individual ID keys that have duplicates. I'd like to deduplicate this by counting the instance of each repeated key. I can count the cumulative total, or count the number of repeated instances, but not count incrementally from 1…
William Cozzolino
- 13
- 2
1
vote
4 answers
Returning Minimum Rows For Each ID SQL
I have a very long list that looks roughlt like the below (column names and data anonymised)
ID | ID2 | Value
1 | 5 | 900
1 | 7 | 400
2 | 2 | 100
2 | 8 | 800
2 | 2 | 200
3 | 4 | 100
3 | 5 | 300
4 | 8 | 750
4 | 5 | …
Mike Langlois
- 13
- 3
1
vote
1 answer
Return Record With Earliest Date
I am using Aginity Workbench with a database on Netezza and I am trying to return the record with the earliest date based on it featuring an IS code in any one of three (serviceability) columns. There are multiple records for one ICS_UID, but I…
gstatus
- 15
- 3
1
vote
0 answers
Avoid 'Out of Memory' error in Netezza by finding large CASE statement alternative
Below is a query that I've simplified quite substantially in the past week. It used to have 7 other joins, but now they are consolidated into two temp tables, so it's obviously not complex joins causing the error. But it still throws an 'Out of…
JustBeingHelpful
- 18,332
- 38
- 160
- 245
1
vote
1 answer
aginity workbench for redshift temp table auto-complete
I'm a newbie to Redshift, I'm using Aginity workbench for Redhsift. Pretty familiar with MS SQL server though. My question is about auto-complete, when I write a regular query like this below, as soon as I type in "m.", a list of all fields in…
Nisheeth Singh
- 69
- 1
- 2
0
votes
0 answers
LDAP Authentication failure for user
I installed a software called Coginiti Pro (Aginity Pro), entered the license key to activate the software, and tried to connect to the Netezza database/driver. But when the credentials are entered, I get an error message: LDAP Authentication…
Sew3
- 9
- 3
0
votes
1 answer
how to get comma separated values in one column for multiple rows that have same id
before
after
tried few functions but didnt work
hshs
- 13
- 3
0
votes
1 answer
netezza compare char date in YYYY-MM-DD format to parameter date in yyyy-mm-dd format
I am querying a file with dates in YYYY-MM-DD format but are formatted as character. If I just run a simple query like with WHERE DATE_IN_FILE >= '2022-01-31' that works. However I need to make that date a parameter so it does not have to be…
Coop
- 11
- 2
0
votes
1 answer
How to create a stored procedure - Netezza Aginity
I am creating a test stored procedure but it does not work for me. What am I doing wrong?
I am using Aginity Workbench for PureData System for Analytics
CREATE OR REPLACE PROCEDURE OID_DB.SP_TEST_1(CHARACTER VARYING(8))
RETURNS CHARACTER…
0
votes
1 answer
How to compress in an existing table - Netezza Aginity
I have created the following table SCH_DB.PREDICTION_HIS
CREATE TABLE SCH_DB.PREDICTION_HIS
(
PERIOD CHARACTER VARYING(6) NOT NULL,
MONTHS_FORECAST CHARACTER VARYING(13) NOT NULL,
SUBSCRIBER_ID CHARACTER VARYING(12) NOT NULL,
…
0
votes
0 answers
Aginity puredata error with REGEXP_EXTRACT
I have the following error when executing the REG_EXTRACT I do not know what the error will be.
You can also help me by indicating what this sentence is for, which I don't understand very well.
I run this on aginity puredata version…