Questions tagged [aginity]
88 questions
0
votes
1 answer
How to Delete these Records in Netezza(Aginity)
I Written a Query to Identify the Duplicate records.
As Below.
WITH DUPS AS
(SELECT A_SURVEYID,
CAST(e_responsedate AS DATE) AS e_responsedate,
E_LG_VM_SURVEY_TYPE_ENUM
FROM TRANSIENT..INTERIM_NPS_SURVEY_MOBILE_RESULTS_20170909 a
GROUP…
Krish
- 1
0
votes
1 answer
Netezza SQL query searching a concatenated value
I am using Aginity workbench to query a netezza database and trying to create simple query. Basically, within a table there are two columns that I want to combine to create an ID (they do make up two parts of actual unique IDs). Within the query I…
gstatus
- 15
- 3
0
votes
1 answer
How to schedule sql script and export data to particular location in IBM Netezza
I want to schedule sql query script which export results into CSV on weekly basis. It will help end user to get data weekly.
Like SQL Server Integration services, I am looking for such service in Netezza.
I will be thankful in case any one aware…
Niks
- 997
- 2
- 10
- 28
0
votes
1 answer
Get Rows which are updated in new table compared to old table -SQL
I have a table as
id Description Tag
1 ABC Tag1
2 DEF Tag2
3 ABC Tag1
4 ABC Tag1
5 GHI Tag3
6 DEF Tag2
and whenever i need to make multiple changes I will create…
Manu Mohan
- 167
- 3
- 17
0
votes
1 answer
Dynamic column naming in Netezza
Is there any way to dynamically name pivoted columns in Netezza? In SSMS, I'd use a stored procedure, but our new Netezza box restricts SP creation. Using CASE statements, I can use the row number to pivot daily sums by month, but I'd like the new…
Matt
- 1
0
votes
1 answer
Netezza table size increased after using CTAS command
I have a large table in Netezza and table size is approx 600 GB.
When I tried to create a new table from my existing table the table size has increased. New table size is 617 GB.
SQL which I used to create new table:
create table new_table_name as…
Amlan
- 15
- 8
-1
votes
2 answers
SQL: Conditional where with mutually involving all variables
How can I write a specific double or (multiple) where statement condition for an individual group involving conditions that should be included for all variables. Let me show you.
select
case, group, department, riskscore
from sometable…
John Rut
- 39
- 1
- 1
- 3
-1
votes
1 answer
GROUPed or used in an aggregate function error
I want to Group By CUSTOM_DRIVER in the query because I am getting over 1.3 million results and I just need to view them by Custom Driver for the month by store.
The query is returning me
I want something like this
I've tried using Distinct and…
adura826
- 103
- 1
- 1
- 10
-1
votes
1 answer
How to Export Data Structure from Aginity workbench for Redshift
I am trying to compare data structure from Toad for Oracle(Connected to SAP BO) and Aginity Workbench for Redshift.
I am unable to find a way to export the data structure from Aginity Workbench for Redshift to excel.
Finally, I want to export all…
Samir
- 1
- 3
-1
votes
1 answer
ERROR [HY000] ERROR: Aggregate function calls may not be nested */
I cannot get the below line to work when adding to my query, any thoughts?
stddev(stat) bias
with c as (
SELECT A.ENGINE_ASOF_CALENDAR_DATE, A.LEVEL_1_CODE CURR, CNTR_TO_ACTIVE_RISK, A.PRICE, a.ACTIVE_WEIGHT_PCT,
lag(a.PRICE, 1)…
Tim Cooper
- 11
- 4
-1
votes
1 answer
Unique names with employee department
I have an employee database and employees are appearing multiple times.
Some instances of same employee has employee department, where as in some other instances, employee department is missing. For this I need to find distinct of employee name…
StatguyUser
- 2,595
- 2
- 22
- 45
-1
votes
1 answer
How do I count number of columns that differ between rows with same ID?
Working with table containing 5 columns and many rows. Only column to note is Order_number. I need to be able to calculate the percent change between rows that have the same order_number, using first row as a reference.
Example: Say we have four…
LampPost
- 101
- 7
-2
votes
1 answer
Create an SQL query to find all tables in the whole Redshift database containing a specific text string (data)
using, Tableau or Aginity I am trying to find all the Tables in Redshift Database that contain the string of word "Certified Service".
Look online and so very long codes, as I am new to SQL I couldn't see what to replace in the code to adapt it to…
