Splunk adapter for Optiq (and also a JDBC driver for Splunk)
Java Shell
Latest commit 3ea93dc Sep 17, 2013 @julianhyde Upgrade to latest optiq.

README.md

optiq-splunk

Splunk adapter for Optiq.

Also provides a JDBC driver for Splunk.

Prerequisites

First install Optiq.

Download and build

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

Example

Optiq-splunk provides a JDBC driver:

Class.forName("net.hydromatic.optiq.impl.splunk.Driver");
Connection connection = DriverManager.getConnection("jdbc:splunk:");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(
    "select \"source\", count(*)\n"
    + "from \"splunk\".\"splunk\"\n"
    + "group by \"source\"");
print(resultSet);
resultSet.close();
statement.close();
connection.close();

You can also register a SplunkSchema as a schema within an Optiq instance. Then you can combine with other data sources.

Status

The following features are complete.

  • JDBC driver.
  • Basic queries.
  • Rules to push down filter, project and aggregation onto Splunk.
  • JOIN, GROUP BY, ORDER BY in client

Bugs

  • COUNT(DISTINCT) gives wrong answer

Backlog

  • Rule to push down join

More information