Power grid operation data distributed statistical method and system supporting user-defined function

The invention discloses a power grid operation data distributed statistical method and system supporting a user-defined function. The method comprises the following steps: developing a corresponding UDF user-defined function according to a data statistical service rule; initializing configuration in...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: JI XUECHUN, LI ANGRU, ZHANG KEHENG, CHEN JIAJIA, YAN NI, LIU QI, LI HAO, CHEN ZIYUN
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention discloses a power grid operation data distributed statistical method and system supporting a user-defined function. The method comprises the following steps: developing a corresponding UDF user-defined function according to a data statistical service rule; initializing configuration information such as an SQL template and a UDF function; registering and counting task related information through the front end of the task scheduling center; the scheduling center triggers task scheduling on time according to Cron configuration of the statistical tasks and sends a scheduling request to an actuator in an RPC mode; the actuator receives and analyzes the task parameters, and creates a corresponding Hive mapping table for the HBase measurement table according to the table name information; the executor dynamically generates an SQL (Structured Query Language) statistical statement according to the task parameter information, completes system variable setting, creates a statistical result table, and submi