2020-11-05

作者: 仔仔H | 来源:发表于2020-11-05 22:48 被阅读0次

    在hive上执行插入数据,一直卡着

    0: jdbc:hive2://node02:10000> insert into stu values (1,"zhangsan");
    INFO  : Compiling command(queryId=root_20201105093355_cdaba547-5a2e-4ec9-ab15-a89408448721): insert into stu values (1,"zhangsan")
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Semantic Analysis Completed (retrial = false)
    INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col1, type:int, comment:null), FieldSchema(name:col2, type:string, comment:null)], properties:null)
    INFO  : Completed compiling command(queryId=root_20201105093355_cdaba547-5a2e-4ec9-ab15-a89408448721); Time taken: 0.364 seconds
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Executing command(queryId=root_20201105093355_cdaba547-5a2e-4ec9-ab15-a89408448721): insert into stu values (1,"zhangsan")
    WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
    INFO  : Query ID = root_20201105093355_cdaba547-5a2e-4ec9-ab15-a89408448721
    INFO  : Total jobs = 3
    INFO  : Launching Job 1 out of 3
    INFO  : Starting task [Stage-1:MAPRED] in serial mode
    INFO  : Number of reduce tasks determined at compile time: 1
    INFO  : In order to change the average load for a reducer (in bytes):
    INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
    INFO  : In order to limit the maximum number of reducers:
    INFO  :   set hive.exec.reducers.max=<number>
    INFO  : In order to set a constant number of reducers:
    INFO  :   set mapreduce.job.reduces=<number>
    

    查看日志,tmp是默认路径,root是登录用户名,hive.log是文件名,以前的日志,还有hive.log.2020-11-03
    tail /tmp/root/hive.log

    2020-11-05T09:35:49,591  INFO [HiveServer2-Background-Pool: Thread-270] ipc.Client: Retrying connect to server: node03/192.168.52.120:8032. Already tried 2 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1000 MILLISECONDS)
    2020-11-05T09:35:50,592  INFO [HiveServer2-Background-Pool: Thread-270] ipc.Client: Retrying connect to server: node03/192.168.52.120:8032. Already tried 3 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1000 MILLISECONDS)
    2020-11-05T09:35:51,593  INFO [HiveServer2-Background-Pool: Thread-270] ipc.Client: Retrying connect to server: node03/192.168.52.120:8032. Already tried 4 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1000 MILLISECONDS)
    2020-11-05T09:35:52,487  INFO [HiveServer2-Handler-Pool: Thread-63] conf.HiveConf: Using the default value passed in for log id: df6a81f9-4f62-49bf-81e3-275b8ac15362
    2020-11-05T09:35:52,487  INFO [df6a81f9-4f62-49bf-81e3-275b8ac15362 HiveServer2-Handler-Pool: Thread-63] conf.HiveConf: Using the default value passed in for log id: df6a81f9-4f62-49bf-81e3-275b8ac15362
    2020-11-05T09:35:52,487  INFO [HiveServer2-Handler-Pool: Thread-63] session.SessionState: Updating thread name to df6a81f9-4f62-49bf-81e3-275b8ac15362 HiveServer2-Handler-Pool: Thread-63
    2020-11-05T09:35:52,487  INFO [df6a81f9-4f62-49bf-81e3-275b8ac15362 HiveServer2-Handler-Pool: Thread-63] session.SessionState: Resetting thread name to  HiveServer2-Handler-Pool: Thread-63
    2020-11-05T09:35:52,594  INFO [HiveServer2-Background-Pool: Thread-270] ipc.Client: Retrying connect to server: node03/192.168.52.120:8032. Already tried 5 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1000 MILLISECONDS)
    

    是因为没有启动yarn

    start-yarn.sh

    使用:jps 查看进程,确定yarn起来后,再执行hive插入语句。

    相关文章

      网友评论

        本文标题:2020-11-05

        本文链接:https://www.haomeiwen.com/subject/nqrovktx.html