CPU: Intel® Xeon(R) CPU E3-1231 v3 @ 3.40GHz × 8
显卡: GTX1070Ti
系统: Ubuntu 16.04 LTS
sudo apt update
sudo apt upgrade
sudo apt install apt-transport-https
sudo reboot
sudo useradd -U mapd
sudo ufw disable
sudo ufw enable
sudo ufw allow 9092/tcp # MapD还需要9091和9093端口,参照这个添加即可
这里提供各个版本驱动下载地址: https://developer.nvidia.com/cuda-toolkit-archive
进入下载路径
sudo dpkg -i cuda-repo-ubuntu1604-8-0-local8.0.44-1amd64.deb
sudo apt-get update
sudo apt-get install cuda
sudo reboot
nvidia-smi # 验证是否安装成功
sudo apt install curl
curl https://releases.mapd.com/ce/mapd-ce-cuda.list | sudo tee /etc/apt/sources.list.d/mapd.list
curl https://releases.mapd.com/GPG-KEY-mapd | sudo apt-key add -
sudo apt install mapd
vi ~/.bashrc
# 添加如下内容
export MAPD_USER=mapd
export MAPD_GROUP=mapd
export MAPD_STORAGE=/var/lib/mapd
export MAPD_PATH=/opt/mapd
# 使其生效
source ~/.bashrc
sudo mkdir -p $MAPD_STORAGE
sudo chown -R mapd:mapd $MAPD_PATH
sudo chown -R mapd:mapd $MAPD_STORAGE
需要详细配置参考: https://www.mapd.com/docs/latest/getting-started/configuration/
cd $MAPD_PATH/systemd
sudo ./install_mapd_systemd.sh
# 之后一路回车即可
cd $MAPD_PATH
# 打开服务
sudo systemctl start mapd_server
sudo systemctl start mapd_web_server
# 将服务设置开机自启动
sudo systemctl enable mapd_server
sudo systemctl enable mapd_web_server
cd $MAPD_PATH
sudo ./insert_sample_data
Enter dataset number to download, or 'q' to quit:
# Dataset Rows Table Name File Name
1) Flights (2008) 7M flights_2008_7M flights_2008_7M.tar.gz
2) Flights (2008) 10k flights_2008_10k flights_2008_10k.tar.gz
# 选择2
# 进入命令行
$MAPD_PATH/bin/mapdql
# 密码默认为: HyperInteractive
随便进行一个简单的查询
SELECT * FROM flights_2008_10k;
查询的出结果,说明正确
进入Web页面: http://localhost:9092
Click New Dashboard.
Click Add Chart.
Click SCATTER.
Click Add Data Source.
Choose the flights200810k table as the data source.
Click X Axis +Add Measure.
Choose depdelay.
Click Y Axis +Add Measure.
Choose arrdelay.
然后你会得到图
成功