#7898: vertica support | Aqua Data Studio

ivangron reported 2012-10-31T22:06:20Z · last modified 2013-02-14T11:21:19Z

vertica support

Dev	ivangron
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	App - General
Version	13.0

add support for vertica database type

All Comments (10) Change History

ivangron 2012-11-26T21:05:58Z · (edited)

Vertica Connection should be working

Vertica Object Tree is now showing all initial objects:

objects missing: non basic FUNCTIONS, PROJECTIONS ["indexes/ mat view] type object", RESOURCE POOLS, LIBRARY, SOURCE, FILTER, PARSER, TEMPORARY TABLES. This objects are non basic and will require a good bit of work.

Schemas -> extraction, scripting & gui working... GUI could use a little work...

Users -> extraction & scripting complete... GUI... complete...

Roles -> extraction & scripting complete... GUI... complete...

Profiles -> this is a new type of object... do we want to support extraction? scripting? need to code dialog?

Functiosn -> extract & scripting working complete for user defined sql function. Others extraction as much as possible but can't recreate there ddls. having trouble creating source, filter & parser function types. GUI?

Procedures -> unable to extract ddl information... no extraction means no scripting... GUI?

Tables -> extraction & scripting & GUI complete.

(1) unable to accurately extract segmentation clause [hash & range clause information not in catalog tables] : UNSEGMENTED info avaliable.

(2) unable to accurately extract k-safe #

(3) column datatype [Interval Day to Second(3)] is stored in the catalog tables as Interval(3). This is incorrect and causes issues when trying to recreated the table as the recreation will be set to Interval(3) witch is different. Interval(3) is stored as Interval. This bug is with vertica and nothing we can do to fix it.

Constraints -> extraction & scripting complete... no gui...

sequences -> extraction & scripting complete... gui create complete... gui alter -> alter statement supports lots, currently not supporting altering of sequence

views-> extraction, scripting & gui complete...

(*) need to move profiles, roles, users to Security Folder

SachinPrakash 2012-11-05T23:37:50Z · (edited)

When creating a table or schema from the GUI, do we use the option in File->Options->Scripts->Vertica->[Quote Identifier] ?

NielsGron 2012-11-05T22:12:31Z

Scripting Quote Identifier is controlled by File->Options->Scripts->Vertica->[Quote Identifier]. We should default to same as PostgreSQL.

SachinPrakash 2012-11-05T23:37:03Z

Scripting Quote Identifier is controlled by File->Options->Scripts->Vertica->[Quote Identifier]. We should default to same as PostgreSQL.

Seems we default PostgreSQL to "none". Why "none"?

http://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html

NielsGron 2012-11-05T23:46:18Z

We default to NONE because that is the most widely used by users. Double quotes indicates case sensitivity, and most users don't use that.

SachinPrakash 2012-11-08T22:05:05Z

Remove the "Create & Drop Database" GUI Commands

ivangron 2012-11-12T22:37:24Z · (edited)

Not Supported in Vertica

Create table GUI

Segmentation Option Not supported [hash | range | UNSEGMENTED]
Ksafe not supported
Partitioning information

ivangron 2012-11-14T22:46:06Z · (edited)

Not Supported in Vertica

ALTER SEQUENCE GUI

Vertica has an extensive DDL for altering sequence. alter currently not supported, just views details

ivangron 2012-11-27T16:27:43Z

initial vertica support for version 6.0 is now complete

tariqrahiman 2013-02-14T11:21:19Z

Vertica Database is now supported in ADS v13.0

Search Tips

Aqua Data Studio / nhilam

vertica support

Not Supported in Vertica

Create table GUI

Not Supported in Vertica

Create table GUI

Not Supported in Vertica

ALTER SEQUENCE GUI

Not Supported in Vertica

ALTER SEQUENCE GUI

Issue #7898

Completion

1 issue link

Issue #10115

Search Tips

Aqua Data Studio / nhilam

Title

vertica support

Not Supported in Vertica

Create table GUI

Not Supported in Vertica

Create table GUI

Not Supported in Vertica

ALTER SEQUENCE GUI

Not Supported in Vertica

ALTER SEQUENCE GUI

Issue #7898

Completion

1 issue link

Issue #10115