Stack Overflow
Stack Overflow

Questions tagged [netezza]

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.

Read more here

1344 questions
0
votes
2 answers

Query optimization (Netezza)

I am trying to solve a problem in Netezza for a friend of mine. My friend is trying to do something really simple in Netezza: select * from test where ID1 = 12345 and date >= 12/1/2012 and event date <= 12/31/2012 and ID2 in (x1, x2, ...,…
learning_spark
  • 669
  • 1
  • 8
  • 19
0
votes
1 answer

SQL query to calculate child value total for parent

I have the following query: select AD.ALLOCATION_INSTR_ID AS "Allocation Id" ,AD.ALLOCATION_INSTR_VERSION AS "Allocation Version" ,SUM(AC.CHARGE_AMOUNT) AS "Allocation Commission" ,AD.ALLOCATION_ID AS "Sub Allocation Id" …
Will
  • 8,246
  • 16
  • 60
  • 92
0
votes
1 answer

One SQL statement produce three tables

I need to create a sql statement which will produce three tables. I have the individual SQL code which if I run individually I can produce the three tables: Table 1 select t.TRADE_ID, t.TRADE_VERSION, t.TRADE_SOURCE_SYSTEM, tl.LINK_PARENT_ID,…
Will
  • 8,246
  • 16
  • 60
  • 92
0
votes
1 answer

Creating Custom Tables from DB results

I need to create a way to display my results from an SQL query in multiple columns. The sql is pretty basic it's a count of each entry of a certain type. so the SQL is something like Select count(distinct(id)) from Table where id_type = a Select…
Will
  • 8,246
  • 16
  • 60
  • 92
0
votes
3 answers

SQL: Compare two tables

Hi i have this scenario and i am struck here. I have two tables table A and table B which has one primary key in common (panelist_id) and for each panelist_id there are many entity_ids. I want to check whether for each panelist_id and same…
Mohit Bagadia
  • 33
  • 3
  • 9
0
votes
1 answer

Invalid packet length when connecting

Another team in my company commissioned a new server and installed Netezza on it, along with a bunch of internal programs. All of their programs that connect to Netezza are now giving this error: A connection error has occurred: Invalid packet…
The Awnry Bear
  • 4,599
  • 3
  • 29
  • 33
0
votes
1 answer

Error while saving binary image from database to folder

I need to retrieve an image from a database and save it to disk. In the database, the image is stored in binary format but datatype of the column is varchar(5000). This is the code that I am using for retrieving the image and saving it to disk…
Puneet Verma
  • 97
  • 2
  • 9
0
votes
3 answers

c# regular expression for Netezza data type

I'm kind of on a time crunch for a SQL schema migration for a large project at work, and haven't ever used regular expressions in C#. So I'm looking for a quick turn around hopefully. How can I write a regular expression in C# so it finds these…
JustBeingHelpful
  • 18,332
  • 38
  • 160
  • 245
0
votes
1 answer

Creating External Table takes long time

I have a table called table B that as 28 million records that is in Netezza and I want to export it to a text file so that I can export the text file to the mysql server. When I run the command below, the SQL client hangs. I am using SquirrelSQL.…
cool_cs
  • 1,661
  • 6
  • 20
  • 26
0
votes
3 answers

Character width exceeded

I create a master table with column A, column B, and column C. Whenever I try to insert row from another table using the command: INSERT INTO MASTER select * from Table B I get the error message "Character Width exceeded". I am not sure why.
cool_cs
  • 1,661
  • 6
  • 20
  • 26
0
votes
1 answer

SQL code to merge tables that do not match exactly

I have a table that looks like this: CODE ANIMAL 123 "Alligator" 1254 "Cardinal" 5675 "Golden Retreiver" And I have another table that looks like this: CODE TYPE 12367 Reptile 12 Bird 56 Dog I want to add the column Type to the first…
cool_cs
  • 1,661
  • 6
  • 20
  • 26
0
votes
1 answer

Syntax for importing table

What is the syntax for importing an external table into a created table? Whenever I right click on a table in squirrelsql, and click import file, I always get the error message "A database error has occurred. I suspect that Netzilla does not support…
user1408672
0
votes
1 answer

How to list all Sequences in netezza database?

Is there a query I can run to display all the existing sequences created in a netezza database? Thanks
Michael W
  • 3,515
  • 8
  • 39
  • 62
0
votes
1 answer

Complicated use of Substring function

I have a string which contains data like this (with the carriage return) [GBAP_ABC ] AAAAAAAAAAAAAAA [GBAP_DEF ] BBBBBBBBBBBBBBBBBBBBB I need to do a substring and retrieve only the AAAAAAAAAAAAAAA from the data. Do you know how I can…
Teja
  • 13,214
  • 36
  • 93
  • 155
0
votes
1 answer

SQL Server passing tables Netezza

Just wondering what is best practice to achieve: We have stored procedure that runs in SQL Server and needs to do some calculations with a huge fact table to be stored on Netezza. The flow: Stored procedure will create temp tables on SQL Server…
harelg
  • 1
  • 2
1 2 3
…
89 90