Impala快速查询技术在配电网设备运行状态检测中的应用  

Application of Impala Fast Query Technology in Operation Status Detection of Distribution Network Equipment

作　　者：王硕 谢远森 张群安 李逸涛 陈远军 WANG Shuo;XIE Yuan-sen;ZHANG Qun-an;LI Yi-tao;CHEN Yuan-jun(Liuzhou Power Supply Bureau Guangxi Power Grid Co.,Ltd.,Liuzhou 545000 China)

机构地区：[1]广西电网有限责任公司柳州供电局,广西柳州545000

出　　处：《自动化技术与应用》2022年第8期122-125,共4页Techniques of Automation and Applications

基　　金：国家自然科学基金项目(51678239)。

摘　　要：针对配电网设备运行状态检测中数据查询速度较慢的问题,提出应用Impala快速查询技术对配电网设备运行状态进行检测。分析配电网自动化系统结构,对配电网设备运行数据进行分布式存储,待储存文件数量到达一定阈值后,剔除多余数据。利用Impala大规模并行处理机构建查询组件,协调调度工作站。监视运行的所有节点集群状态与元数据,将数据变化发送到其他查询引擎处,保证各节点元数据信息的一致性,实现配电网设备运行状态的快速检测。实验结果表明采用所提方法对配电网设备运行状态进行检测的速度较快,检测效率与精度较高。Aiming at the problem that the data query speed is slow in the operation state detection of distribution network equipment,this paper proposes the application of impala fast query technology to detect the operation status of distribution network equipment.The structure of distribution automation system is analyzed,and the operation data of distribution network equipment is stored distributed.After the number of stored files reaches a certain threshold,the redundant data is eliminated.Using impala large-scale parallel processing mechanism to build query components and coordinate scheduling workstation.It monitors the cluster status and metadata of all running nodes,sends the data changes to other query engines,ensurses the consistency of metadata information of each node,and realizes the rapid detection of the operation status of distribution network equipment.The experimental results show that the proposed method is fast,efficient and accurate.

关 键 词：Impala快速查询技术 配电网设备 运行状态 分布式存储 

分 类 号：TP311.133.1[自动化与计算机技术—计算机软件与理论]