InfluxDB 查询demo

    public static void main(String[] args) throws Exception{
        InfluxDB influxDB = InfluxDBFactory.connect("http://XXXX:8086","XXXX","XXXX");
        System.out.println(influxDB.ping());

        QueryResult results = influxDB.query(new Query("SELECT * FROM ceshi_mirror_a5 WHERE time > now() - 5m ","aimos_metdata"));
        QueryResult.Result oneResult = results.getResults().get(0);

        List<DataBean> list = new ArrayList<DataBean>();



        List<QueryResult.Series> series = oneResult.getSeries();
        for (QueryResult.Series serie : series) {
            List<List<Object>> values = serie.getValues();
            for(int i=0;i<values.size();i++){
                String time = values.get(i).get(0).toString();
                BigDecimal bigDecimal;
                if(values.get(i).get(1)==null){
                    bigDecimal = new BigDecimal(0);
                }else{
                    bigDecimal = new BigDecimal(values.get(i).get(1).toString()).setScale(2,BigDecimal.ROUND_DOWN);
                }

                list.add(new DataBean(parseTime(time),bigDecimal));

            }
        }


    }

    /**
     * UTC 转 当前时区 时间
     * @param time
     * @return
     * @throws ParseException
     */
    public static Date parseTime(String time)throws ParseException {
        String STANDARD_DATE_FORMAT_UTC = "yyyy-MM-dd'T'HH:mm:ss";
        SimpleDateFormat sdf = new SimpleDateFormat(STANDARD_DATE_FORMAT_UTC);
        sdf.setTimeZone(TimeZone.getTimeZone("UTC"));

        return sdf.parse(time);
    }