Questions tagged [aginity]
88 questions
11
votes
2 answers
Amazon Redshift Error - ERROR: 0A000: Specified types or functions (one per INFO message) not supported on Redshift tables
When running the below query:
WITH sublevels AS (
SELECT 1 UNION ALL
SELECT 1 UNION ALL
SELECT 1
), FIELDA AS (
SELECT (ROW_NUMBER() OVER ())::INT sublevel
FROM sublevels sl1, sublevels sl2, sublevels sl3
)
SELECT TOP 10
FIELDB,…
Matt
- 14,906
- 27
- 99
- 149
2
votes
1 answer
Connection to postgres from a client outside docker has a fatal password authentication for user postgres
My goal is to connect a client DB (DBeaver, Aginity Pro) to a PostgreSQL running on a docker container.
From inside the container, the connection with Postgres is successful. I used Adminer and also PSQL and the connection works. I could create…
csilvac
- 21
- 2
2
votes
1 answer
Aginity Pro not opening
I'm triing to open Aginity Pro but it doesn't, it remains on background.
Does anyone know how to solve that problem?
Many thanks!
Xevi
Xevi
- 379
- 1
- 2
- 11
2
votes
2 answers
Unable to create a Stored procedure in Redshift Aginity and aginity pro
Trying to create the stored procedure in redshift aginity workbench but it through an error like 'unterminated dollar-quoted string at or near "$$
'
In amazon, they already gave the solution for…
Ganesh Pitchai
- 55
- 8
2
votes
2 answers
How to kill a long running query on Netezza when you have no admin/root/sudo access
I ran a select query on Netezza where I do not have admin rights and it has been running for last 2 hours now. How do I kill it? I thought of dropping the session, but it says I must have Abort rights.
Abhishek Gupta
- 77
- 1
- 2
- 9
1
vote
0 answers
Aginity workbench Auto indent / SQL formatter
I am wondering if there is a good SQL formatter in Aginity Workbench 7.2
There is two options which are capitalize keywords and add new line after a semicolon.
Is there an auto-indentation feature?
Zayed Elghalayini
- 11
- 1
1
vote
1 answer
Pass column name from _V_SYS_COLUMNS table to create a dynamic select query in Netezza
I need to create a single dynamic select query for different tables in Netezza.
I get the list of columns for any table by using following query:
select *
from _V_SYS_COLUMNS
where TABLE_NAME='Table Name'
But I need to append all the values of…
Shikhar Dwivedi
- 11
- 3
1
vote
1 answer
I want to only return the most recent/max value from a set in SQL
I have a list of clients with a Payment ID that has changed over the years, but I'm only interested in returning the info from the most recent. This is my result after running:
Select distinct
a.client
, a.payment_id
,…
Mark Cavanaugh
- 11
- 1
1
vote
1 answer
How to copy CSV into table with missing column?
I want to import data from a csv file into redshift. CSV format:
col1 , col2 , col3 , col4
- , - , - , -
- , - , - , -
Here is my import command:
COPY myTable
FROM 'file.csv'
CSV
DELIMITER AS ','
IGNOREHEADER AS 1
;
The…
Corentin Duhamel
- 221
- 3
- 11
1
vote
2 answers
How to group data by the month and year
Before I get into the issue, here's a 2 second background: I've been working on this RFM analysis, and thanks to our peers, was finally able to output an RFM score for each customer_id in my data set, along with each of their individual R, F, and M…
Z41N
- 97
- 10
1
vote
1 answer
Connectivity error while connecting from "Aginity workbench for Redshift" tool to AWS Redshift cluster
I am trying to connect to a redshift cluster using aginity tool but see this below error.
Error-message
I am able to connect to other cluster within the same aws account. The cluster to which I am able to connect is in "us-east-1" region. The…
Cloud9
- 11
- 2
1
vote
1 answer
Trying to use regex_replace to extract numbers
I have a column with dma codes. They are either in the following two formats:
a) 100123
b) ="100123"
I am trying to get them all in format a).
I have tried using NULLIF(regexp_replace(column_name, '\D','','g'), '')::numeric
But I am not able to use…
Rishav Dry
- 11
- 3
1
vote
1 answer
Selecting a 1% sample in Aginity Workbench SQL
I need to scoop up a random sample of 1% of the records in a table (with the number of rows growing every second).
My idea is to
SELECT DISTINCT
random(),
name,
age,
registrationNumber
FROM everGrowingTable
ORDER BY random desc
LIMIT (
…
Nimbocrux
- 509
- 2
- 10
- 27
1
vote
1 answer
C# upload CSV file to Netezza
So my team is looking into connecting to Netezza with C# and we plan on loading data into netezza, pulling data from netezza and writing update queries all in C#.
From my research, I see that it's possible to connect to netezza using C# and I'm…
jim
- 1,026
- 2
- 15
- 37
1
vote
1 answer
Advantages of netezza client tools over aginity
My team recently started working with Netezza. I'm responsible for loading data into the database in the most efficient manner. They want me to look into things such as automating the loading of data and more.
Right now I'm using Aginity as an…
tee
- 1,286
- 2
- 19
- 35