Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am new to HP Vertica. I read the installation documentation for the HP Vertica. The documentation is totally based on the *ix environment. So, my question is Can we install HP Vertica on Windows also ?

The other thing, as far as the commands I searched, these are same as the Oracle SQL commands. So, do we use the same SQL commands for the HP Vertica also ?

The other concept about the cluster, instance, node, database that I understood is,

HOST: is a computer where the Vertica is installed.

INSTANCE: it is also a computer where the Vertica is in running state. 

Node: it is the combination of HOST & INSTANCE.

CLUSTER: I am not clear about this. May be this is about the instances of Vertica running on different computers.

DATABASE: It is the actual installed database software where the data & catalog resides to which other nodes are connected (not sure abt this also).

Please help me understand the concepts, If anyone knows it well.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Vertica only runs on Linux, you can have a Windows client to acesso Vertica. But don't get scared Linux is not such a scary dragon kkkkk. Vertica installs as 1,2,3 check this link for a full installation article. Vertica uses SQL ANSI so no need for you to learn other languages, it has it's differences but is easy to work with. No need for you to break you brain in doing performance tuning and all those Oracle crazy queries, or create a billion indexes in SQL SERVER, Vertica does this for you. With the Database designer you can throw your query into Vertica and Vertica will create the optimum design for you.

I think that Vertica arch is so simple that people are confused about it !! kkkk HOST: is a computer where the Vertica is installed. - is a linux box that has the Vertica software installed with the required configuration to see the configuration needs go to this link for a full how to tutorial

INSTANCE: it is also a computer where the Vertica is in running state. - this is the linux box with Vertica installed and up and running(as a single node or as part of a cluster) take a look at this link for more details about Vertica arch topology

Node: it is the combination of HOST & INSTANCE. Once more the link i gave you would explain this point. A node is a part of a cluster that has the Vertica software up and running on it. The instance is made of the processes that Vertica software creates when the Vertica engine is started. So in short Node is made of the Host(is the linux box with the Vertica software) and Instance(are the processes that the Vertica software creates) - this is not specifically for Vertica, it applyes to all databases.

CLUSTER: I am not clear about this. May be this is about the instances of Vertica running on different computers. - a cluster is a collection of Vertica instances. Why do cluster is good ? MPP(massive parallel processing), HA(high availability).

DATABASE: It is the actual installed database software where the data & catalog resides to which other nodes are connected (not sure abt this also). The database is combination of Software(all those binary+ more files filed with code + datafiles(these files hold the data that is processes by your database)) and the instance (once again the instance is the process created by your database software). - I hope i could help ! Feel free to visit this link for more Vertica scripts, articles and tutorials. Also this link

share|improve this answer
    
Thanks Up_One. I have installed it on my Ubuntu & also using it. –  Aditya Jan 24 at 4:42
    
That is great Aditya !! Feel free to check www.aodba.com for tutorials and Vetica articles –  Up_One Jan 24 at 13:13
    
Was my answer correct ? –  Up_One Jan 24 at 13:28
    
Up_One question. Thank you. –  Aditya Jan 29 at 4:02

From the cross-posted site:

Vertica only works on Linux, and only some flavors of Linux are supported officially (can't support everything).

Vertica's SQL is based on PostgreSQL.

1 Vertica instance runs over multiple nodes acting in parallel. All of them together constitute the cluster.

share|improve this answer
    
thanks @geoffrobinson. –  Aditya Jan 24 at 4:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.