3 SQL Parsing Tools / SQL Parsers for Apache Hive

General SQL Parser

https://www.sqlparser.com/

General SQL Parser is a SQL Parser developed by Gudu Software that simplifies decoding SQL grammar and helps your applications stay current with the latest versions of database programs. It makes it easy to fetch, modify, and rewrite SQL segment and prepares a detailed SQL parse tree node structure. With General SQL Parser, you can clean up messy SQL codes, detect SQL Syntax errors, find affected SQL objects, rewrite and convert SQL, and do a lot more.

Export:	HTML,Plain text,RTF
Free edition:
Query analysis:
Query optimalization:
Syntax validation:

Go to vendor website

Apache Calcite

https://calcite.apache.org/

Apache Calcite is an industry-standard SQL parser, validator, and JDBC driver. It represents your query in relational algebra, transforms using planning rules, and optimizes according to a cost model. In addition, you can connect to third-party data sources, browse metadata, and optimize by pushing the computation to the data.

Export:	-
Free edition:
Query analysis:
Query optimalization:
Syntax validation:

Go to vendor website

Queryparser

https://github.com/uber/queryparser

Queryparser supports parsing and analysis for three SQL-dialects, i.e., Vertica, Hive, and Presto. Each dialect implements its own tokenization and parsing logic. There is a single abstract syntax tree (AST) for representing queries of any dialect. This AST is defined in Database/Sql/Type.hs and Database/Sql/Type/Query.hs. The parsing logic produces an AST with table and column identifiers that are "raw" or optionally qualified.

Export:	-
Free edition:
Query analysis:
Query optimalization:
Syntax validation:

Go to vendor website

SQL Parsing Tools for Apache Hive

General SQL Parser

Apache Calcite

Queryparser

Categories

Databases