commit | 8cca77f54acbc65cb51eee0d2648e81317151cf2 | [log] [tgz] |
---|---|---|
author | dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> | Tue Nov 15 23:25:14 2022 +0000 |
committer | GitHub <noreply@github.com> | Tue Nov 15 23:25:14 2022 +0000 |
tree | a3ceb142c1c9c48c3708c77ebc1e26bca45f59fb | |
parent | 3018d18cc92815a9218eda1c77e30f43a4bf6630 [diff] |
Bump jackson-databind from 2.1.1 to 2.12.7.1 Bumps [jackson-databind](https://github.com/FasterXML/jackson) from 2.1.1 to 2.12.7.1. - [Release notes](https://github.com/FasterXML/jackson/releases) - [Commits](https://github.com/FasterXML/jackson/commits) --- updated-dependencies: - dependency-name: com.fasterxml.jackson.core:jackson-databind dependency-type: direct:production ... Signed-off-by: dependabot[bot] <support@github.com>
Optiq adapter that reads CSV files.
Optiq-csv is a nice simple example of how to connect Optiq to your own data source and quickly get a full SQL/JDBC interface.
You need Java (1.6 or higher; 1.7 preferred), git and maven (3.0.4 or later).
$ git clone git://github.com/julianhyde/optiq-csv.git $ cd optiq-csv $ mvn compile
Let‘s take a quick look at optiq-csv’s (and optiq‘s) features. We’ll use sqlline, a SQL shell that connects to any JDBC data source and is included with optiq-csv.
Connect to Optiq and try out some queries:
$ ./sqlline sqlline> !connect jdbc:optiq:model=target/test-classes/model.json admin admin sqlline> !tables sqlline> !describe emps sqlline> SELECT * FROM emps; sqlline> EXPLAIN PLAN FOR SELECT * FROM emps; sqlline> !connect jdbc:optiq:model=target/test-classes/smart.json admin admin sqlline> EXPLAIN PLAN FOR SELECT * FROM emps; sqlline> SELECT depts.name, count(*) . . . .> FROM emps JOIN depts USING (deptno) . . . .> GROUP BY depts.name; sqlline> VALUES char_length('hello, ' || 'world!'); sqlline> !quit
(On Windows, the command is sqlline.bat
.)
As you can see, Optiq has a full SQL implementation that can efficiently query any data source.
For a more leisurely walk through what Optiq can do and how it does it, try the Tutorial.