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

Netezza string comparison

I have 2 columns string and Character. My requirement is to compare those 2, if the second column(char) is available in first column(string) the answer should be some value(say 1). I tried using translate but it doesn't work. Any functions available…
Gdek
  • 81
  • 4
  • 11
0
votes
1 answer

What does scan prep node indicate in netezza plan file?

While looking at query plan/execution time, I observed that it is taking most of the time in scanprepnode. Is it related organized on columns. I have two organized on columns in the table used in the query. Here is snippet from plan file 1[00]: spu…
Jack
  • 741
  • 1
  • 8
  • 25
0
votes
1 answer

SQL combine two tables into one table and add a new column

I need to combine two tables into one. Ans also, add a column (assign an int value) to the new table on SQL. So that the rows from table1 and ones from table2 are assigned with different values. Example, table1 ID1 ID2 ID3 VALUE …
user3448011
  • 1,469
  • 1
  • 17
  • 39
0
votes
0 answers

Netezza insert fail for DATE type value

Issue description: query = insert into tbl_test ("id", "date_col") values (?, ?) cursor.executemany(query, [(1,'1955-05-20'), (1,'1955-05-20'),]) Erro message: internal error: Error executing query Operation canceled for query " INSERT INTO…
user2728230
  • 21
  • 1
  • 2
  • 5
0
votes
1 answer

check the likeness between two very large data tables on SQL

I need to check the likeness between two data tables on SQL. I am working on Aginity Workbench for Netezza on Win 7. The tables are very large. One of them has 100 million rows and 4 columns; another one has 1500 million rows and 3 columns.…
user3448011
  • 1,469
  • 1
  • 17
  • 39
0
votes
2 answers

Convert hh:mm to ss on netezza (SQL)

I have a char datatype that contains data in hh:mm format and i would like to convert into seconds in netezza DB. For eg: 1:23 to seconds? Thanks
user3438791
  • 89
  • 1
  • 3
  • 15
0
votes
1 answer

Error while using NZload

I am trying to use nzload to load a file residing in a unix directory to a NZ database but I keep getting the following error: nzsql "nzload -u $NZ_USER -pw $NZ_PASSWORD -host $NZ_HOST -db $NZ_DATABASE -df -lf log.txt -bf err.txt" nzsql: database…
KKISHORE
  • 55
  • 1
  • 1
  • 6
0
votes
1 answer

error of loading a data txt file to a table on Neteza

I need to load a data txt file (a large file 32 GB) to a table in Neteza. But, I got error: 08S01 Communication link failure The communication link between the driver and the data source to which the driver was attempting to connect failed…
user3448011
  • 1,469
  • 1
  • 17
  • 39
0
votes
2 answers

select min and max values before a particular row per customerID SQL

I have a table which has info about visitors to our website. So it will look like VISITOR_ID EVENT Date Rank ( I already ranked them portioned by event) Visitor_id Event Date rank 1 visit 1/1/14 1 1 purchase …
user3571236
  • 3
  • 3
0
votes
3 answers

How do I write a query that imputes values for records that are not present in a table?

I have a table that looks like this: MONTH | WIDGET | VALUE ------+--------+------ Dec | A | 3 Jan | B | 5 Feb | B | 6 Mar | B | 7 and I want to write a query that produces, for each MONTH and WIDGET the…
jl6
  • 6,110
  • 7
  • 35
  • 65
0
votes
1 answer

Netezza JDBC MetaData information for DISTRIBUTE clause

Is there a way to retrieve the DISTRIBUTE clause from a Netezza table using JDBC MetaData?
Constantin
  • 1,506
  • 10
  • 16
0
votes
0 answers

convert db2 current timezone to netezza

I am doing work to convert db2 sqlquery to netezza. I found select (timestamp("DATE") + current timezone) AS TXN_DATE from table_name; which is not supported in Netezza. What is equivalent Netezza query of above db2 sql query?
Dinesh Subedi
  • 2,603
  • 1
  • 26
  • 36
0
votes
1 answer

Is it possible to update a table in another Netezza database on same server?

I am trying to update tables in a production environment from a staging environment. I wrote an update statement (simplified version below) that will use data from another database and I'm getting a "Cross Database Access not supported for this type…
Kelly
  • 945
  • 2
  • 18
  • 31
0
votes
1 answer

Undefined symbol error when testing Netezza UDX

I'm trying to implement a Netezza UDX that uses R language through Rserve (therefore I use Rconnection library for C++). Currently I've written only the bare minimum required for the UDX to run. It looks as follows: #define MAIN // Netezza UDX…
user2628342
0
votes
1 answer

Change Collation in Netezza Server

I am trying to sort a list of records in Netezza, but their sort order seems different from SQL server. In Netezza, I get AZ ahead of Aaaaa. In SQL Server, I get Aaaaa ahead of AZ. My SQL server collation is SQL_Latin1_General_CP1_CS_AS. My Netezza…
daniely
  • 7,313
  • 5
  • 29
  • 46
1 2 3
…
89 90