initial attempt for abstraction; druid works with Derby as default

is there something similar between derby and mysql? can we use standard
ansi sql as the default?

On Fri, Oct 10, 2014 at 5:04 PM, jisookim0513 <notifications@github.com>
wrote:

> In mysql-storage/src/main/java/io/druid/storage/mysql/MySQLConnector.java:
>
> > +    );
> > +  }
> > +
> > +  public void createRulesTable(final IDBI dbi, final String tableName)
> > +  {
> > +    createTable(
> > +      dbi,
> > +      tableName,
> > +      String.format(
> > +        "CREATE table %s (id VARCHAR(255) NOT NULL, dataSource VARCHAR(255) NOT NULL, version TINYTEXT NOT NULL, payload LONGTEXT NOT NULL, INDEX(dataSource), PRIMARY KEY (id))",
> > +        tableName
> > +      )
> > +    );
> > +  }
> > +
> > +  public void createConfigTable(final IDBI dbi, final String tableName)
>
> postgres has a different sql statement
>
> —
> Reply to this email directly or view it on GitHub
> <https://github.com/metamx/druid/pull/758/files#r18737021>.
>