commit | b3d0a82ca0a2cdbf88dd47b9eb239cfb2ce98618 | [log] [tgz] |
---|---|---|
author | Julian Hyde <julianhyde@gmail.com> | Fri May 24 14:03:06 2013 -0700 |
committer | Julian Hyde <julianhyde@gmail.com> | Fri May 24 14:04:32 2013 -0700 |
tree | 051cb16261f5ad250adeaf4b9bfbd6dd31c1613e | |
parent | 9d658568e93fc1ee2f6c7ac08ca7c78bf60ccdff [diff] |
Split into scenario with a "simple" schema that generates tables (CsvTable) that just execute and a "smart" schema that generates tables (CsvSmartTable) that undergo optimization. Upgrade to optiq-0.3.7.
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.5 or higher; 1.7 preferred) and maven (2 or higher).
$ git clone git://github.com/julianhyde/optiq-csv.git $ cd optiq-csv $ mvn compile
$ ./sqlline sqlline> !connect jdbc:optiq:model=target/test-classes/model.json admin admin sqlline> select * from emp; sqlline> !tables sqlline> !quit
You can also register a CsvSchema as a schema within an Optiq instance. Then you can combine with other data sources.
You can write a “vanity JDBC driver” with a different name.
You can add optimizer rules and new implementations of relational operators to execute queries more efficiently.