$ TMP=/non-existent-folder-12123 clickhouse-local -q 'SELECT 1'
filesystem error: in temp_directory_path: path "/non-existent-folder-12123" is not a directory: Not a directory

$ TMP=/non-existent-folder-12123 clickhouse-local -q 'SELECT 1'
1

$ TMP=/asdfasd clickhouse-local -q 'SELECT 1' --logger.console=1 
Logging trace to console
2020.10.23 14:55:45.388044 [ 223 ] {} <Debug> Application: Can not get temporary folder: filesystem error: in temp_directory_path: path "/asdfasd" is not a directory: Not a directory
2020.10.23 14:55:45.390411 [ 223 ] {} <Debug> Application: Will create working directory inside current directory: /
2020.10.23 14:55:45.390540 [ 223 ] {} <Debug> Application: Working directory created: /clickhouse-local-223-1603464945-5194555242134056268
2020.10.23 14:55:45.392250 [ 223 ] {} <Debug> Application: Loading metadata from /clickhouse-local-223-1603464945-5194555242134056268/
2020.10.23 14:55:45.420139 [ 223 ] {} <Information> DatabaseAtomic (system): Total 0 tables and 0 dictionaries.
2020.10.23 14:55:45.420166 [ 223 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2020.10.23 14:55:45.421046 [ 223 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 16 threads
2020.10.23 14:55:45.422479 [ 223 ] {} <Debug> Application: Loaded metadata.
2020.10.23 14:55:45.422692 [ 223 ] {} <Trace> ContextAccess (default): Settings: readonly=0, allow_ddl=true, allow_introspection_functions=false
2020.10.23 14:55:45.422717 [ 223 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, TRUNCATE, OPTIMIZE, KILL QUERY, SYSTEM, dictGet, SOURCES ON *.*
2020.10.23 14:55:45.422882 [ 223 ] {a5fb7054-15f3-4b95-9775-90174ae1a086} <Debug> executeQuery: (from 0.0.0.0:0) SELECT 1
2020.10.23 14:55:45.423244 [ 223 ] {a5fb7054-15f3-4b95-9775-90174ae1a086} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2020.10.23 14:55:45.423335 [ 223 ] {a5fb7054-15f3-4b95-9775-90174ae1a086} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
1
2020.10.23 14:55:45.423644 [ 223 ] {a5fb7054-15f3-4b95-9775-90174ae1a086} <Information> executeQuery: Read 1 rows, 1.00 B in 0.000717001 sec., 1394 rows/sec., 1.36 KiB/sec.
2020.10.23 14:55:45.423681 [ 223 ] {a5fb7054-15f3-4b95-9775-90174ae1a086} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B.
2020.10.23 14:55:45.423984 [ 223 ] {} <Trace> BackgroundSchedulePool/BgSchPool: Waiting for threads to finish.
2020.10.23 14:55:45.424182 [ 223 ] {} <Debug> Application: Removing temporary directory: /clickhouse-local-223-1603464945-5194555242134056268
2020.10.23 14:55:45.424556 [ 223 ] {} <Debug> Application: Uninitializing subsystem: Logging Subsystem