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.