Netezza is a line of high-performance data warehouse appliances and advanced in-database analytics applications for uses including enterprise data warehousing, business intelligence, and predictive analytics. In 2010, Netezza became a subsidiary of IBM, and the product was subsequently rebranded as "PDA” In 2019 IBM launched a new generation of Netezza/PDA on the CloudPack for data stack. It runs on both cloud and on-prem specialized CP4D hardware.
Questions tagged [netezza]
1344 questions
0
votes
1 answer
Netezza insert same row into table multiple times
i have table with the following values
location date count
2150 4/5/14 100
now i need to insert 100 rows into another table .The table should have 100 rows of
location date
2150 4/5/14
Help me in achieving this.My database is netezza
0
votes
1 answer
Netezza and Regexp: how to remove all non letters from a string
I'm having a bit of trouble with the syntax and the documentation only confuses me more.
I'm trying regexp_extract_all(group_concat(score),'A-Z',''), but getting this error:
ERROR [42S02] ERROR: Function 'regexp_extract_all(varchar, unknown,…
Brandon
- 33
- 1
- 5
0
votes
1 answer
Select entire partition where max row in partition is greater than 1
I'm partitioning by some non unique identifier, but I'm only concerned in the partitions with at least two results. What would be the way to get out all the instances where there's exactly one of the specified identifier?
Query I'm using:
SELECT…
charles
- 547
- 1
- 3
- 11
0
votes
2 answers
The temp table is not drop at the end of session
If my understanding is correct, the temp table should be dropped automatically at the end of session. But after my stored procedure ends, the temp table is still there. Is anybody know how to use the tmp table? Thank you in advance.
YYY
- 605
- 3
- 8
- 16
0
votes
1 answer
Understanding Distribution
I have a couple of questions.
I would like to know if we need to worry about distribution in Netezza while using only select statements(not creating tables).
I am basically trying to create a dataset in SAS by connecting to Netezza and selecting…
Himanshu Gupta
- 13
- 1
0
votes
1 answer
error of importing data from csv file to IBM netezza sql database
I need to import a csv file (122 GB, all fields are integer or string) to a table on IBM netezza sql database through Aginity Netteza workbench.
I have created the table with fields that names match with ones in the csv file.
When I imported the…
user3601704
- 753
- 1
- 14
- 46
0
votes
2 answers
need query without cross join
i have a table which has sales at day level
sales_day
loc_id day_id sales
124 2013-01-01 100
124 2013-01-02 120
124 2013-01-03 140
124 2013-01-04 160
124 2013-01-05 180
124 2013-01-06 200
124 2013-01-07 …
0
votes
1 answer
How to convert string into number in netezza
i have table_1 include some field, one field name is THROUGHPUT in char datatype(the value is number)
i want to use function avg() to get average value from all THROUGHPUT value in netezza,
i have tried code for convert to float :
SELECT…
ihsansat
- 503
- 2
- 7
- 20
0
votes
1 answer
How to make time dimension in netezza?
I found a example sql to build time dimension, I get from this link https://gist.github.com/johngrimes/408559
everything is perfect in mysql,
but, when I tried in netezza, the code not work correctly, some error is appear, such as "expecting USING'…
ihsansat
- 503
- 2
- 7
- 20
0
votes
1 answer
Netezza SQL comparing two records in the same table
I am trying to do a basic insert from one table (#1) into another (#2), however I created a flag column in table #2 which in order to correctly set, I need to be able to determine the difference between 2 records in the source table (#1). This…
user3494110
- 417
- 2
- 9
- 25
0
votes
2 answers
SQL Select rows based on date
I have a two tables (Table1 and Table2):
Table1
Date Name Other
2014-02-08 Alex 1
2014-06-15 Bob 1
Table2
Date Name Count
2014-02-07 Alex 1
2014-01-31 Alex 2
2014-02-09 Alex 4
2014-02-08 Alex …
slaw
- 6,591
- 16
- 56
- 109
0
votes
1 answer
Left outer join query taking long time
I have an SQL query that runs for a very long time. The issue is that it uses a join inside case statement. is there any way we can optimize following query:
Select A.Field1, A.load_date, B.field3 from A left outer join B
on (A.field_date between…
Arnav
- 11
- 3
0
votes
1 answer
Obtaining decimal values in calculations in database
Recently, I came across an anomaly that while dividing two integers, I am getting only the quotients and reminders are simply ignored.
SELECT 12/8,12%8
The above query gives 1 and 4 respectively, which is similar to Java/C programming. Again…
Gdek
- 81
- 4
- 11
0
votes
1 answer
Sql for considering previous week same day sales if same day sales are 0
i have a store sales table which looks like below containing two years of data.
If the sales amount is '0' for a particular day for a particular store ,i have to take sales for same day last week.(current day-7)
if those sales are also '0' then…
0
votes
2 answers
Cast date to int4
I am using NETEZZA and I have two separate tables that I would like to join by the date. In the first table, the date is stored as type "date" (e.g., 2014-09-10) while in the second table, the date is stored as type "int4" (20140910). I've tried…
slaw
- 6,591
- 16
- 56
- 109