How to use it¶
Compile from Source Code¶
You will need to have JDK 8
or JDK 11
installed.
git clone https://github.com/prestodb/sql.git
cd sql
mvn install
git clone https://github.com/prestodb/sql.git
cd sql
gradle build
Build Dependencies¶
<dependency>
<groupId>com.facebook.presto</groupId>
<artifactId>presto-coresql</artifactId>
<version>0.1</version>
</dependency>
<repositories>
<repository>
<id>presto-coresql-snapshots</id>
<snapshots>
<enabled>true</enabled>
</snapshots>
<url>https://oss.sonatype.org/content/groups/public/</url>
</repository>
</repositories>
<dependency>
<groupId>com.facebook.presto</groupId>
<artifactId>presto-coresql</artifactId>
<version>0.2-SNAPSHOT</version>
</dependency>
repositories {
mavenCentral()
}
dependencies {
implementation 'com.facebook.presto:presto-coresql:0.1'
}
repositories {
maven {
url = uri('https://oss.sonatype.org/content/groups/public/')
}
}
dependencies {
implementation 'com.facebook.presto:presto-coresql:0.2-SNAPSHOT'
}
Parse a SQL Statements¶
Parse the SQL Text into Java Objects:
import com.facebook.coresql.parser.AstNode;
import com.facebook.coresql.parser.ParserHelper;
import com.facebook.coresql.parser.Unparser;
String sqlStr = "select 1 from dual where a=b";
AstNode ast = ParserHelper.parseStatement(sqlStr);
String unparsedSqlStr = Unparser.unparse(ast);