vertica 在windows怎么安装

1. su - root 切换到root用户下
2. 删除原安装的，参照文档。
3. 网络设置：虚机下安装时，确认网络是否连接？（目前测试时，需要连接网络才行，本地连接才能获得IP,如果不连，获取不到IP,则无法FTP到虚机的服务器上）
4. 上传安装文件和license.
a) sftp> ls
b) anaconda-ks.cfg install.log install.log.syslog
c) sftp> lls
d) Access Connections Altova Book1.xlsx
e) sftp> lcd e:\vertica
f) sftp> lls
g) 564d3724-a605-3d66-3b90-32afb293b031.vmem
h) sftp> ls
i) anaconda-ks.cfg install.log install.log.syslog
j) sftp> pwd
k) sftp> put vertica-5.0.4-0.x86_64.RHEL5.rpm
l) Uploading vertica-5.0.4-0.x86_64.RHEL5.rpm to /home/dbadmin/vertica-5.0.4-0.x86_64.RHEL5.rpm
m) 100% 64108KB 2787KB/s 00:00:23
n) e:/vertica/vertica-5.0.4-0.x86_64.RHEL5.rpm: 65647286 bytes transferred in 23 seconds (2787 KB/s)
o) sftp>
p) sftp> put vlicense.dat
q) Uploading vlicense.dat to /home/dbadmin/vlicense.dat
r) 100% 572 bytes 572 bytes/s 00:00:00
s) e:/vertica/vlicense.dat: 572 bytes transferred in 0 seconds (572 bytes/s)
t) sftp>
5. hosts文件设置：增加 127.0.0.1 vertica 如果有多个结点，需要增加多个。目前只有一个机器，即本地。
Cd etc
Vi hosts
[root@vertica ~]# pwd
/root
6. 安装
--注意版本
[root@vertica /]# # rpm -Uvh /home/dbadmin/vertica-5.0.4-0.i386.RHEL5.rpm
[root@vertica /]# rpm -Uvh /home/dbadmin/vertica-5.0.4-0.i386.RHEL5.rpm
Preparing... ########################################### [100%]
1:vertica ########################################### [100%]

Vertica Analytic Database V5.0.4-0 successfully installed on host vertica

---------------------------------------------------------------------
run: /opt/vertica/sbin/install_vertica

[root@vertica /]# /opt/vertica/sbin/install_vertica -s vertica -r "vertica-5.0.4-0.i386.RHEL5.rpm" -u dbadmin
--其中-u dbadmin 是要先创建，还是在此指定后会默认创建？（dbadmin可以换其它名字，默认会创建）
Vertica Analytic Database 5.0.4-0 Installation Tool
Invalid path for rpm file: /vertica-5.0.4-0.i386.RHEL5.rpm
Installation completed with errors.
Installation failed.
[root@vertica /]# /opt/vertica/sbin/install_vertica -s vertica -r "/home/dbadmin/vertica-5.0.4-0.i386.RHEL5.rpm" -u dbadmin
Vertica Analytic Database 5.0.4-0 Installation Tool
Upgrading admintools meta data format..
scanning /opt/vertica/config/users
Starting installation tasks...
Getting system information for cluster (this may take a while)....
Checking/fixing OS parameters.....

Creating/Checking Vertica DBA group

Creating/Checking Vertica DBA user

Creating Vertica Data Directory...

Updating spread configuration...
Verifying spread configuration on whole cluster
Creating node node0001 definition for host 127.0.0.1
... Done
Error Monitor 0 errors 0 warnings
Installation complete.

To create a database:
1. Logout and login as dbadmin.**
2. Run /opt/vertica/bin/adminTools as dbadmin
3. Select Create Database from the Configuration Menu

** The installation modified the group privileges for dbadmin.
If you used sudo to install vertica as dbadmin, you will
need to logout and login again before the privileges are applied.

[root@vertica /]# su - dbadmin
[dbadmin@vertica ~]$ adminTools
进入图形界面，根据提示，建database。
创建schema
执行 Select 1 from dual
创建表，执行建表语句
导入数据
优化