当前位置: 首页 > news >正文

StarRocks如何查看一张表是否是单副本?

多副本:

MySQL [twdata]> show tablet 90695659; +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | DetailCmd | +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | data | sr_event | p20260710 | sr_event | 3169361 | 27379459 | 90695658 | 27379460 | true | SHOW PROC '/dbs/3169361/27379459/partitions/90695658/27379460/90695659'; | +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ 1 row in set (0.00 sec) MySQL [twdata]> SHOW PROC '/dbs/3169361/27379459/partitions/90695658/27379460/90695659'; +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ | ReplicaId | BackendId | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | SchemaHash | DataSize | RowCount | State | IsBad | IsSetBadForce | VersionCount | PathHash | MetaUrl | CompactionStatus | IsErrorState | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ | 90695660 | 35468871 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | -6043518985966267869 | http://127.0.0.131:8040/api/meta/header/90695659 | http://127.0.0.131:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | | 90695661 | 41350191 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | 5916097581675239323 | http://127.0.0.154:8040/api/meta/header/90695659 | http://127.0.0.154:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | | 90695662 | 39894719 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | -5318340163987254342 | http://127.0.0.44:8040/api/meta/header/90695659 | http://127.0.0.44:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ 3 rows in set (0.00 sec)

单副本:

MySQL [twdata]> show tablet 85091038; +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | DetailCmd | +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | twdata | test | $shadow_automatic_partition | test | 3169361 | 52051104 | 52051103 | 85091037 | true | SHOW PROC '/dbs/3169361/52051104/partitions/52051103/85091037/85091038'; | +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ 1 row in set (0.00 sec) MySQL [twdata]> SHOW PROC '/dbs/3169361/52051104/partitions/52051103/85091037/85091038'; +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ | ReplicaId | BackendId | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | SchemaHash | DataSize | RowCount | State | IsBad | IsSetBadForce | VersionCount | PathHash | MetaUrl | CompactionStatus | IsErrorState | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ | 85091039 | 35468872 | 1 | 0 | 1 | 0 | -1 | 0 | NULL | 459811504 | 0 | 0 | NORMAL | false | false | 1 | -6897070086613041248 | http://127.0.0.81:8040/api/meta/header/85091038 | http://127.0.0.81:8040/api/compaction/show?tablet_id=85091038&schema_hash=459811504 | false | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ 1 row in set (0.00 sec)
http://www.jsqmd.com/news/1165884/

相关文章:

  • Codex CLI 深度配置与安全沙箱实战指南
  • 2026年7月最新绍兴宇舶官方售后客服服务电话及地址网点大全 - 亨得利官方服务中心
  • n8n定时采集公众号RSS:零代码自动化信息归档方案
  • C++类与对象(上)
  • AI员工从0到1落地指南:职责定义、低代码开发与持续迭代
  • 】应用服务中的SNAT (Source Network Address Translation 源网络地址转化)
  • 语音识别技术在军事通信中的应用:针对 10 个易混数字的 2 种抗干扰音频预处理方案
  • TADF材料设计实战:ΔEST < 0.2 eV 的分子结构实现 100% IQE 理论值
  • code0 gemini-3.5-flash 企业实战:高频内容审核场景下,模型该怎么管
  • Vivado 2023.1 局部重构进阶:3步解决Matlab/Simulink HDL工作流集成难题
  • 亲身到店探访杭州亨得利官方名表服务中心|最新电话与网点地址(2026年7月更新) - 亨得利官方
  • Quick BI 卡片看板应用:跨5个仪表板聚合关键卡片,构建个人数据门户
  • Claude Code团队版采购决策指南:按日活开发者数×代码仓库量×CI/CD频次动态测算最优License组合
  • AI音乐字幕制作全流程:从音频分离到视频合成的技术实践
  • IEC 61131-3:2025 新版解析:UTF-8支持与4项关键变更对编程的影响
  • 2026年7月最新厦门雅典官方售后客服中心地址电话及服务网点分布 - 亨得利官方服务中心
  • 2026 年新消息:蠡县值得关注的精密冷拔管优质厂家深度剖析,打破认知:以为只是铁管?它藏着千万级精度秘密 - 实业推荐官【官方】
  • UART/SPI/I2C 3种串行接口实战对比:从原理到STM32代码实现
  • Claude Code价格黑盒破解(独家逆向API计费日志分析):真实token消耗与账单偏差率高达23.7%?
  • Midjourney游戏资产生产SOP(含LOD分级Prompt模板+自动命名规则+版本管理Checklist)
  • Unity动画开发进阶:DOTween Pro v1.0.310核心功能与性能优化实战
  • ARM-Linux嵌入式开发实战:从零移植2048游戏到GEC6818开发板
  • Hadoop 3.1.3 HDFS Java API 实战:10个核心文件操作与Shell命令对照实现
  • 仅 3.3% 资金结案!折叠水壶专利 TRO,打破 99% 卖家败诉定式!
  • Versal XPHY物理层设计必用Advanced IO Wizard全流程指南
  • 双节锂电池主动均衡方案:MP2672A与TM4C129LNCZAD应用
  • 如何用SRWE窗口编辑器实现游戏分辨率自由:完整使用指南
  • 电商设计师紧急通知:Midjourney 6.1新增商业授权条款变更(附法律团队解读),3类高危使用场景立即停用,替代方案已验证上线
  • Matplotlib 3.8 科研绘图字体配置:3种方案实现中英文字体分离(宋体+Times New Roman)
  • Unity游戏音效管理系统:从AudioSource到对象池的实战设计