05 2017 档案

hive_hiveserver2 hive-site.xml config and start
摘要：hive-site.xml # vi hive-site.xml <configuration> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://sd-9c1f-2eac:3306/hive?cre 阅读全文
posted @ 2017-05-05 17:21 天天好心情啊 阅读(1084) 评论(0) 推荐(0)
Caused by: MetaException(message:Hive Schema version 2.1.0 does not match metastore's schema version 1.2.0 Metastore is not upgraded or corrupt)_2
摘要：[Dev root @ sd-9c1f-2eac /usr/local/src/apache-hive-2.1.1-bin/scripts/metastore/upgrade/mysql]# ls001-HIVE-972.mysql.sql 027-HIVE-12819.mysql.sql hive 阅读全文
posted @ 2017-05-05 14:29 天天好心情啊 阅读(1993) 评论(0) 推荐(0)
Hive MetaStore Upgrade
摘要：# cd $HIVE_HOME/scripts/metastore/upgrade/mysql [Dev root @ sd-9c1f-2eac /usr/local/src/apache-hive-2.1.1-bin/scripts/metastore/upgrade/mysql]# ls001- 阅读全文
posted @ 2017-05-05 11:51 天天好心情啊 阅读(1489) 评论(0) 推荐(0)
Error: Duplicate key name 'PCS_STATS_IDX' (state=42000,code=1061)
摘要：以下异常说明mysql已经启动。 应先关掉先前启动的mysql.再执行初始化schema操作。 $service mysql stop; # $HIVE_HOME/bin/schematool -dbType mysql -initSchemawhich: no hbase in (/usr/lib 阅读全文
posted @ 2017-05-03 16:47 天天好心情啊 阅读(11632) 评论(0) 推荐(1)