clickhouse-local --help | grep log
--logger.log arg Log file name
--logger.level arg Log level
clickhouse-local -q 'select 1' --logger.log=log.txt
Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = Not found: application.baseName, Stack trace (when copying this message, always include the lines below):
0. /build/obj-x86_64-linux-gnu/../contrib/poco/Foundation/src/Exception.cpp:27: Poco::NotFoundException::NotFoundException(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x1065e000 in /usr/lib/debug/usr/bin/clickhouse
1. /build/obj-x86_64-linux-gnu/../contrib/poco/Util/src/AbstractConfiguration.cpp:77: Poco::Util::AbstractConfiguration::getString(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const (.cold) @ 0x105834ba in /usr/lib/debug/usr/bin/clickhouse
2. /build/obj-x86_64-linux-gnu/../contrib/libcxx/include/string:2134: Poco::Util::Application::commandName() const @ 0x10589761 in /usr/lib/debug/usr/bin/clickhouse
3. /build/obj-x86_64-linux-gnu/../contrib/poco/Util/include/Poco/Util/Application.h:438: DB::LocalServer::initialize(Poco::Util::Application&) @ 0x92c9e57 in /usr/lib/debug/usr/bin/clickhouse
4. /build/obj-x86_64-linux-gnu/../contrib/poco/Util/src/Application.cpp:334: Poco::Util::Application::run() @ 0x10589239 in /usr/lib/debug/usr/bin/clickhouse
5. /build/obj-x86_64-linux-gnu/../programs/local/LocalServer.cpp:516: mainEntryClickHouseLocal(int, char**) @ 0x92c9b76 in /usr/lib/debug/usr/bin/clickhouse
6. /build/obj-x86_64-linux-gnu/../contrib/libcxx/include/vector:461: main @ 0x91498f9 in /usr/lib/debug/usr/bin/clickhouse
7. /build/glibc-OTsEL5/glibc-2.27/csu/../csu/libc-start.c:344: __libc_start_main @ 0x21b97 in /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.27.so
8. _start @ 0x914902e in /usr/lib/debug/usr/bin/clickhouse
(version 20.5.1.3327 (official build))