Questions tagged [aginity]
88 questions
0
votes
2 answers
Convert Date to Integer in netezza
Please help in converting the date field to integer in YYYYMMDD format
Date col- YYYY-MM-DD HH:MM:SS - 2020-05-20 00:00:00
Required output - YYYYMMDD - 20200520
IN Aginity workbench (Netezza).
Mihul12
- 1
- 1
0
votes
1 answer
generate serial number in decreasing order given a variable in netezza aginity sql
Is there any SQL syntax using netezza SQL, given column number, trying to generate rows for number in decreasing order down to 0.
Below is an example of what I'm trying to…
user15957051
- 3
- 1
0
votes
0 answers
How to sum fields with Aginity pro?
I´m trying to sum some fields in the select in Aginity Pro but it is not working.
I´ve tried the following that works in QMF for Work Station:
(M1_BILLING_PY + M2_BILLING_PY + M3_BILLING_PY) QTD_BILLING_PY,
but it is not working. I´ve tried to find…
Gema
- 1
- 1
0
votes
2 answers
Do I need to perform a Join in order to merge multiple columns with 0 in them
I may have asked this question incorrectly but I have the following query where I'm trying to pull 3 different metrics for a given store. When I pull them though it comes out as below:
Is there a way I could get all of these so that the Generated,…
adura826
- 103
- 1
- 1
- 10
0
votes
1 answer
How to get distinct counts for values in columns
I have a table and two of it's columns look like this:
Name cars_owned
Adam Audi
David BMW
Steve Ford
John Audi
Adam Audi
....This continues on for ~1,000 rows
I want an output like this:
cars_owned …
qazwsx123
- 237
- 4
- 11
0
votes
0 answers
Is there a way to get all column names in a table for IBM Netezza?
I'm using aginity workbench and netezza at my workplace.
Is it possible to run a query to get all columns for the tables stored here?
Thanks
jiwon chang
- 21
- 2
0
votes
2 answers
Inner Join Results from two separate queries
I have to query results from three different tables and so far have been able to get the separate results individually. Now I'd like to join these results. The following two pieces of code are my queries. Should I nest the two somehow? I would want…
adura826
- 103
- 1
- 1
- 10
0
votes
1 answer
I am trying to count every unique order number that have multiple booking location id
What's wrong on my code here? I am getting an error from Redshift when executing these lines.
SELECT
COUNT (
DISTINCT (
CASE
WHEN EXISTS(
(
select
…
Saleh Manggana
- 1
- 1
0
votes
1 answer
How to resolve 'reserve exceeded (host) : Out of memory' issue with Netezza database?
How to resolve 'reserve exceeded (host) : Out of memory' issue with Netezza database?
I try to execute Netezza database table small query using aginity tool and i got 'reserve exceeded (host) : Out of memory' issue. How to resolve this issue?
Jeyavel
- 2,974
- 10
- 38
- 48
0
votes
1 answer
Can I continue to use Aginity Workbench for redshift
Aginity announced they are stopping free aginity workbench and moving to aginity pro and aginity team. Can i continue to use my aginity workbench which is free?
Manu Mohan
- 167
- 3
- 17
0
votes
1 answer
Redshift access denied automatically in REDSHIFT
grant usage on schema apps to group group_name;
grant SELECT ON ALL TABLES IN schema apps to group group_name;
alter default privileges in schema apps grant select on tables to group group_name;
Comments used by gave access to group
I created the…
Ganesh Pitchai
- 75
- 1
- 5
0
votes
1 answer
New Customer Orders, but only if they purchased 1 week after registering
So what I'm trying to do is understand what products my new customers purchase, 1 week after they registered.
Currently, this is my query:
SELECT
item_description_1,
t3.new_division,
quantity_ordered
FROM
mdwh.us_raw.order_report
…
Z41N
- 97
- 10
0
votes
2 answers
Joining using || - No results
This is what I am currently joining:
INNER JOIN us_raw.l_dmw_order_report t1 on t2.channel_uid = t1.customer_id
However, I need it so that it's like this instead:
INNER JOIN us_raw.l_dmw_order_report t1 on t2.channel_uid = ('UNU' ||…
Z41N
- 97
- 10
0
votes
1 answer
RFM Analysis - Value keeps changing
Got the following query going.
SELECT
customer_id,
NTILE(5) OVER (ORDER BY MAX(oms_order_date)) AS r_score
FROM
mdwh.us_raw.l_dmw_order_report
WHERE
quantity_ordered > 0
AND customer_id IS NOT NULL
AND customer_id != ('')
…
Z41N
- 97
- 10
0
votes
1 answer
Generating a basic sales report
So close to finish generating a report using SQL only. Very proud, but I'm stuck because I know I'm doing something the long way (the subquery in the SELECT statement).
I'm trying to fix the jan2019_sales, because its just giving me the SUM of…
Z41N
- 97
- 10