1
推荐
1837
阅读
Drill集群安装
1.环境1.1 jdk/opt/jdk1.7.0_791.2Drill版本/opt/apache-drill-1.7.01.3zookeeper地址SZB-L0032013:2181,SZB-L0032014:2181,SZB-L0032015:21811.3Drill集群服务器 10.20.25.199 SZB-L0032015 10.20.25.241 SZB-L0032016 10.20.25.137 SZB-L0032017 2....
2
推荐
2268
阅读
Zeppelin通过spark展示hive数据
1.hive数据库和表查看hive> show databases;
OK
default
tpc
hive> use tpc;
OK
hive> show tables;
OK
call_center
catalog_page
catalog_returns
catalog_sales
customer
customer_address
customer_demographics
date_dim
dbgen_version
household_demographics
income_band
inventory
item
promotion
reaso...
2
推荐
2150
阅读
Greenplum创建外部表
1.数据地址 SZB-L0038788的/data/tpc-data目录2.数据格式 文本数据 1|AAAAAAAABAAAAAAA|18|Jackson |Parkway|Suite 280|Fairfield|Maricopa County|AZ|86192|United States|-7|condo|3.GP的master是SZB-L00387844.定义外部表ddl语句CREATE EXTERNAL TABLE ext_customer_address (
ca_address_...
2
推荐
2361
阅读
greenplum安装
1.参考文档:http://gpdb.docs.pivotal.io/4390/common/welcome.html2.环境信息linux: centos6.3 64 位greenplum-db-4.3.9.1-build-1-rhel5-x86_64.zip3. root用户安装4.linux环境设置4.1防火墙设置# vi /etc/selinux/configSELINUX=disabled# chkconfig iptables off# chkconfig --list iptables4.2配置IP映射和主机名#...