Top "Netezza" questions

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.

Python pyodbc connections to IBM Netezza Erroring

So. This issue is almost exactly the same as the one discussed here -- but the fix (such as it …

python odbc pyodbc netezza
How to compare dates in Netezza?

I am a new learner in Netezza. Right now, I wanna write a sql statement to feedback the recent data …

sql netezza
Loading data of one table into another residing on different databases - Netezza

I have a big file which I have loaded in a table in a netezza database using an ETL tool, …

netezza
Netezza CSV load

We are new to netezza and currently trying to import a CSV file, via script, into netezza. What is the …

csv netezza
Bad timestamp external representation Error in Netezza

I was running below query in Netezza and getting mentioned error. Query: SELECT * FROM WORKORDER SRC INNER JOIN APPOINTMENT TRG …

sql netezza
Drop if exists in netezza

I need a command to delete a table if that exists in NETEZZA, Something like that: drop table if exists …

if-statement exists netezza
R JDBC error "Unable to retrieve JDBC result set for insert into ..."

I am trying to write an R data.frame to a Netezza table. It has about 55K rows and I …

r netezza rjdbc
How can pandas.read_sql_query() query a TEMP table?

I'm in the process of converting Python code over to the new SQLAlchemy-based Pandas 0.14.1. A common pattern we use is (…

sql python-2.7 pandas sqlalchemy netezza
Netezza Update a Table Column by Joining to Another Table

I am getting an error by running an update, but I can not figure out where the issue is in …

sql netezza
Netezza SQL to join a table if that table contains relevant data

I am trying to join tables based on certain columns being within a specified time range. I've tried several methods …

sql netezza