ClickHouse http错误代码与查询日志

这篇具有很好参考价值的文章主要介绍了ClickHouse http错误代码与查询日志。希望对大家有所帮助。如果存在错误或未考虑完全的地方,请大家不吝赐教,您也可以点击"举报违法"按钮提交疑问。

本文介绍如何获取所有ClickHouse http查询错误代码,通过对比错误代码更好理解HTTP请求的响应头信息。另外ClickHouse会在系统表中保留所有查询日志,如何保留查询相对平衡,避免日志过大占用大量磁盘空间。

ClickHouse错误代码

当通过HTTP协议查询ClickHouse接口时,在错误响应头中会有错误编码,特别要注意 X-ClickHouse-Exception-Code字段,但有时我们需要理解错误编码对应的含义。通过下面语句可以查看所有可能的错误代码,基于这些代码,可以快速了解错误原因。

SELECT concat('\t', name, ' = ', toString(number))
FROM
(
    SELECT
        number,
        errorCodeToName(number) AS name
    FROM system.numbers
    LIMIT 2000
)
WHERE NOT empty(errorCodeToName(number))

Query id: 1fa5b4fa-4baf-4aa6-b2f3-ba7780010168

┌─concat('\t', name, ' = ', toString(number))────────────────────┐
│       OK = 0                                                   │
│       UNSUPPORTED_METHOD = 1                                   │
│       UNSUPPORTED_PARAMETER = 2                                │
│       UNEXPECTED_END_OF_FILE = 3                               │
│       EXPECTED_END_OF_FILE = 4                                 │
│       CANNOT_PARSE_TEXT = 6                                    │
│       INCORRECT_NUMBER_OF_COLUMNS = 7                          │
│       THERE_IS_NO_COLUMN = 8                                   │
│       SIZES_OF_COLUMNS_DOESNT_MATCH = 9                        │
│       NOT_FOUND_COLUMN_IN_BLOCK = 10                           │
│       POSITION_OUT_OF_BOUND = 11                               │
│       PARAMETER_OUT_OF_BOUND = 12                              │
│       SIZES_OF_COLUMNS_IN_TUPLE_DOESNT_MATCH = 13              │
│       DUPLICATE_COLUMN = 15                                    │
│       NO_SUCH_COLUMN_IN_TABLE = 16                             │
│       DELIMITER_IN_STRING_LITERAL_DOESNT_MATCH = 17            │
│       CANNOT_INSERT_ELEMENT_INTO_CONSTANT_COLUMN = 18          │
│       SIZE_OF_FIXED_STRING_DOESNT_MATCH = 19                   │
│       NUMBER_OF_COLUMNS_DOESNT_MATCH = 20                      │
│       CANNOT_READ_ALL_DATA_FROM_TAB_SEPARATED_INPUT = 21       │
│       CANNOT_PARSE_ALL_VALUE_FROM_TAB_SEPARATED_INPUT = 22     │
│       CANNOT_READ_FROM_ISTREAM = 23                            │
│       CANNOT_WRITE_TO_OSTREAM = 24                             │
│       CANNOT_PARSE_ESCAPE_SEQUENCE = 25                        │
│       CANNOT_PARSE_QUOTED_STRING = 26                          │
│       CANNOT_PARSE_INPUT_ASSERTION_FAILED = 27                 │
│       CANNOT_PRINT_FLOAT_OR_DOUBLE_NUMBER = 28                 │
│       CANNOT_PRINT_INTEGER = 29                                │
│       CANNOT_READ_SIZE_OF_COMPRESSED_CHUNK = 30                │
│       CANNOT_READ_COMPRESSED_CHUNK = 31                        │
│       ATTEMPT_TO_READ_AFTER_EOF = 32                           │
│       CANNOT_READ_ALL_DATA = 33                                │
│       TOO_MANY_ARGUMENTS_FOR_FUNCTION = 34                     │
│       TOO_FEW_ARGUMENTS_FOR_FUNCTION = 35                      │
│       BAD_ARGUMENTS = 36                                       │
│       UNKNOWN_ELEMENT_IN_AST = 37                              │
│       CANNOT_PARSE_DATE = 38                                   │
│       TOO_LARGE_SIZE_COMPRESSED = 39                           │
│       CHECKSUM_DOESNT_MATCH = 40                               │
│       CANNOT_PARSE_DATETIME = 41                               │
│       NUMBER_OF_ARGUMENTS_DOESNT_MATCH = 42                    │
│       ILLEGAL_TYPE_OF_ARGUMENT = 43                            │
│       ILLEGAL_COLUMN = 44                                      │
│       ILLEGAL_NUMBER_OF_RESULT_COLUMNS = 45                    │
│       UNKNOWN_FUNCTION = 46                                    │
│       UNKNOWN_IDENTIFIER = 47                                  │
│       NOT_IMPLEMENTED = 48                                     │
│       LOGICAL_ERROR = 49                                       │
│       UNKNOWN_TYPE = 50                                        │
│       EMPTY_LIST_OF_COLUMNS_QUERIED = 51                       │
│       COLUMN_QUERIED_MORE_THAN_ONCE = 52                       │
│       TYPE_MISMATCH = 53                                       │
│       STORAGE_DOESNT_ALLOW_PARAMETERS = 54                     │
│       STORAGE_REQUIRES_PARAMETER = 55                          │
│       UNKNOWN_STORAGE = 56                                     │
│       TABLE_ALREADY_EXISTS = 57                                │
│       TABLE_METADATA_ALREADY_EXISTS = 58                       │
│       ILLEGAL_TYPE_OF_COLUMN_FOR_FILTER = 59                   │
│       UNKNOWN_TABLE = 60                                       │
│       ONLY_FILTER_COLUMN_IN_BLOCK = 61                         │
│       SYNTAX_ERROR = 62                                        │
│       UNKNOWN_AGGREGATE_FUNCTION = 63                          │
│       CANNOT_READ_AGGREGATE_FUNCTION_FROM_TEXT = 64            │
│       CANNOT_WRITE_AGGREGATE_FUNCTION_AS_TEXT = 65             │
│       NOT_A_COLUMN = 66                                        │
│       ILLEGAL_KEY_OF_AGGREGATION = 67                          │
│       CANNOT_GET_SIZE_OF_FIELD = 68                            │
│       ARGUMENT_OUT_OF_BOUND = 69                               │
│       CANNOT_CONVERT_TYPE = 70                                 │
│       CANNOT_WRITE_AFTER_END_OF_BUFFER = 71                    │
│       CANNOT_PARSE_NUMBER = 72                                 │
│       UNKNOWN_FORMAT = 73                                      │
│       CANNOT_READ_FROM_FILE_DESCRIPTOR = 74                    │
│       CANNOT_WRITE_TO_FILE_DESCRIPTOR = 75                     │
│       CANNOT_OPEN_FILE = 76                                    │
│       CANNOT_CLOSE_FILE = 77                                   │
│       UNKNOWN_TYPE_OF_QUERY = 78                               │
│       INCORRECT_FILE_NAME = 79                                 │
│       INCORRECT_QUERY = 80                                     │
│       UNKNOWN_DATABASE = 81                                    │
│       DATABASE_ALREADY_EXISTS = 82                             │
│       DIRECTORY_DOESNT_EXIST = 83                              │
│       DIRECTORY_ALREADY_EXISTS = 84                            │
│       FORMAT_IS_NOT_SUITABLE_FOR_INPUT = 85                    │
│       RECEIVED_ERROR_FROM_REMOTE_IO_SERVER = 86                │
│       CANNOT_SEEK_THROUGH_FILE = 87                            │
│       CANNOT_TRUNCATE_FILE = 88                                │
│       UNKNOWN_COMPRESSION_METHOD = 89                          │
│       EMPTY_LIST_OF_COLUMNS_PASSED = 90                        │
│       SIZES_OF_MARKS_FILES_ARE_INCONSISTENT = 91               │
│       EMPTY_DATA_PASSED = 92                                   │
│       UNKNOWN_AGGREGATED_DATA_VARIANT = 93                     │
│       CANNOT_MERGE_DIFFERENT_AGGREGATED_DATA_VARIANTS = 94     │
│       CANNOT_READ_FROM_SOCKET = 95                             │
│       CANNOT_WRITE_TO_SOCKET = 96                              │
│       CANNOT_READ_ALL_DATA_FROM_CHUNKED_INPUT = 97             │
│       CANNOT_WRITE_TO_EMPTY_BLOCK_OUTPUT_STREAM = 98           │
│       UNKNOWN_PACKET_FROM_CLIENT = 99                          │
│       UNKNOWN_PACKET_FROM_SERVER = 100                         │
│       UNEXPECTED_PACKET_FROM_CLIENT = 101                      │
│       UNEXPECTED_PACKET_FROM_SERVER = 102                      │
│       RECEIVED_DATA_FOR_WRONG_QUERY_ID = 103                   │
│       TOO_SMALL_BUFFER_SIZE = 104                              │
│       CANNOT_READ_HISTORY = 105                                │
│       CANNOT_APPEND_HISTORY = 106                              │
│       FILE_DOESNT_EXIST = 107                                  │
│       NO_DATA_TO_INSERT = 108                                  │
│       CANNOT_BLOCK_SIGNAL = 109                                │
│       CANNOT_UNBLOCK_SIGNAL = 110                              │
│       CANNOT_MANIPULATE_SIGSET = 111                           │
│       CANNOT_WAIT_FOR_SIGNAL = 112                             │
│       THERE_IS_NO_SESSION = 113                                │
│       CANNOT_CLOCK_GETTIME = 114                               │
│       UNKNOWN_SETTING = 115                                    │
│       THERE_IS_NO_DEFAULT_VALUE = 116                          │
│       INCORRECT_DATA = 117                                     │
│       ENGINE_REQUIRED = 119                                    │
│       CANNOT_INSERT_VALUE_OF_DIFFERENT_SIZE_INTO_TUPLE = 120   │
│       UNSUPPORTED_JOIN_KEYS = 121                              │
│       INCOMPATIBLE_COLUMNS = 122                               │
│       UNKNOWN_TYPE_OF_AST_NODE = 123                           │
│       INCORRECT_ELEMENT_OF_SET = 124                           │
│       INCORRECT_RESULT_OF_SCALAR_SUBQUERY = 125                │
│       CANNOT_GET_RETURN_TYPE = 126                             │
│       ILLEGAL_INDEX = 127                                      │
│       TOO_LARGE_ARRAY_SIZE = 128                               │
│       FUNCTION_IS_SPECIAL = 129                                │
│       CANNOT_READ_ARRAY_FROM_TEXT = 130                        │
│       TOO_LARGE_STRING_SIZE = 131                              │
│       AGGREGATE_FUNCTION_DOESNT_ALLOW_PARAMETERS = 133         │
│       PARAMETERS_TO_AGGREGATE_FUNCTIONS_MUST_BE_LITERALS = 134 │
│       ZERO_ARRAY_OR_TUPLE_INDEX = 135                          │
│       UNKNOWN_ELEMENT_IN_CONFIG = 137                          │
│       EXCESSIVE_ELEMENT_IN_CONFIG = 138                        │
│       NO_ELEMENTS_IN_CONFIG = 139                              │
│       ALL_REQUESTED_COLUMNS_ARE_MISSING = 140                  │
│       SAMPLING_NOT_SUPPORTED = 141                             │
│       NOT_FOUND_NODE = 142                                     │
│       FOUND_MORE_THAN_ONE_NODE = 143                           │
│       FIRST_DATE_IS_BIGGER_THAN_LAST_DATE = 144                │
│       UNKNOWN_OVERFLOW_MODE = 145                              │
│       QUERY_SECTION_DOESNT_MAKE_SENSE = 146                    │
│       NOT_FOUND_FUNCTION_ELEMENT_FOR_AGGREGATE = 147           │
│       NOT_FOUND_RELATION_ELEMENT_FOR_CONDITION = 148           │
│       NOT_FOUND_RHS_ELEMENT_FOR_CONDITION = 149                │
│       EMPTY_LIST_OF_ATTRIBUTES_PASSED = 150                    │
│       INDEX_OF_COLUMN_IN_SORT_CLAUSE_IS_OUT_OF_RANGE = 151     │
│       UNKNOWN_DIRECTION_OF_SORTING = 152                       │
│       ILLEGAL_DIVISION = 153                                   │
│       AGGREGATE_FUNCTION_NOT_APPLICABLE = 154                  │
│       UNKNOWN_RELATION = 155                                   │
│       DICTIONARIES_WAS_NOT_LOADED = 156                        │
│       ILLEGAL_OVERFLOW_MODE = 157                              │
│       TOO_MANY_ROWS = 158                                      │
│       TIMEOUT_EXCEEDED = 159                                   │
│       TOO_SLOW = 160                                           │
│       TOO_MANY_COLUMNS = 161                                   │
│       TOO_DEEP_SUBQUERIES = 162                                │
│       TOO_DEEP_PIPELINE = 163                                  │
│       READONLY = 164                                           │
│       TOO_MANY_TEMPORARY_COLUMNS = 165                         │
│       TOO_MANY_TEMPORARY_NON_CONST_COLUMNS = 166               │
│       TOO_DEEP_AST = 167                                       │
│       TOO_BIG_AST = 168                                        │
│       BAD_TYPE_OF_FIELD = 169                                  │
│       BAD_GET = 170                                            │
│       CANNOT_CREATE_DIRECTORY = 172                            │
│       CANNOT_ALLOCATE_MEMORY = 173                             │
│       CYCLIC_ALIASES = 174                                     │
│       CHUNK_NOT_FOUND = 176                                    │
│       DUPLICATE_CHUNK_NAME = 177                               │
│       MULTIPLE_ALIASES_FOR_EXPRESSION = 178                    │
│       MULTIPLE_EXPRESSIONS_FOR_ALIAS = 179                     │
│       THERE_IS_NO_PROFILE = 180                                │
│       ILLEGAL_FINAL = 181                                      │
│       ILLEGAL_PREWHERE = 182                                   │
│       UNEXPECTED_EXPRESSION = 183                              │
│       ILLEGAL_AGGREGATION = 184                                │
│       UNSUPPORTED_MYISAM_BLOCK_TYPE = 185                      │
│       UNSUPPORTED_COLLATION_LOCALE = 186                       │
│       COLLATION_COMPARISON_FAILED = 187                        │
│       UNKNOWN_ACTION = 188                                     │
│       TABLE_MUST_NOT_BE_CREATED_MANUALLY = 189                 │
│       SIZES_OF_ARRAYS_DONT_MATCH = 190                         │
│       SET_SIZE_LIMIT_EXCEEDED = 191                            │
│       UNKNOWN_USER = 192                                       │
│       WRONG_PASSWORD = 193                                     │
│       REQUIRED_PASSWORD = 194                                  │
│       IP_ADDRESS_NOT_ALLOWED = 195                             │
│       UNKNOWN_ADDRESS_PATTERN_TYPE = 196                       │
│       SERVER_REVISION_IS_TOO_OLD = 197                         │
│       DNS_ERROR = 198                                          │
│       UNKNOWN_QUOTA = 199                                      │
│       QUOTA_DOESNT_ALLOW_KEYS = 200                            │
│       QUOTA_EXCEEDED = 201                                     │
│       TOO_MANY_SIMULTANEOUS_QUERIES = 202                      │
│       NO_FREE_CONNECTION = 203                                 │
│       CANNOT_FSYNC = 204                                       │
│       NESTED_TYPE_TOO_DEEP = 205                               │
│       ALIAS_REQUIRED = 206                                     │
│       AMBIGUOUS_IDENTIFIER = 207                               │
│       EMPTY_NESTED_TABLE = 208                                 │
│       SOCKET_TIMEOUT = 209                                     │
│       NETWORK_ERROR = 210                                      │
│       EMPTY_QUERY = 211                                        │
│       UNKNOWN_LOAD_BALANCING = 212                             │
│       UNKNOWN_TOTALS_MODE = 213                                │
│       CANNOT_STATVFS = 214                                     │
│       NOT_AN_AGGREGATE = 215                                   │
│       QUERY_WITH_SAME_ID_IS_ALREADY_RUNNING = 216              │
│       CLIENT_HAS_CONNECTED_TO_WRONG_PORT = 217                 │
│       TABLE_IS_DROPPED = 218                                   │
│       DATABASE_NOT_EMPTY = 219                                 │
│       DUPLICATE_INTERSERVER_IO_ENDPOINT = 220                  │
│       NO_SUCH_INTERSERVER_IO_ENDPOINT = 221                    │
│       ADDING_REPLICA_TO_NON_EMPTY_TABLE = 222                  │
│       UNEXPECTED_AST_STRUCTURE = 223                           │
│       REPLICA_IS_ALREADY_ACTIVE = 224                          │
│       NO_ZOOKEEPER = 225                                       │
│       NO_FILE_IN_DATA_PART = 226                               │
│       UNEXPECTED_FILE_IN_DATA_PART = 227                       │
│       BAD_SIZE_OF_FILE_IN_DATA_PART = 228                      │
│       QUERY_IS_TOO_LARGE = 229                                 │
│       NOT_FOUND_EXPECTED_DATA_PART = 230                       │
│       TOO_MANY_UNEXPECTED_DATA_PARTS = 231                     │
│       NO_SUCH_DATA_PART = 232                                  │
│       BAD_DATA_PART_NAME = 233                                 │
│       NO_REPLICA_HAS_PART = 234                                │
│       DUPLICATE_DATA_PART = 235                                │
│       ABORTED = 236                                            │
│       NO_REPLICA_NAME_GIVEN = 237                              │
│       FORMAT_VERSION_TOO_OLD = 238                             │
│       CANNOT_MUNMAP = 239                                      │
│       CANNOT_MREMAP = 240                                      │
│       MEMORY_LIMIT_EXCEEDED = 241                              │
│       TABLE_IS_READ_ONLY = 242                                 │
│       NOT_ENOUGH_SPACE = 243                                   │
│       UNEXPECTED_ZOOKEEPER_ERROR = 244                         │
│       CORRUPTED_DATA = 246                                     │
│       INCORRECT_MARK = 247                                     │
│       INVALID_PARTITION_VALUE = 248                            │
│       NOT_ENOUGH_BLOCK_NUMBERS = 250                           │
│       NO_SUCH_REPLICA = 251                                    │
│       TOO_MANY_PARTS = 252                                     │
│       REPLICA_ALREADY_EXISTS = 253                             │
│       NO_ACTIVE_REPLICAS = 254                                 │
│       TOO_MANY_RETRIES_TO_FETCH_PARTS = 255                    │
│       PARTITION_ALREADY_EXISTS = 256                           │
│       PARTITION_DOESNT_EXIST = 257                             │
│       UNION_ALL_RESULT_STRUCTURES_MISMATCH = 258               │
│       CLIENT_OUTPUT_FORMAT_SPECIFIED = 260                     │
│       UNKNOWN_BLOCK_INFO_FIELD = 261                           │
│       BAD_COLLATION = 262                                      │
│       CANNOT_COMPILE_CODE = 263                                │
│       INCOMPATIBLE_TYPE_OF_JOIN = 264                          │
│       NO_AVAILABLE_REPLICA = 265                               │
│       MISMATCH_REPLICAS_DATA_SOURCES = 266                     │
│       STORAGE_DOESNT_SUPPORT_PARALLEL_REPLICAS = 267           │
│       CPUID_ERROR = 268                                        │
│       INFINITE_LOOP = 269                                      │
│       CANNOT_COMPRESS = 270                                    │
│       CANNOT_DECOMPRESS = 271                                  │
│       CANNOT_IO_SUBMIT = 272                                   │
│       CANNOT_IO_GETEVENTS = 273                                │
│       AIO_READ_ERROR = 274                                     │
│       AIO_WRITE_ERROR = 275                                    │
│       INDEX_NOT_USED = 277                                     │
│       ALL_CONNECTION_TRIES_FAILED = 279                        │
│       NO_AVAILABLE_DATA = 280                                  │
│       DICTIONARY_IS_EMPTY = 281                                │
│       INCORRECT_INDEX = 282                                    │
│       UNKNOWN_DISTRIBUTED_PRODUCT_MODE = 283                   │
│       WRONG_GLOBAL_SUBQUERY = 284                              │
│       TOO_FEW_LIVE_REPLICAS = 285                              │
│       UNSATISFIED_QUORUM_FOR_PREVIOUS_WRITE = 286              │
│       UNKNOWN_FORMAT_VERSION = 287                             │
│       DISTRIBUTED_IN_JOIN_SUBQUERY_DENIED = 288                │
│       REPLICA_IS_NOT_IN_QUORUM = 289                           │
│       LIMIT_EXCEEDED = 290                                     │
│       DATABASE_ACCESS_DENIED = 291                             │
│       MONGODB_CANNOT_AUTHENTICATE = 293                        │
│       INVALID_BLOCK_EXTRA_INFO = 294                           │
│       RECEIVED_EMPTY_DATA = 295                                │
│       NO_REMOTE_SHARD_FOUND = 296                              │
│       SHARD_HAS_NO_CONNECTIONS = 297                           │
│       CANNOT_PIPE = 298                                        │
│       CANNOT_FORK = 299                                        │
│       CANNOT_DLSYM = 300                                       │
│       CANNOT_CREATE_CHILD_PROCESS = 301                        │
│       CHILD_WAS_NOT_EXITED_NORMALLY = 302                      │
│       CANNOT_SELECT = 303                                      │
│       CANNOT_WAITPID = 304                                     │
│       TABLE_WAS_NOT_DROPPED = 305                              │
│       TOO_DEEP_RECURSION = 306                                 │
│       TOO_MANY_BYTES = 307                                     │
│       UNEXPECTED_NODE_IN_ZOOKEEPER = 308                       │
│       FUNCTION_CANNOT_HAVE_PARAMETERS = 309                    │
│       INVALID_SHARD_WEIGHT = 317                               │
│       INVALID_CONFIG_PARAMETER = 318                           │
│       UNKNOWN_STATUS_OF_INSERT = 319                           │
│       VALUE_IS_OUT_OF_RANGE_OF_DATA_TYPE = 321                 │
│       BARRIER_TIMEOUT = 335                                    │
│       UNKNOWN_DATABASE_ENGINE = 336                            │
│       DDL_GUARD_IS_ACTIVE = 337                                │
│       UNFINISHED = 341                                         │
│       METADATA_MISMATCH = 342                                  │
│       SUPPORT_IS_DISABLED = 344                                │
│       TABLE_DIFFERS_TOO_MUCH = 345                             │
│       CANNOT_CONVERT_CHARSET = 346                             │
│       CANNOT_LOAD_CONFIG = 347                                 │
│       CANNOT_INSERT_NULL_IN_ORDINARY_COLUMN = 349              │
│       INCOMPATIBLE_SOURCE_TABLES = 350                         │
│       AMBIGUOUS_TABLE_NAME = 351                               │
│       AMBIGUOUS_COLUMN_NAME = 352                              │
│       INDEX_OF_POSITIONAL_ARGUMENT_IS_OUT_OF_RANGE = 353       │
│       ZLIB_INFLATE_FAILED = 354                                │
│       ZLIB_DEFLATE_FAILED = 355                                │
│       BAD_LAMBDA = 356                                         │
│       RESERVED_IDENTIFIER_NAME = 357                           │
│       INTO_OUTFILE_NOT_ALLOWED = 358                           │
│       TABLE_SIZE_EXCEEDS_MAX_DROP_SIZE_LIMIT = 359             │
│       CANNOT_CREATE_CHARSET_CONVERTER = 360                    │
│       SEEK_POSITION_OUT_OF_BOUND = 361                         │
│       CURRENT_WRITE_BUFFER_IS_EXHAUSTED = 362                  │
│       CANNOT_CREATE_IO_BUFFER = 363                            │
│       RECEIVED_ERROR_TOO_MANY_REQUESTS = 364                   │
│       SIZES_OF_NESTED_COLUMNS_ARE_INCONSISTENT = 366           │
│       TOO_MANY_FETCHES = 367                                   │
│       ALL_REPLICAS_ARE_STALE = 369                             │
│       DATA_TYPE_CANNOT_BE_USED_IN_TABLES = 370                 │
│       INCONSISTENT_CLUSTER_DEFINITION = 371                    │
│       SESSION_NOT_FOUND = 372                                  │
│       SESSION_IS_LOCKED = 373                                  │
│       INVALID_SESSION_TIMEOUT = 374                            │
│       CANNOT_DLOPEN = 375                                      │
│       CANNOT_PARSE_UUID = 376                                  │
│       ILLEGAL_SYNTAX_FOR_DATA_TYPE = 377                       │
│       DATA_TYPE_CANNOT_HAVE_ARGUMENTS = 378                    │
│       UNKNOWN_STATUS_OF_DISTRIBUTED_DDL_TASK = 379             │
│       CANNOT_KILL = 380                                        │
│       HTTP_LENGTH_REQUIRED = 381                               │
│       CANNOT_LOAD_CATBOOST_MODEL = 382                         │
│       CANNOT_APPLY_CATBOOST_MODEL = 383                        │
│       PART_IS_TEMPORARILY_LOCKED = 384                         │
│       MULTIPLE_STREAMS_REQUIRED = 385                          │
│       NO_COMMON_TYPE = 386                                     │
│       DICTIONARY_ALREADY_EXISTS = 387                          │
│       CANNOT_ASSIGN_OPTIMIZE = 388                             │
│       INSERT_WAS_DEDUPLICATED = 389                            │
│       CANNOT_GET_CREATE_TABLE_QUERY = 390                      │
│       EXTERNAL_LIBRARY_ERROR = 391                             │
│       QUERY_IS_PROHIBITED = 392                                │
│       THERE_IS_NO_QUERY = 393                                  │
│       QUERY_WAS_CANCELLED = 394                                │
│       FUNCTION_THROW_IF_VALUE_IS_NON_ZERO = 395                │
│       TOO_MANY_ROWS_OR_BYTES = 396                             │
│       QUERY_IS_NOT_SUPPORTED_IN_MATERIALIZED_VIEW = 397        │
│       UNKNOWN_MUTATION_COMMAND = 398                           │
│       FORMAT_IS_NOT_SUITABLE_FOR_OUTPUT = 399                  │
│       CANNOT_STAT = 400                                        │
│       FEATURE_IS_NOT_ENABLED_AT_BUILD_TIME = 401               │
│       CANNOT_IOSETUP = 402                                     │
│       INVALID_JOIN_ON_EXPRESSION = 403                         │
│       BAD_ODBC_CONNECTION_STRING = 404                         │
│       PARTITION_SIZE_EXCEEDS_MAX_DROP_SIZE_LIMIT = 405         │
│       TOP_AND_LIMIT_TOGETHER = 406                             │
│       DECIMAL_OVERFLOW = 407                                   │
│       BAD_REQUEST_PARAMETER = 408                              │
│       EXTERNAL_EXECUTABLE_NOT_FOUND = 409                      │
│       EXTERNAL_SERVER_IS_NOT_RESPONDING = 410                  │
│       PTHREAD_ERROR = 411                                      │
│       NETLINK_ERROR = 412                                      │
│       CANNOT_SET_SIGNAL_HANDLER = 413                          │
│       ALL_REPLICAS_LOST = 415                                  │
│       REPLICA_STATUS_CHANGED = 416                             │
│       EXPECTED_ALL_OR_ANY = 417                                │
│       UNKNOWN_JOIN = 418                                       │
│       MULTIPLE_ASSIGNMENTS_TO_COLUMN = 419                     │
│       CANNOT_UPDATE_COLUMN = 420                               │
│       CANNOT_ADD_DIFFERENT_AGGREGATE_STATES = 421              │
│       UNSUPPORTED_URI_SCHEME = 422                             │
│       CANNOT_GETTIMEOFDAY = 423                                │
│       CANNOT_LINK = 424                                        │
│       SYSTEM_ERROR = 425                                       │
│       CANNOT_COMPILE_REGEXP = 427                              │
│       UNKNOWN_LOG_LEVEL = 428                                  │
│       FAILED_TO_GETPWUID = 429                                 │
│       MISMATCHING_USERS_FOR_PROCESS_AND_DATA = 430             │
│       ILLEGAL_SYNTAX_FOR_CODEC_TYPE = 431                      │
│       UNKNOWN_CODEC = 432                                      │
│       ILLEGAL_CODEC_PARAMETER = 433                            │
│       CANNOT_PARSE_PROTOBUF_SCHEMA = 434                       │
│       NO_COLUMN_SERIALIZED_TO_REQUIRED_PROTOBUF_FIELD = 435    │
│       PROTOBUF_BAD_CAST = 436                                  │
│       PROTOBUF_FIELD_NOT_REPEATED = 437                        │
│       DATA_TYPE_CANNOT_BE_PROMOTED = 438                       │
│       CANNOT_SCHEDULE_TASK = 439                               │
│       INVALID_LIMIT_EXPRESSION = 440                           │
│       CANNOT_PARSE_DOMAIN_VALUE_FROM_STRING = 441              │
│       BAD_DATABASE_FOR_TEMPORARY_TABLE = 442                   │
│       NO_COLUMNS_SERIALIZED_TO_PROTOBUF_FIELDS = 443           │
│       UNKNOWN_PROTOBUF_FORMAT = 444                            │
│       CANNOT_MPROTECT = 445                                    │
│       FUNCTION_NOT_ALLOWED = 446                               │
│       HYPERSCAN_CANNOT_SCAN_TEXT = 447                         │
│       BROTLI_READ_FAILED = 448                                 │
│       BROTLI_WRITE_FAILED = 449                                │
│       BAD_TTL_EXPRESSION = 450                                 │
│       BAD_TTL_FILE = 451                                       │
│       SETTING_CONSTRAINT_VIOLATION = 452                       │
│       MYSQL_CLIENT_INSUFFICIENT_CAPABILITIES = 453             │
│       OPENSSL_ERROR = 454                                      │
│       SUSPICIOUS_TYPE_FOR_LOW_CARDINALITY = 455                │
│       UNKNOWN_QUERY_PARAMETER = 456                            │
│       BAD_QUERY_PARAMETER = 457                                │
│       CANNOT_UNLINK = 458                                      │
│       CANNOT_SET_THREAD_PRIORITY = 459                         │
│       CANNOT_CREATE_TIMER = 460                                │
│       CANNOT_SET_TIMER_PERIOD = 461                            │
│       CANNOT_DELETE_TIMER = 462                                │
│       CANNOT_FCNTL = 463                                       │
│       CANNOT_PARSE_ELF = 464                                   │
│       CANNOT_PARSE_DWARF = 465                                 │
│       INSECURE_PATH = 466                                      │
│       CANNOT_PARSE_BOOL = 467                                  │
│       CANNOT_PTHREAD_ATTR = 468                                │
│       VIOLATED_CONSTRAINT = 469                                │
│       QUERY_IS_NOT_SUPPORTED_IN_LIVE_VIEW = 470                │
│       INVALID_SETTING_VALUE = 471                              │
│       READONLY_SETTING = 472                                   │
│       DEADLOCK_AVOIDED = 473                                   │
│       INVALID_TEMPLATE_FORMAT = 474                            │
│       INVALID_WITH_FILL_EXPRESSION = 475                       │
│       WITH_TIES_WITHOUT_ORDER_BY = 476                         │
│       INVALID_USAGE_OF_INPUT = 477                             │
│       UNKNOWN_POLICY = 478                                     │
│       UNKNOWN_DISK = 479                                       │
│       UNKNOWN_PROTOCOL = 480                                   │
│       PATH_ACCESS_DENIED = 481                                 │
│       DICTIONARY_ACCESS_DENIED = 482                           │
│       TOO_MANY_REDIRECTS = 483                                 │
│       INTERNAL_REDIS_ERROR = 484                               │
│       SCALAR_ALREADY_EXISTS = 485                              │
│       CANNOT_GET_CREATE_DICTIONARY_QUERY = 487                 │
│       UNKNOWN_DICTIONARY = 488                                 │
│       INCORRECT_DICTIONARY_DEFINITION = 489                    │
│       CANNOT_FORMAT_DATETIME = 490                             │
│       UNACCEPTABLE_URL = 491                                   │
│       ACCESS_ENTITY_NOT_FOUND = 492                            │
│       ACCESS_ENTITY_ALREADY_EXISTS = 493                       │
│       ACCESS_ENTITY_FOUND_DUPLICATES = 494                     │
│       ACCESS_STORAGE_READONLY = 495                            │
│       QUOTA_REQUIRES_CLIENT_KEY = 496                          │
│       ACCESS_DENIED = 497                                      │
│       LIMIT_BY_WITH_TIES_IS_NOT_SUPPORTED = 498                │
│       S3_ERROR = 499                                           │
│       AZURE_BLOB_STORAGE_ERROR = 500                           │
│       CANNOT_CREATE_DATABASE = 501                             │
│       CANNOT_SIGQUEUE = 502                                    │
│       AGGREGATE_FUNCTION_THROW = 503                           │
│       FILE_ALREADY_EXISTS = 504                                │
│       CANNOT_DELETE_DIRECTORY = 505                            │
│       UNEXPECTED_ERROR_CODE = 506                              │
│       UNABLE_TO_SKIP_UNUSED_SHARDS = 507                       │
│       UNKNOWN_ACCESS_TYPE = 508                                │
│       INVALID_GRANT = 509                                      │
│       CACHE_DICTIONARY_UPDATE_FAIL = 510                       │
│       UNKNOWN_ROLE = 511                                       │
│       SET_NON_GRANTED_ROLE = 512                               │
│       UNKNOWN_PART_TYPE = 513                                  │
│       ACCESS_STORAGE_FOR_INSERTION_NOT_FOUND = 514             │
│       INCORRECT_ACCESS_ENTITY_DEFINITION = 515                 │
│       AUTHENTICATION_FAILED = 516                              │
│       CANNOT_ASSIGN_ALTER = 517                                │
│       CANNOT_COMMIT_OFFSET = 518                               │
│       NO_REMOTE_SHARD_AVAILABLE = 519                          │
│       CANNOT_DETACH_DICTIONARY_AS_TABLE = 520                  │
│       ATOMIC_RENAME_FAIL = 521                                 │
│       UNKNOWN_ROW_POLICY = 523                                 │
│       ALTER_OF_COLUMN_IS_FORBIDDEN = 524                       │
│       INCORRECT_DISK_INDEX = 525                               │
│       NO_SUITABLE_FUNCTION_IMPLEMENTATION = 527                │
│       CASSANDRA_INTERNAL_ERROR = 528                           │
│       NOT_A_LEADER = 529                                       │
│       CANNOT_CONNECT_RABBITMQ = 530                            │
│       CANNOT_FSTAT = 531                                       │
│       LDAP_ERROR = 532                                         │
│       INCONSISTENT_RESERVATIONS = 533                          │
│       NO_RESERVATIONS_PROVIDED = 534                           │
│       UNKNOWN_RAID_TYPE = 535                                  │
│       CANNOT_RESTORE_FROM_FIELD_DUMP = 536                     │
│       ILLEGAL_MYSQL_VARIABLE = 537                             │
│       MYSQL_SYNTAX_ERROR = 538                                 │
│       CANNOT_BIND_RABBITMQ_EXCHANGE = 539                      │
│       CANNOT_DECLARE_RABBITMQ_EXCHANGE = 540                   │
│       CANNOT_CREATE_RABBITMQ_QUEUE_BINDING = 541               │
│       CANNOT_REMOVE_RABBITMQ_EXCHANGE = 542                    │
│       UNKNOWN_MYSQL_DATATYPES_SUPPORT_LEVEL = 543              │
│       ROW_AND_ROWS_TOGETHER = 544                              │
│       FIRST_AND_NEXT_TOGETHER = 545                            │
│       NO_ROW_DELIMITER = 546                                   │
│       INVALID_RAID_TYPE = 547                                  │
│       UNKNOWN_VOLUME = 548                                     │
│       DATA_TYPE_CANNOT_BE_USED_IN_KEY = 549                    │
│       CONDITIONAL_TREE_PARENT_NOT_FOUND = 550                  │
│       ILLEGAL_PROJECTION_MANIPULATOR = 551                     │
│       UNRECOGNIZED_ARGUMENTS = 552                             │
│       LZMA_STREAM_ENCODER_FAILED = 553                         │
│       LZMA_STREAM_DECODER_FAILED = 554                         │
│       ROCKSDB_ERROR = 555                                      │
│       SYNC_MYSQL_USER_ACCESS_ERROR = 556                       │
│       UNKNOWN_UNION = 557                                      │
│       EXPECTED_ALL_OR_DISTINCT = 558                           │
│       INVALID_GRPC_QUERY_INFO = 559                            │
│       ZSTD_ENCODER_FAILED = 560                                │
│       ZSTD_DECODER_FAILED = 561                                │
│       TLD_LIST_NOT_FOUND = 562                                 │
│       CANNOT_READ_MAP_FROM_TEXT = 563                          │
│       INTERSERVER_SCHEME_DOESNT_MATCH = 564                    │
│       TOO_MANY_PARTITIONS = 565                                │
│       CANNOT_RMDIR = 566                                       │
│       DUPLICATED_PART_UUIDS = 567                              │
│       RAFT_ERROR = 568                                         │
│       MULTIPLE_COLUMNS_SERIALIZED_TO_SAME_PROTOBUF_FIELD = 569 │
│       DATA_TYPE_INCOMPATIBLE_WITH_PROTOBUF_FIELD = 570         │
│       DATABASE_REPLICATION_FAILED = 571                        │
│       TOO_MANY_QUERY_PLAN_OPTIMIZATIONS = 572                  │
│       EPOLL_ERROR = 573                                        │
│       DISTRIBUTED_TOO_MANY_PENDING_BYTES = 574                 │
│       UNKNOWN_SNAPSHOT = 575                                   │
│       KERBEROS_ERROR = 576                                     │
│       INVALID_SHARD_ID = 577                                   │
│       INVALID_FORMAT_INSERT_QUERY_WITH_DATA = 578              │
│       INCORRECT_PART_TYPE = 579                                │
│       CANNOT_SET_ROUNDING_MODE = 580                           │
│       TOO_LARGE_DISTRIBUTED_DEPTH = 581                        │
│       NO_SUCH_PROJECTION_IN_TABLE = 582                        │
│       ILLEGAL_PROJECTION = 583                                 │
│       PROJECTION_NOT_USED = 584                                │
│       CANNOT_PARSE_YAML = 585                                  │
│       CANNOT_CREATE_FILE = 586                                 │
│       CONCURRENT_ACCESS_NOT_SUPPORTED = 587                    │
│       DISTRIBUTED_BROKEN_BATCH_INFO = 588                      │
│       DISTRIBUTED_BROKEN_BATCH_FILES = 589                     │
│       CANNOT_SYSCONF = 590                                     │
│       SQLITE_ENGINE_ERROR = 591                                │
│       DATA_ENCRYPTION_ERROR = 592                              │
│       ZERO_COPY_REPLICATION_ERROR = 593                        │
│       BZIP2_STREAM_DECODER_FAILED = 594                        │
│       BZIP2_STREAM_ENCODER_FAILED = 595                        │
│       INTERSECT_OR_EXCEPT_RESULT_STRUCTURES_MISMATCH = 596     │
│       NO_SUCH_ERROR_CODE = 597                                 │
│       BACKUP_ALREADY_EXISTS = 598                              │
│       BACKUP_NOT_FOUND = 599                                   │
│       BACKUP_VERSION_NOT_SUPPORTED = 600                       │
│       BACKUP_DAMAGED = 601                                     │
│       NO_BASE_BACKUP = 602                                     │
│       WRONG_BASE_BACKUP = 603                                  │
│       BACKUP_ENTRY_ALREADY_EXISTS = 604                        │
│       BACKUP_ENTRY_NOT_FOUND = 605                             │
│       BACKUP_IS_EMPTY = 606                                    │
│       CANNOT_RESTORE_DATABASE = 607                            │
│       CANNOT_RESTORE_TABLE = 608                               │
│       FUNCTION_ALREADY_EXISTS = 609                            │
│       CANNOT_DROP_FUNCTION = 610                               │
│       CANNOT_CREATE_RECURSIVE_FUNCTION = 611                   │
│       OBJECT_ALREADY_STORED_ON_DISK = 612                      │
│       OBJECT_WAS_NOT_STORED_ON_DISK = 613                      │
│       POSTGRESQL_CONNECTION_FAILURE = 614                      │
│       CANNOT_ADVISE = 615                                      │
│       UNKNOWN_READ_METHOD = 616                                │
│       LZ4_ENCODER_FAILED = 617                                 │
│       LZ4_DECODER_FAILED = 618                                 │
│       POSTGRESQL_REPLICATION_INTERNAL_ERROR = 619              │
│       QUERY_NOT_ALLOWED = 620                                  │
│       CANNOT_NORMALIZE_STRING = 621                            │
│       CANNOT_PARSE_CAPN_PROTO_SCHEMA = 622                     │
│       CAPN_PROTO_BAD_CAST = 623                                │
│       BAD_FILE_TYPE = 624                                      │
│       IO_SETUP_ERROR = 625                                     │
│       CANNOT_SKIP_UNKNOWN_FIELD = 626                          │
│       BACKUP_ENGINE_NOT_FOUND = 627                            │
│       OFFSET_FETCH_WITHOUT_ORDER_BY = 628                      │
│       HTTP_RANGE_NOT_SATISFIABLE = 629                         │
│       HAVE_DEPENDENT_OBJECTS = 630                             │
│       UNKNOWN_FILE_SIZE = 631                                  │
│       UNEXPECTED_DATA_AFTER_PARSED_VALUE = 632                 │
│       QUERY_IS_NOT_SUPPORTED_IN_WINDOW_VIEW = 633              │
│       MONGODB_ERROR = 634                                      │
│       CANNOT_POLL = 635                                        │
│       CANNOT_EXTRACT_TABLE_STRUCTURE = 636                     │
│       INVALID_TABLE_OVERRIDE = 637                             │
│       SNAPPY_UNCOMPRESS_FAILED = 638                           │
│       SNAPPY_COMPRESS_FAILED = 639                             │
│       NO_HIVEMETASTORE = 640                                   │
│       CANNOT_APPEND_TO_FILE = 641                              │
│       CANNOT_PACK_ARCHIVE = 642                                │
│       CANNOT_UNPACK_ARCHIVE = 643                              │
│       REMOTE_FS_OBJECT_CACHE_ERROR = 644                       │
│       NUMBER_OF_DIMENSIONS_MISMATCHED = 645                    │
│       CANNOT_BACKUP_DATABASE = 646                             │
│       CANNOT_BACKUP_TABLE = 647                                │
│       WRONG_DDL_RENAMING_SETTINGS = 648                        │
│       INVALID_TRANSACTION = 649                                │
│       SERIALIZATION_ERROR = 650                                │
│       CAPN_PROTO_BAD_TYPE = 651                                │
│       ONLY_NULLS_WHILE_READING_SCHEMA = 652                    │
│       CANNOT_PARSE_BACKUP_SETTINGS = 653                       │
│       WRONG_BACKUP_SETTINGS = 654                              │
│       FAILED_TO_SYNC_BACKUP_OR_RESTORE = 655                   │
│       MEILISEARCH_EXCEPTION = 656                              │
│       UNSUPPORTED_MEILISEARCH_TYPE = 657                       │
│       MEILISEARCH_MISSING_SOME_COLUMNS = 658                   │
│       UNKNOWN_STATUS_OF_TRANSACTION = 659                      │
│       HDFS_ERROR = 660                                         │
│       CANNOT_SEND_SIGNAL = 661                                 │
│       FS_METADATA_ERROR = 662                                  │
│       INCONSISTENT_METADATA_FOR_BACKUP = 663                   │
│       ACCESS_STORAGE_DOESNT_ALLOW_BACKUP = 664                 │
│       CANNOT_CONNECT_NATS = 665                                │
│       CANNOT_USE_CACHE = 666                                   │
│       NOT_INITIALIZED = 667                                    │
│       INVALID_STATE = 668                                      │
│       NAMED_COLLECTION_DOESNT_EXIST = 669                      │
│       NAMED_COLLECTION_ALREADY_EXISTS = 670                    │
│       NAMED_COLLECTION_IS_IMMUTABLE = 671                      │
│       INVALID_SCHEDULER_NODE = 672                             │
│       RESOURCE_ACCESS_DENIED = 673                             │
│       RESOURCE_NOT_FOUND = 674                                 │
│       CANNOT_PARSE_IPV4 = 675                                  │
│       CANNOT_PARSE_IPV6 = 676                                  │
│       THREAD_WAS_CANCELED = 677                                │
│       IO_URING_INIT_FAILED = 678                               │
│       IO_URING_SUBMIT_ERROR = 679                              │
│       MIXED_ACCESS_PARAMETER_TYPES = 690                       │
│       UNKNOWN_ELEMENT_OF_ENUM = 691                            │
│       KEEPER_EXCEPTION = 999                                   │
│       POCO_EXCEPTION = 1000                                    │
│       STD_EXCEPTION = 1001                                     │
│       UNKNOWN_EXCEPTION = 1002                                 │
└────────────────────────────────────────────────────────────────┘

