分类：技术

技术

hive使用postgresql启动问题No suitable driver found

环境：CentOS 6.4, hadoop 2.6, hive 1.1，postgresql 9.4

 

在启动hive的时候出现No suitable driver found for jdbc:postgres://xxx.xxx.xxx.xxx:5432/hive

依据提示是说postgresql jdbc包找不到，反复确认包是存在lib文件夹内。

最终发现hive-site.xml中的

<value>jdbc:postgres://xxx.xxx.xxx.xxx:5432/hive</value> 的问题。修改为

value>jdbc:postgresql://xxx.xxx.xxx.xx:5432/hive</value>即可

Micrsoft开源的lightLDA

环境：Ubuntu 14.04

git clone https://github.com/Microsoft/lightlda.git
cd lightlda/

vi build.sh
修改如下：
#git clone https://github.com:Microsoft/multiverso.git
git clone https://github.com/Microsoft/multiverso.git

sh build.sh

cd example

export LD_LIBRARY_PATH=~/lightlda/multiverso/third_party/lib:$LD_LIBRARY_PATH
sh nytimes.sh

apt-get update 问题

环境：Ubuntu 14.04

使用apt-get update出现如下问题：

Fetched 11.8 MB in 26s (448 kB/s)
W: GPG error: http://security.debian.org wheezy/updates InRelease: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 9D6D8F6BC857C906 NO_PUBKEY 8B48AD6246925553
W: GPG error: http://http.debian.net wheezy-updates Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 8B48AD6246925553 NO_PUBKEY 7638D0442B90D010
W: Failed to fetch http://packages.couchbase.com/ubuntu/dists/trusty/InRelease Unable to find expected entry ‘precise/main/binary-amd64/Packages’ in Release file (Wrong sources.list entry or malformed file)

W: Failed to fetch http://http.debian.net/debian/dists/wheezy/Release.gpg Connection failed

 

解决方法，增加公共的key:
sudo apt-key adv –keyserver keyserver.ubuntu.com –recv-keys 9D6D8F6BC857C906 8B48AD6246925553 7638D0442B90D010 6FB2A1C265FFB764