InfluxDB计算series的数量，Java实现

这是V1.+版本的写法，现在2.+的Influxdb，推荐Flux查询。

谢谢围观 

public class Main {

	private static final Logger LOGGER = LoggerFactory.getLogger(Main.class);

	public static void main(String[] args)
			throws InvalidFormatException, IOException, InstantiationException, IllegalAccessException {
		// importData();
		countSeries();
	}

	public static void countSeries() {
		InfluxDB influxDB = Influx.connect();
		Query query = null;
		QueryResult queryResult = null;
		String sql = null;

		List<String> databases = influxDB.describeDatabases();
		databases.remove("_internal");

		LOGGER.info("数据库的数量为：{},列表如下：{}", databases.size(), databases);

		for (String databaseName : databases) {
			influxDB.setDatabase(databaseName);

			sql = "show measurements";
			query = new Query(sql, databaseName);
			queryResult = influxDB.query(query);

			List<String> measurements = getMeasurements(queryResult);
			for (String measurementName : measurements) {
				sql = String.format("SHOW SERIES ON \"%s\" FROM \"%s\"", databaseName, measurementName);
				query = new Query(sql, databaseName);
				queryResult = influxDB.query(query);
				long num = queryResult.getResults().get(0).getSeries().get(0).getValues().size();
				LOGGER.info("{}.{}.seriesCount = {}", databaseName, measurementName, num);
			}
		}

	}

	private static List<String> getMeasurements(QueryResult queryResult) {
		List<String> collect = queryResult.getResults().get(0).getSeries().get(0).getValues().stream()
				.map(x -> (String) x.get(0)).collect(Collectors.toList());
		return collect;
	}

}

---------------------分割线=============================

这个Flux 查询语句的写法。

##  査measurements
import "influxdata/influxdb/schema"
schema.measurements(bucket: "device-data")

## 査tag
import "influxdata/influxdb/schema"
schema.tagKeys(bucket: "device-data")

## 査fieldKeys
import "influxdata/influxdb/schema"
schema.fieldKeys(bucket: "device-data")

## 査measurementFieldKeys
import "influxdata/influxdb/schema"
schema.measurementFieldKeys(
    bucket: "device-data",
    measurement: "111222100046",
)

## 査measurementTagKeys
import "influxdata/influxdb/schema"
schema.measurementTagKeys(
    bucket: "device-data",
    measurement: "111222100046",
)

## 査measurementTagValues
import "influxdata/influxdb/schema"
schema.measurementTagValues(
    bucket: "example-bucket",
    tag: "example-tag",
    measurement: "example-measurement",
)

## 査tagValues
import "influxdata/influxdb/schema"
schema.tagValues(bucket: "device-data", tag: "deviceId")