hive 创建以后 mysql没有hive_hadoop的表

Question

<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

javax.jdo.option.ConnectionURL jdbc:mysql://hadoop000:3306/hive_hadoop?createDatabaseIfNotExist=true

javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver

javax.jdo.option.ConnectionUsername root

javax.jdo.option.ConnectionPassword Xiaoroot

mysql-connector-java-5.1.27-bin.jar 也放进去了

配置也配置了

也没有报错，不知道原因出现在哪呀 ，还有什么原因呀

这是mysql地址
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

Answer 1

慕斯8344354 2020-01-16 13:24:43

请问这个问题解决了吗？怎么解决的呢

Answer 2

Michael_PK 2020-01-16 14:39:48

你要去找hive的日志，看看报什么错

• 慕斯8344354 #1

  看过了，我的HIVE日志里没有报错

• 慕斯8344354 #2

  重装了下MySQL仍然不行。

• 慕斯8344354 #3

  2020-01-16 14:55:01,507 INFO  [main]: session.SessionState (SessionState.java:createPath(703)) - Created local directory: /tmp/3ea74c35-acbc-48e1
  -81b3-720171495523_resources
  2020-01-16 14:55:01,524 INFO  [main]: session.SessionState (SessionState.java:createPath(703)) - Created HDFS directory: /tmp/hive/root/3ea74c35-
  acbc-48e1-81b3-720171495523
  2020-01-16 14:55:01,529 INFO  [main]: session.SessionState (SessionState.java:createPath(703)) - Created local directory: /tmp/root/3ea74c35-acbc
  -48e1-81b3-720171495523
  2020-01-16 14:55:01,533 INFO  [main]: session.SessionState (SessionState.java:createPath(703)) - Created HDFS directory: /tmp/hive/root/3ea74c35-
  acbc-48e1-81b3-720171495523/_tmp_space.db
  2020-01-16 14:55:01,537 INFO  [main]: session.SessionState (SessionState.java:start(587)) - No Tez session required at this point. hive.execution
  .engine=mr.

点开查看后面11条评论

Answer 3

Michael_PK 2019-11-01 17:18:47

按照如下思路排查：

1）你的mysql地址，你先通过命令行是否能登陆？   

2）你的hadoop000是否正确映射了ip

3）去查看hive启动的日志信息（在conf下有个log4j的配置），查看了log4j记录的日志信息是否正确

4）换个hive_hadoop库名试试

• 提问者 自由邪帝 #1

  INFO  [main]: ql.Driver (Driver.java:compile(463)) - Semantic Analysis Completed
  INFO  [main]: ql.Driver (Driver.java:getSchema(245)) - Returning Hive schema: Schema(fieldSchemas:null, properties:null)
  INFO  [main]: ql.Driver (Driver.java:compile(541)) - Completed compiling command(queryId=root_20191103184848_4750c6b4-f713-4f16-ba65-a301cdc1f2db); Time taken: 0.087 seconds
  INFO  [main]: ql.Driver (Driver.java:checkConcurrency(165)) - Concurrency mode is disabled, not creating a lock manager
  INFO  [main]: ql.Driver (Driver.java:execute(1448)) - Executing command(queryId=root_20191103184848_4750c6b4-f713-4f16-ba65-a301cdc1f2db): create database tes11_db
  INFO  [main]: ql.Driver (Driver.java:launchTask(1772)) - Starting task [Stage-0:DDL] in serial mode
  WARN  [main]: metastore.ObjectStore (ObjectStore.java:getDatabase(620)) - Failed to get database tes11_db, returning NoSuchObjectException
  INFO  [main]: ql.Driver (Driver.java:execute(1696)) - Completed executing command(queryId=root_20191103184848_4750c6b4-f713-4f16-ba65-a301cdc1f2db); Time taken: 0.353 seconds
  
  有，是哪还有配置吗？ 还是下载有我问题，按照思路排查前两部都可以

• Michael_PK 回复 提问者 自由邪帝 #2

  这个日志并没有报错信息。你把hive删了，重新部署一个hive，然后MySQL的数据库换一个试试看