代码拉取完成，页面将自动刷新
Serializes binary _txn file to / from readable JSON format. Primary usage to
investigate storage issues
io.questdb.cliutil.TxSerializer -d <txn_path> | -s <json_path> <txn_path>
-d option prints contents of _txn file to std output in JSON format-s option transforms existing JSON file into binary _txn formatjava -cp utils.jar io.questdb.cliutil.TxSerializer -d /questdb-root/db/trades-COINBASE/_txn > /questdb-root/db/trades-COINBASE/txn.json
java -cp utils.jar io.questdb.cliutil.TxSerializer -s /questdb-root/db/trades-COINBASE/txn.json /questdb-root/db/trades-COINBASE/_txnCopy
Rebuilds table indexes
io.questdb.cliutil.RebuildIndex <table_path> [-p <partition_name>] [-c <column_name>]
<table_path> full path to the table-c column name, optional. If omitted, all indexed columns will have indexes
rebuilt-p optional partition name. If omitted, all partitions will be affectedjava -cp utils.jar io.questdb.cliutil.IndexBuilder /questdb-root/db/trades-COINBASE
java -cp utils.jar io.questdb.cliutil.IndexBuilder /questdb-root/db/trades-COINBASE -c symbol
java -cp utils.jar io.questdb.cliutil.IndexBuilder /questdb-root/db/trades-COINBASE -p 2022-03-21
java -cp utils.jar io.questdb.cliutil.IndexBuilder /questdb-root/db/trades-COINBASE -p 2022-03-21 -c symbol
.i fileRebuilds String column .i file from .d file, helpful when .i file is corrupted
io.questdb.cliutil.RecoverVarIndex <table_path> [-p <partition_name>] [-c <column_name>]
<table_path> full path to the table-c column name, optional. If omitted, all string columns will have .i file
rebuild-p optional partition name. If omitted, all partitions will be affectedjava -cp utils.jar io.questdb.cliutil.RecoverVarIndex /questdb-root/db/trades-COINBASE
java -cp utils.jar io.questdb.cliutil.RecoverVarIndex /questdb-root/db/trades-COINBASE -c stringColumn
java -cp utils.jar io.questdb.cliutil.RecoverVarIndex /questdb-root/db/trades-COINBASE -p 2022-03-21
java -cp utils.jar io.questdb.cliutil.RecoverVarIndex /questdb-root/db/trades-COINBASE -p 2022-03-21 -c stringColumn
Copies all the data from one QuestDB instance to another. Uses Postgres wire to select the data and ILP to insert it. Useful to migrate data to the running instance.
io.questdb.cliutil.Table2Ilp -d <destination_table_name> -dc <destination_ilp_host_port> -s <source_select_query> -sc <source_pg_connection_string>
[-sts <timestamp_column>] [-sym <symbol_columns>] [-dauth <ilp_auth_key:ilp_auth_token>] [-dtls]
-d destination table name-dilp destination ILP connection string, e.g. https::addr=localhost:9000;username=admin;password=quest;-s source select query, e.g. trades or trades WHERE timestamp in '2021-01'-sc source connection string, e.g. jdbc:pgsql://localhost:8812/qdb-sts source designated timestamp column name, defaults to timestamp-sym comma separated list of symbol columns, e.g. symbol,exchangejava -cp utils.jar io.questdb.cliutil.Table2Ilp -d trades -dilp "https::addr=localhost:9000;username=admin;password=quest;" -s "trades WHERE start_time in '2022-06'" \
-sc "jdbc:postgresql://localhost:9812/qdb?user=account&password=secret&ssl=false" \
-sym "ticker,exchagne" -sts start_time
To build single jar with dependencies run
mvn clean package
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
![allcontributors[bot]](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAAAXNSR0IArs4c6QAAAARzQklUCAgICHwIZIgAAAOQSURBVGhD7Zh9TM1RGMe/t1tS7jUSquv9JSniojd1bzYLzRYJkbfZsLH5w2Zmhq2NDVsNM38YxkzyzkSkxlQ3dFVSVF4qVygvlZpU6jq/s2l6v7V7fvv1c56/7ss55z6f5/Pcc869Crfkk2b8R6HgwDK3zQ3LXDC4YW5YZhXgLS0zoe1wuGFuWGYV4C0tM6F80+ItzVtaZhUQvaVjJuuwws2dllH4bykg/SJMv2pFK6uowA42tsjRR0GltGsBjC3ORsy7LHkCL3OdiMOe+lZwH4hdP2JZrBDV8JWZCxEwyAUN5mbc+PwWy0kBhIjMSkRa5UdRmEUDHuWghmH2cigI1t0vpYglbZzkF04hrxH4rfkP5QW8fdwMbBurpVAbclOQ+KUEyX5LMFk1GL+amzD90XnUNDUyhxbN8NPASGj6q1D1ux7aR3G0rTePnordE3wp5I6CNJwvK5QHsM7JDfHaUApzrqwAOwvS6ePh/Rxh1K2ADWn0Z9UVCDPekgfwMa85CHcZT2EWGxOQWV3eAnZBuwB6Jw19HpxxFW9+VjGFZt7SanLm5uhXob+NEqV1NZhtuNQKKMJlAo56BdPXjpfmYv+bzL4NvEbjgQMegRSio0uGcBnJJQVxVNqivOEnZqXGo5newdgEc8MJPmHQDhxKsw8yXEZx3Y92JEeI4aXEtBDrnich+auJDS1ZlSnwxAGD8NA/gibf1ab076Z2p6IEG1+k9E1g4cgRjh4hdhUacPbDqw5BhMtIZtBKuNo7opEcV9rUOFQ21jOBZmZYqVDASCCG9XPoceJ7ix7jlCm/x/MsmcAMOMR5FM5MC7Ekh3Zj8mu/Y96T672a290kZsAnvecidOiY7j6/0/fnP72BvJpvvZ7f2UQmwIPt7JGti4KdwqbL3bltUgfJ8bWaHGNCnDa9xJ6ijL4BvGGkF6Ld/WmyhspPWJZ1x6LEp6iH4J7vYjpW2LSEzUvYxKwZTAzfJz/7PFVONM8teQ9ws/ydxTkn+i6Ct9qZjt9Ejqfb5JiyZlgduK2lGcSS8MvI0lilmYRDHkF0eMo3E9bmJFk61aJxVgfeNykA60d40g8/8T4P0a+fWJTI30HCFVP4/gv/ezWZzfBJi6dXTmuF1YGtlRirdTgwq8pKZV1uWComWOXBDbOqrFTW5YalYoJVHtwwq8pKZV1uWComWOXBDbOqrFTW5YalYoJVHtwwq8pKZd0/i5yLyMz1qjgAAAAASUVORK5CYII=)
