Vertica
DataGPT
透过技术圈百态,体会世间冷暖,树立正确的技术观、人生观、价值观和世界观
展开
-
Oracle和Vertica中构造日历数据
Vertica里面构造日历用法:SELECT to_number(TO_CHAR(ts::DATE,'yyyymmdd')) as day_id, year(ts::DATE) as year_of_calendar, month(ts::DATE) as month_of_year, dayofweek(ts::DATE) a原创 2014-02-12 16:12:24 · 1050 阅读 · 0 评论 -
[Vertica报错]Spread error; can't determine which DBs are running; attempting to continue... '
以dbadmin用户启动vertica数据库时,报下面的错误:Spread error; can't determine which DBs are running; attempting to continue... '*** Starting database: noas ***Enter password for dbadmin@10.41.20.116 (2 attempts原创 2014-06-25 14:07:39 · 2478 阅读 · 0 评论 -
vertica安装注意事项
vertica安装注意事项1、系统默认shell必须是bash shell echo $SHELL --查看默认shell chsh --更改系统默认shell2、文件系统必须是ext3或ext4(可用mount命令查看)3、查看系统是否支持sudo(若不支持需手动安装) which sudo4、修改配置文件/etc/sudoers (若已经有如下内原创 2015-02-07 11:45:21 · 2044 阅读 · 0 评论 -
测试Vertica性能
软件:Vertica 6.0.0-4OS: Red Hat EnterpriseLinux Server release 6.0(x86-64)Filesystem: ext4 三台服务器参数:cpu : 4P*8CIntel(R) Xeon(R) CPU E7- 8837 @ 2.67GHz 4P*8CIntel(R) Xeon(R) CPU E7- 4820原创 2015-02-07 11:41:56 · 3714 阅读 · 2 评论 -
Vertica常用操作总结
1. 修改列名称alterTABLEnoas_app.DIM_TNES_CELL_RAT rename rat_nameto CELL_RAT_NAME;2. Vertica导出自己测试NOAS252:/tmp/vertica6.1.2# /opt/vertica/sbin/install_vertica -s NOAS252 -rvertica-6.1.2-0原创 2015-02-07 11:44:14 · 23385 阅读 · 2 评论 -
Oracle和Vertica中构造日历数据
Vertica里面构造日历用法:SELECT to_number(TO_CHAR(ts::DATE,'yyyymmdd')) as day_id, year(ts::DATE) as year_of_calendar, month(ts::DATE) as month_of_year, dayofweek(ts::DATE) a原创 2014-03-25 21:45:36 · 1298 阅读 · 0 评论