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
18
votes
5 answers

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 (generically): connection = db.connect() # open connection/session sql = 'CREATE TEMP TABLE table1 AS SELECT…
DavidJ
  • 4,369
  • 4
  • 26
  • 42
15
votes
3 answers

Execute SQL file with multiple statements separated by ";" using pyodbc

I am currently writing a script to run multiple SQL files using Python, a little background before you mention alternative methods; this is to automate the scripts and Python is the only tools I have on our windows 2008 server. I have a script that…
Ninjaboy12
  • 181
  • 1
  • 3
  • 7
13
votes
3 answers

How do I list all the column names in Netezza?

Is there a query I can write to search all the column names for a particular database in Netezza?
Courtney
  • 131
  • 1
  • 1
  • 3
10
votes
2 answers

How do I convert date in Netezza to yyyymmdd from timestamp format?

How do I convert date in Netezza to yyyymmdd from timestamp format?
Ntiyiso Mbhalati
  • 109
  • 1
  • 1
  • 4
8
votes
4 answers

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 is) discussed in that post doesn't fix things for me. I'm trying to use Python 2.7.5 and pyodbc 3.0.7 to connect from an Ubuntu 12.04 64bit machine to an…
Gastove
  • 896
  • 2
  • 10
  • 21
8
votes
1 answer

Netezza Limit clause with order by

In Netezza, if I do: SELECT * FROM Tbl order by col1 LIMIT 10 OFFSET 20; First of all, what is OFFSET 20. And also, will this give me the first 10 rows specified in the order by or will the order by apply after random 10 rows are selected? I…
Victor
  • 16,609
  • 71
  • 229
  • 409
8
votes
3 answers

RODBC connection- limited rows

I set up an ODBC connect to a Netezza (SQL database). The connection is fine. However, R only pulls out 256 rows by default and restricts the number of rows it can pull out. If I ran the query in Netezza, it would return a total number of rows…
Luo Lei
  • 649
  • 2
  • 9
  • 19
8
votes
2 answers

create synonym for table in a database hosted in a different server

In oracle, if the other database is within the same server, I did the following to create a synonym CREATE SYNONYM synonymName FOR databaseName.schema.table; What should I do to create a synonym for tables in a database hosted in a different server…
chemicalkt
  • 816
  • 5
  • 16
  • 33
7
votes
1 answer

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 have set 4GB as memory limit for Java (options(java.parameters = "-Xmx4096m")) Query: insert into MY_TABLE_NAME select * from external…
KalC
  • 1,530
  • 3
  • 22
  • 33
7
votes
2 answers

find the table size on IBM netezza sql database from Aginity workbench on win 7

I need to find a table size on IBM netezza sql database from Aginity workbench on win 7. I used this SELECT * FROM _V_TABLE where tablename = 'my_table_name' But, no information about table size. I right-clicked the table name in Aginity, but,…
user3601704
  • 753
  • 1
  • 14
  • 46
7
votes
5 answers

Adding a constant value column in the group by clause

Netezza sql is giving error on this query:Cause: Invalid column name 'dummy'. select col1,col2, '' as dummy, max(col3) from table1 group by col1,col2,dummy If i remove the dummy from the group by clause, it works fine. But as per sql syntax, I am…
Victor
  • 16,609
  • 71
  • 229
  • 409
6
votes
4 answers

Extracting Day of Week as an Integer with Netezza SQL

This should be doable, but how can I extract the day of the week from a field containing data in date format with Netezza SQL? I can write the following query: SELECT date_part('day',a.report_dt) as report_dt FROM table as a but that gives me the…
user1205546
  • 61
  • 1
  • 1
  • 2
6
votes
4 answers

how does netezza work? how does it compare to Hadoop?

Want to understand whether Netezza or Hadoop is the right choice for the below purposes: Pull feed files from several online sources of considerable size at times more than a GB. Clean, filter, transform and compute further information from the…
sandeepkunkunuru
  • 6,150
  • 5
  • 33
  • 37
6
votes
1 answer

Using a filter condition on a 'PARTITION BY'

I have two tables. One is a Reference table, used to sort priority, and one is a Customer table. The Reference table is used to give priority to each column in the Customer table, to give a different order for the individual columns for a single…
alwaystrying
  • 163
  • 1
  • 1
  • 9
6
votes
4 answers

sql server replace special character with null

Im unable to replace an special character. Could you please help me on this. my input is: Mrs঩Montero output should be: Mrs Montero Special character is not displaying correctly. please see the below image.
srinath
  • 91
  • 1
  • 8
1
2 3
…
89 90