QUERY: SELECT NON_NEGATIVE_DERIVATIVE("degrees") - COUNT(*) - COUNT("pH") FROM ( SELECT HOLT_WINTERS_WITH_FIT( FIRST("degrees"), 36091, 66) - MIN("index") + MEAN("index") FROM "h2o_temperature" ORDER BY time DESC) ORDER BY time ASC ===== STDOUT ===== ===== STDERR ===== [I] 2017-02-27T18:53:20Z InfluxDB starting, version unknown, branch unknown, commit u[[h[h[httpd] :[[httpd] ::1 - - [27/Feb/2017:18:54:02 +0000] "POST /query?db=NOAA_water_database¶ms=%7B%7D&q=SELECT++++MODE%28%22water_level%22%29+FROM++%22I%22.%22h2o_feet%22 HTTP/1.1" 200 [E] 2017-02-27T18:54:02Z SELECT non_negative_derivative(degrees) - count(*) - count(pH) FROM (SELECT holt_winters_with_fit(first(degrees), 36091, 66) - min(index) + mean(index) FROM NOAA_water_database.autogen.h2o_temperature ORDER BY time DESC) ORDER BY time ASC [panic:interface conversion: influxql.Expr is *influxql.Wildcard, not *influxql.VarRef] goroutine 40720 [running]: runtime/debug.Stack(0xc426d00ea0, 0xc4227ea1e0, 0xee) /usr/local/share/go/src/runtime/debug/stack.go:24 +0x79 github.com/influxdata/influxdb/influxql.(*QueryExecutor).recover(0xc42018a0c0, 0xc426d00ea0, 0xc425132d80) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/query_executor.go:381 +0x96 panic(0x60eea0, 0xc427a85080) /usr/local/share/go/src/runtime/panic.go:458 +0x243 github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildCallIterator.func1.1(0xc424c88570, 0xc424c87c80, 0xc42524fb60, 0xc4256eba30, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:807 +0x6f3 github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildCallIterator.func1(0xc42524fb60, 0xc424c88570, 0xa3ae00, 0xc42524fb30, 0xa813c0, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:828 +0x7eb github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildCallIterator(0xc424c88570, 0xc42524fb60, 0xa38140, 0xc421adf400, 0x0, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:934 +0x8f github.com/influxdata/influxdb/influxql.buildExprIterator(0xa3ae00, 0xc42524fb60, 0x29f4398, 0xc421829498, 0xc4256eb770, 0x1, 0x1, 0xa3ae00, 0xc42524fb60, 0xa813c0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:409 +0x497 github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildBinaryExprIterator(0xc424c88a00, 0xc42524fb90, 0x55555555555555, 0x7, 0xc426d64928, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:980 +0x107a github.com/influxdata/influxdb/influxql.buildExprIterator(0xa3ad80, 0xc42524fb90, 0x29f4398, 0xc421829498, 0xc4256eb770, 0x1, 0x1, 0xa3ad80, 0xc42524fb90, 0xa813c0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:411 +0x342 github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildBinaryExprIterator(0xc424c88e90, 0xc42524fbf0, 0x0, 0xbb9960, 0x0, 0x2) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:976 +0xfbb github.com/influxdata/influxdb/influxql.buildExprIterator(0xa3ad80, 0xc42524fbf0, 0x29f4398, 0xc421829498, 0xc4256eb770, 0x1, 0x1, 0xa3ad80, 0xc42524fbf0, 0xa813c0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:411 +0x342 github.com/influxdata/influxdb/influxql.buildFieldIterators.func1(0xc4218294e0, 0x1, 0x1, 0x29f4398, 0xc421829498, 0xc4256eb770, 0x1, 0x1, 0xc424c89310, 0x13100, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:345 +0x1a9 github.com/influxdata/influxdb/influxql.buildFieldIterators(0xc4218294e0, 0x1, 0x1, 0x29f4398, 0xc421829498, 0xc4256eb770, 0x1, 0x1, 0x0, 0x0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:380 +0x10f github.com/influxdata/influxdb/influxql.buildIterators(0xc422e21ea0, 0x29f4398, 0xc421829498, 0x0, 0x0, 0xa813c0, 0x0, 0x0, 0x0, 0x0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:100 +0x50c github.com/influxdata/influxdb/influxql.Select(0xc422e21ea0, 0x29f4398, 0xc421829498, 0xc4200136d0, 0xc421829498, 0x0, 0xc421829498, 0x0, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:41 +0xee github.com/influxdata/influxdb/coordinator.(*StatementExecutor).createIterators(0xc42016fb90, 0xc422e21c00, 0xc424c89c38, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/coordinator/statement_executor.go:597 +0x5c9 github.com/influxdata/influxdb/coordinator.(*StatementExecutor).executeSelectStatement(0xc42016fb90, 0xc42753f500, 0xc424c89c38, 0x0, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/coordinator/statement_executor.go:433 +0x75 github.com/influxdata/influxdb/coordinator.(*StatementExecutor).ExecuteStatement(0xc42016fb90, 0xa3e6c0, 0xc42753f500, 0x0, 0x1df4, 0xc42324a8a0, 0xc425132d80, 0xa41de0, 0xc42018e5a0, 0xc42324a7e0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/coordinator/statement_executor.go:57 +0x2b0d github.com/influxdata/influxdb/influxql.(*QueryExecutor).executeQuery(0xc42018a0c0, 0xc426d00ea0, 0xc42795c60f, 0x13, 0xa35900, 0xa813c0, 0x2710, 0x0, 0x0, 0x0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/query_executor.go:331 +0x55d created by github.com/influxdata/influxdb/influxql.(*QueryExecutor).ExecuteQuery /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/query_executor.go:226 +0xc3 service=query [httpd] ::1 - - [27/Feb/2017:18:54:02 +0000] "POST /query?db=NOAA_water_database¶ms=%7B%7D&q=SELECT++++NON_NEGATIVE_DERIVATIVE%28%22degrees%22%29+-+++COUNT%28%2A%29+-+++COUNT%28%22pH%22%29+FROM+%28+SELECT++++HOLT_WINTERS_WITH_FIT%28++FIRST%28%22degrees%22%29%2C+36091%2C+66%29+-+++MIN%28%22index%22%29+%2B+++MEAN%28%22index%22%29+FROM++%22h2o_temperature%22+ORDER+BY+time+DESC%29+ORDER+BY+time+ASC HTTP/1.1" 200 290 "-" "InfluxDBClient" 1ad0ee3d-fd1e-11e6-a6aa-000000000000 926