Phoenix database access method and device, equipment and medium

Abstract

The invention discloses a Phoenix database access method and device, equipment and a medium, and the method comprises the steps: building a connection channel between a SchemaCrawler and a Phoenix database through a JDBC, and skipping a step of judging whether the Phoenix database supports a Schema definition or not; creating a data source loader through a SchemaCrawler; mapping a table space of the Phoenix database into Schema, acquiring a query mode selection parameter by utilizing a preset parameter input interface, and sending the query mode selection parameter to the data source loader; and when the data source loader obtains the query mode selection parameter, selecting a corresponding target query mode, and querying the Phoenix database by utilizing a preset query mode supporting Phoenix query in the target query mode. According to the technical scheme, the method and the device have the advantage that the SchemaCrawler can access the Phoenix database.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a Phoenix database access method, device, equipment and medium based on SchemaCrawler. Background technique [0002] SchemaCrawler is an open source third-party library that can obtain schema information of databases that support JDBC driver type (JDBC, namely Java Database Connectivity, Java Database Connection), including Database, table, column, PK (Primary key, primary key), FK (ie Foreign key, foreign key), Indexs, Sequence, etc. Based on Hbase, Phoenix provides business-oriented developers with query operations on Hbase in the form of standard sql, and supports most features in standard sql, such as advanced query syntax such as conditional operations, grouping, and paging. Although the open source plug-in of SchemaCrawler is based on the driver of each database to expand, it cannot directly connect to the Phoenix database, that is, it cannot realize access to th...

AI Technical Summary

Problems solved by technology

Although the open source plug-in of SchemaCrawler is extended based on the driver of each database itself, it cannot directly connect to the Phoenix database, that is, it cannot realize access to the Phoenix database. The root cause is that if SchemaCrawler tries to connect to the Phoenix database, it needs to judge the Phoenix database first. Whether to support Schema, but because the Phoenix database is not a traditional relational database, it does not support traditional Schema, but supports tableSpace (table space), which makes SchemaCrawler unable to access Phoenix database

Images