public static void main(String[] args) { String q = "SELECT timestamp, LONG_SUM(count) AS edit_count, DOUBLE_SUM(added) AS chars_added FROM wikipedia WHERE interval BETWEEN 2010-01-01T00:00:00.000Z AND 2020-01-01T00:00:00.000Z BREAK BY 'minute' HINT('timeseries');"; String q1 = "SELECT timestamp, page, LONG_SUM(count) AS edit_count FROM wikipedia WHERE interval BETWEEN 2010-01-01 AND 2020-01-01 AND country='United States' BREAK BY 'all' GROUP BY page ORDER BY edit_count DESC LIMIT 10;"; String q2 = "SELECT page, LONG_SUM(count) AS edit_count FROM wikipedia WHERE interval BETWEEN 2010-01-01T00:00:00.000Z AND 2020-01-01T00:00:00.000Z AND country='United States' BREAK BY 'minute' GROUP BY page LIMIT 10;"; DDataSource driver = new DDataSource("localhost", 4080, "localhost", 8082, null, 3128); Either<String, Either<Joiner4All, Mapper4All>> result = driver.query(q, null, null, true, "sql"); System.out.println(result.right().get().right().get()); } }
public static void main(String[] args) { String q = "SELECT timestamp, LONG_SUM(count) AS edit_count, DOUBLE_SUM(added) AS chars_added FROM wikipedia WHERE interval BETWEEN 2010-01-01T00:00:00.000Z AND 2020-01-01T00:00:00.000Z BREAK BY 'minute' HINT('timeseries');"; String q1 = "SELECT timestamp, page, LONG_SUM(count) AS edit_count FROM wikipedia WHERE interval BETWEEN 2010-01-01 AND 2020-01-01 AND country='United States' BREAK BY 'all' GROUP BY page ORDER BY edit_count DESC LIMIT 10;"; String q2 = "SELECT page, LONG_SUM(count) AS edit_count FROM wikipedia WHERE interval BETWEEN 2010-01-01T00:00:00.000Z AND 2020-01-01T00:00:00.000Z AND country='United States' BREAK BY 'minute' GROUP BY page LIMIT 10;"; DDataSource driver = new DDataSource("localhost", 4080, "localhost", 8082, null, 3128); Either<String, Either<Joiner4All, Mapper4All>> result = driver.query(q, null, null, true, "sql"); System.out.println(result.right().get().right().get()); } }
DDataSource.setProxy(proxyHost, proxyPort); dDriver = new DDataSource(brokerHost, brokerPort, coordinatorHost, coordinatorPort, overlordHost, overlordPort, mysqlHost, mysqlPort, mysqlId, mysqlPasswd, mysqlDbName);
public WorkerActor() { druidDriver = new DDataSource(getBrokerHost(), getBrokerPort(), getCoordinatorHost(), getCoordinatorPort(), getOverlordHost(), getOverlordPort()); }