Initial revision.
15 files changed
tree: a5c326e2d1a4c888f8fece3e3f6f0556b3018623
  1. src/
  2. .gitignore
  3. LICENSE
  4. NOTICE
  5. pom.xml
  6. README.md
  7. sqlline
README.md

optiq-csv

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.

Download and build

You need Java (1.7 or higher) and maven (2 or higher).

$ git clone git://github.com/julianhyde/optiq-csv.git
$ cd optiq-csv
$ mvn compile

Run sqlline

$ ./sqlline
sqlline> connect jdbc:optiq:model=target/test-classes/model.json admin admin

Advanced use

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.

More information