http请求测试

下面通过CURL进行测试。没有对应表:

 curl --user default:passw02d -i 'http://localhost:8123?query=select+*+from+wtf'
HTTP/1.1 404 Not Found
Date: Fri, 16 Jun 2023 09:13:32 GMT
Connection: Keep-Alive
Content-Type: text/plain; charset=UTF-8
X-ClickHouse-Server-Display-Name: localhost
Transfer-Encoding: chunked
X-ClickHouse-Query-Id: a6eafbf4-3d0d-44a3-a762-df427759efb3
X-ClickHouse-Timezone: Asia/Shanghai
X-ClickHouse-Exception-Code: 60
Keep-Alive: timeout=3
X-ClickHouse-Summary: {"read_rows":"0","read_bytes":"0","written_rows":"0","written_bytes":"0","total_rows_to_read":"0","result_rows":"0","result_bytes":"0"}


可以看到 X-ClickHouse-Exception-Code: 60,对照上面的结果,60 表示查询不到对应表。

如果不提供用户和密码,结果如下:

curl -i 'http://localhost:8123?query=select+*+from+wtf'
HTTP/1.1 403 Forbidden
Date: Fri, 16 Jun 2023 08:57:42 GMT
Connection: Keep-Alive
Content-Type: text/plain; charset=UTF-8
X-ClickHouse-Server-Display-Name: localhost
Transfer-Encoding: chunked
X-ClickHouse-Exception-Code: 516

