× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2013-12-04T01:33:24Z  · last modified 2015-04-01T22:14:43Z

Support node for Projections in Vertica


customer request
Priority Low
Complexity Unknown
Component App - Visual Editing
Version 16.0

Support node for Projections in Vertica - a new node to display all the projections in a database

 

Vertica Projections is like traditional materialized views
 
A Vertica projection can contain:
  • All the columns in a table.
  • Some of the columns in a table.
  • A prejoin among tables
CREATE TABLE trades (stock CHAR(5), bid INT, ask INT);
 
Create a Projection
 
CREATE PROJECTION tradeproj (stock ENCODING RLE, GROUPED(bid ENCODING DELTAVAL, ask))
      AS (SELECT * FROM trades) KSAFE 1;
 
Query to find projection
select * from v_catalog.projections where projection_schema='tariq'
 

http://www.vertica.com/2011/09/01/the-power-of-projections-part-1/
 
http://184.106.12.19/2011/09/02/the-power-of-projections-part-2/
 
http://184.106.12.19/2011/09/06/the-power-of-projections-part-3/

 

Issue #10956

Closed
Fixed
Resolved 2015-03-31T18:30:46Z
 
 
Completion
No due date
Fixed Build v16.0.3-1
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017