DATA QUERY

A querier sends a SparkSQL query instruction to a connector, wherein the SparkSQL query instruction contains a table identifier of an HBase table, metadata of the HBase table, and an attribute value corresponding to the metadata. When the connector receives the SparkSQL query instruction, if an inde...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LI, Riguang, DING, Yuanpu
Format: Patent
Sprache:eng ; fre ; ger
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:A querier sends a SparkSQL query instruction to a connector, wherein the SparkSQL query instruction contains a table identifier of an HBase table, metadata of the HBase table, and an attribute value corresponding to the metadata. When the connector receives the SparkSQL query instruction, if an index table corresponding to the table identifier and the metadata exists in a storage device, the connector generates a first Phoenix query instruction and sends the first Phoenix query instruction to the storage device, wherein the index table is used to record a correspondence between an attribute value of the metadata of the HBase table and a RowKey of the HBase table, and the first Phoenix query instruction contains the table identifier, the metadata, and the attribute value. When receiving the first Phoenix query instruction, the storage device obtains the RowKey corresponding to the attribute value from the index table corresponding to the table identifier and the metadata, obtains the data row corresponding to the RowKey from the HBase table corresponding to the table identifier, and sends the data row to the connector. When receiving the data row, the connector sends the data row to the querier.