Code: 516. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name.

If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.

. (AUTHENTICATION_FAILED) (version 23.3.2.37 (official build))

这回返回错误为:X-ClickHouse-Exception-Code: 516, 对照上节错误代码表示未授权。

设置ClickHouse查询日志TTL

ClickHouse 可以在系统表 system.query_log中显示查询日志,方便调试运行的查询。随着时间推移,特别在繁忙的集群环境,查询日志增长很快会占用大量磁盘空间。

对于这种情况可以会考虑使用MODIFY TTL对system.query_log表设置TTL,但这种方式服务器重启后TTL 设置会丢失。为了持久应用TTL之system.query_log表,必须修改 conf.xml 文件。

举例:

    <query_views_log>
        <database>system</database>
        <table>query_views_log</table>
        <partition_by>toStartOfWeek(event_date)</partition_by>
        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <ttl>toStartOfWeek(event_date) + INTERVAL 3 MONTH</ttl>
    </query_views_log>

    <query_log>
        <database>system</database>
        <table>query_log</table>
        <partition_by>toStartOfWeek(event_date)</partition_by>
        <ttl>toStartOfWeek(event_date) + INTERVAL 3 MONTH</ttl>
        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
    </query_log>

修改完成后,必须重启 ClickHouse 服务器使得配置生效。

