当使用spark作为执行引擎时,如何禁用hiveshell上的日志?

llmtgqce  于 2021-06-27  发布在  Hive
关注(0)|答案(0)|浏览(256)

我想将配置单元查询的结果保存在一个文件中。但是hive的输出也有很多日志。有没有办法让它们失效。我只想捕获查询的结果。

hive> show databases;
2019-03-12 08:49:38 INFO  HiveConf:3944 - Using the default value passed in for log id: a02ee11b-32fe-4ed6-8c7a-e93a8fffb9c5
2019-03-12 08:49:38 INFO  Driver:429 - Compiling command(queryId=root_20190312084938_951426c7-96cc-4b9a-9be6-ed22c9e5c769): show databases
2019-03-12 08:49:39 INFO  metastore:407 - Trying to connect to metastore with URI thrift://hiveservice.staging.svc:9083 2019-03-12 08:49:39 INFO  metastore:481 - Opened a connection to metastore, current connections: 1
2019-03-12 08:49:39 INFO  metastore:534 - Connected to metastore.
2019-03-12 08:49:39 INFO  Driver:518 - Semantic Analysis Completed
2019-03-12 08:49:39 INFO  Driver:290 - Returning Hive schema:
.
.
.
.
2019-03-12 08:49:39 INFO  DDLTask:2506 - results : 1
2019-03-12 08:49:39 INFO  Driver:2050 - Completed executing command(queryId=root_20190312084938_951426c7-96cc-4b9a-9be6-ed22c9e5c769); Time taken: 0.102 seconds
OK
2019-03-12 08:49:39 INFO  Driver:1111 - OK
2019-03-12 08:49:39 INFO  DbLockManager:251 - releaseLocks: []
2019-03-12 08:49:39 INFO  deprecation:1285 - mapred.input.dir is deprecated. Instead, use mapreduce.input.fileinputformat.inputdir
2019-03-12 08:49:39 INFO  FileInputFormat:256 - Total input files to process : 1
2019-03-12 08:49:39 INFO  ListSinkOperator:690 - Closing operator LIST_SINK[0]
my_database
Time taken: 1.131 seconds, Fetched: 1 row(s)
2019-03-12 08:49:39 INFO  CliDriver:1111 - Time taken: 1.131 seconds, Fetched: 1 row(s)
2019-03-12 08:49:39 INFO  HiveConf:3944 - Using the default value passed in for log id: a02ee11b-32fe-4ed6-8c7a-e93a8fffb9c5
2019-03-12 08:49:39 INFO  SessionState:432 - Resetting thread name to  main
hive>

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题