turns out this is a safety issue (software compatible issue). in clickhouse, there's an option to set output_format_json_quote_64bit_integers = 0 and it will work correctly