总结

本文介绍了ClickHouse Http查询错误编码,以及如何给存储查询日志的系统表设置TTL.文章来源地址https://www.toymoban.com/news/detail-540223.html

到了这里,关于ClickHouse http错误代码与查询日志的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处: 如若内容造成侵权/违法违规/事实不符,请点击违法举报进行投诉反馈,一经查实,立即删除!

领支付宝红包 赞助服务器费用

相关文章

  • Clickhouse 以太坊分析:交易日志分析

    读者可前往我的博客获得更好的阅读体验。 在上一篇中,我们介绍了如何使用 Clickhouse 进行基础的信息提取,这些信息往往依赖于以太坊底层机制,我们只能获得如 ETH 转账、 gas 等信息,这些信息并没有涵盖以太坊中最重要的智能合约的相关数据。这使我们无法获得 ERC-20

    2024年02月04日
    浏览(46)
  • clickhouse日志表占用大量磁盘空间

    sql: SELECT sum(rows) AS 总行数 , formatReadableSize(sum(data_uncompressed_bytes)) AS 原始大小 , formatReadableSize(sum(data_compressed_bytes)) AS 压缩大小 , round((sum(data_compressed_bytes) / sum(data_uncompressed_bytes)) * 100, 0) AS 压缩率 , table AS 表名 FROM system.parts where database = ‘system’ group by table ; query_log也占用了

    2024年02月11日
    浏览(47)
  • clickhouse join查询算法

    算法对比: 使用方法: 每个算法试试测试一下性能,如果没效果,考虑一下宽表。

    2024年01月16日
    浏览(67)
  • 【个人笔记】ClickHouse 查询优化

    ClickHouse是OLAP(Online analytical processing)数据库,以速度见长。ClickHouse为什么能这么快?有两点原因: 架构优越 列式存储 索引 数据压缩 向量化执行 资源利用 关注底层细节 但是,数据库设计再优越也拯救不了错误的使用方式,本文以MergeTree引擎家族为例讲解如何对查询优化

    2024年01月17日
    浏览(50)
  • clickhouse分布式查询降级为本地查询

    在基于 clickhouse 做类数仓建模时通常的做法是在本地创建物化视图,然后使用分布式表做代理对外提供服务。我们知道 clickhouse 对于 DQL 内部实现了分布式,而对于 DDL 则需要我们自动实现比如: 来实现分布式 DDL,但对于 此类分布式表的查询会自动执行分布式查询并在查询入

    2024年02月14日
    浏览(45)
  • 利用投影提升ClickHouse查询性能

    ClickHouse中表排序键对与查询性能至关重要。本文介绍当使用非排序键作为查询条件时如何提升查询性能。通过对非排序键定义投影,然后物化排序结果,利用空间换时间策略,提升查询性能。 当创建MergeTree表时,需要指定列的顺序作为排序键。排序键的顺序对查询性能影响

    2024年02月09日
    浏览(35)
  • 探索ClickHouse——使用Projection加速查询

    在测试Projection之前,我们需要先创建一张表,并导入大量数据。 我们可以直接使用指令,从URL指向的文件中获取内容并导入表。但是担心网络不稳定,我们先将文件下载下来。 28497127 pp-complete.csv -rw-rw-r-- 1 fangliang fangliang 4982107267 Aug 29 05:13 pp-complete.csv 即这个文件约有2850万行

    2024年02月07日
    浏览(42)
  • 优化索引粒度参数提升ClickHouse查询性能

    当对高基数列进行过滤查询时,总是希望尽可能跳过更多的行。否则需要处理更多数据、需要更多资源。ClickHouse缺省在MergeTree表读取8192行数据块,但我们可以在创建表时调整该 index_granularity 参数。本文通过示例说明如何调整该参数优化查询性能。 下面示例,创建表并插入

    2024年02月11日
    浏览(44)
  • B站基于Clickhouse的下一代日志体系建设实践

    01 背景介绍 日志作为线上定位问题排障的重要手段,在可观测领域有着不可替代的作用。 稳定性、成本、易用性、可扩展性都是日志系统需要追求的关键点。 B站基于Elastic Stack的日志系统(Billions) 从2017建设以来, 已经服务了超过5年,目前规模超过500台机器,每日写入日

    2024年02月05日
    浏览(77)
  • 用ClickHouse 文件表引擎快速查询分析文件数据

    有时我们需要快速查询分析文件数据,正常流程需要在数据库中创建表,然后利用工具或编码导入数据,这时才能在数据库中查询分析。利用ClickHouse文件引擎可以快速查询文件数据。本文首先介绍ClickHouse文件引擎,然后介绍如何快速实现查询数据文件的方案。 文件表引擎在

    2024年02月13日
    浏览(45)

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

博客赞助

微信扫一扫打赏

请作者喝杯咖啡吧~博客赞助

支付宝扫一扫领取红包,优惠每天领

二维码1

领取红包

二维码2

领红包