Skip to main content
Question

Looking for features available in Vertica and documentation page.

  • July 24, 2020
  • 6 replies
  • 13 views

Sankarmn
Forum|alt.badge.img+1

I am looking for what object types available in Vertica like view, synonym, procedure, function, packages, trigger, and like...
Appreciate if you can share the documentation page as well.

6 replies

LenoyJ
Forum|alt.badge.img+1
  • Participating Frequently
  • July 24, 2020

Sankarmn
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • July 24, 2020

This helps, but looking for feature available Vertica page. I can't say for sure Vertica doesn't have database triggers, synonyms, packages, index for data as objects, until I read the documentation.
Also How'z create any table, alter any table in multiple schemas are supported?


Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • July 25, 2020

You should start with concepts rather than specific language elements as some database elements are implemented in a Vertica-specific way with sometimes different names; for example, database indexes are called "projections" in Vertica, and projections differ from indexes in that all data in Vertica is stored in a projection, so effectively all data are in column-oriented storage that is sorted and grouped like an index.
Vertica Concepts and Architecture: https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/ConceptsGuide/Other/ConceptsGuide.htm
All supported SQL language elements, data types, functions, statements are documented at:
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SQLReferenceManual/SQLReferenceManual.htm
Multiple schemas are supported with standard dot notation "schema.table" and the standard SQL statements such as CREATE SCHEMA "schema" and CREATE TABLE "schema.table" are supported.


Sankarmn
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • July 27, 2020

Thanks for the details.
Please provide the document link for creating table in multiple schemas. What privileges a user needs to create tables on another schema.


marcothesane
Forum|alt.badge.img+1
  • Participating Frequently
  • July 27, 2020

It's GRANT CREATE ON SCHEMA my_schema TO that_other_one;
And the link is:
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SQLReferenceManual/Statements/GRANT/GRANTSchema.htm

I would also strongly suggest you go through "Getting Started" and "Vertica Concepts" that you find on the left navigation column, so you can check at your own pace and don't have to wait for someone to pick the thread up


marcothesane
Forum|alt.badge.img+1
  • Participating Frequently
  • July 27, 2020