A data warehouse and analytic appliance suite that IBM purchased around 2010. Utilizes SQL language to query data. It is a contender in the "big data" market and used comparable to Teradata or Hadoop. Pronounced Ne-Tease-Ah.

learn more… | top users | synonyms

4
votes
1answer
3k views

Netezza: What schema contains all the system tables / views?

Is there a schema I can look in or a query that I can run to see all the Netezza system or metadata tables? I know about _v_table, _v_view, _v_relation_column, and _v_groupusers. I know there are ...
1
vote
0answers
83 views

What would be the rule for parsing parameterized sql for Netezza to be used with nzsql?

I have a bunch of legacy parametrized SQL templates that were used by nzsql utility for Netezza. See examples here: http://queforum.com/netezza/347918-parameterized-sql-file-input-nzsql.html What is ...
0
votes
0answers
5 views

How to derive allowable threshold limits in Netezza

Our vendor sends us a daily extract containing customer data and we load these into our Netezza database daily. Each day, the row counts typically get slightly bigger however it is possible for some ...
0
votes
0answers
23 views

Is it possible to stack similar columns from a subquery and join the other unique columns in one query?

I am fairly new to the sql world and have been struggling with a query. I have two subqueries that are generating tables with two columns. The first table is part # and model_countH. The second table ...
0
votes
0answers
13 views

table corresponding to view in netezza

In netezza how to find the table corresponding to the view or vice-versa. Kind of how to do this search select a.tablename , b.viewname , b.definition from _V_table a , _V_VIEW b where b.definition ...