72fd115dc2
exposing tags on cursors, top/bottom are valid funcs now
2015-09-04 13:30:39 -05:00
d466533f20
Return a parse error for order by anything other than time
...
Order by time asc and desc are the only supported order by options
currently. Tags, fields, or multiple order by fields will return
a parse error.
2015-09-03 22:31:58 -06:00
04a20566c1
Allow order by desc in parser
2015-09-03 22:28:35 -06:00
bbc5539517
add SHOW SHARDS statement
...
This commit adds the ability to list all shards in the cluster
and return their id, start time, end time, expiry time, and
owner ids. Shards are grouped by database.
Fixes #3562
2015-09-03 15:46:52 -06:00
816c5f5368
fix #2555 : don't normalize target names
2015-09-03 07:12:15 -04:00
99a22c174b
fix #2555 : add backreference in CQs
...
Add new query syntax to allow the following in CQs:
INTO "1hPolicy".:MEASUREMENT
2015-09-03 07:12:15 -04:00
1228c985ea
Parser support for CREATE DATABASE IF NOT EXISTS
2015-08-28 19:04:50 -07:00
e032242d83
Refine implementation, sole time is invalid
2015-08-21 12:14:53 -07:00
a45d46aac3
Add parser-level test for SELECT on time
2015-08-21 12:14:39 -07:00
d0993c5e3f
Unit-test detection of agggregate and raw queries
2015-08-11 12:25:06 -07:00
101a580e02
do not allow wildcards with fields in select statements
2015-08-06 12:15:08 -05:00
fc4246d7f5
be more strict about identifier printing
...
When stringifying a query, we would print the identifier bare most
of the time. This caused issues when stringifying an identifier
that contained elements of syntax. For example, querying for the
value "in-bytes" would fail because the mapper would serialize it to
in-bytes and would parse it as an expression. Same problem occured
when using keywords as identifier names, such as select or in.
Fixes #3547
2015-08-05 17:40:42 +01:00
6797270403
check if fields are valid during parse.
...
Binary expressions that yield a boolean are invalid and we can catch
these at parse time.
Fixes #3525
2015-08-04 16:02:35 +01:00
eca76ed7a3
Parser fix, only allow ORDER BY clause with time ASC
2015-07-21 12:07:56 -07:00
9ba37325f6
Fixes authorization.
...
Adds GRANT and REVOKE statements for admin privilege. Adds authorization to the query endpoint.
2015-07-17 11:33:06 -07:00
930a1aa523
Require a regex after a regex operator when parsing.
...
Previously, parseRegex could return an empty RegexLiteral
and the expression parser would put that into the right-hand
side of the expression, causing a nil-pointer panic when
the query was later executed. This change adds a check at
the parsing level and returns an error message if a regex
operator (e.g. =~) is not followed by an actual regex.
2015-07-17 11:02:45 -07:00
ee8ba11c4f
Add ON token to SHOW RETENTION POLICIES parser with tests
2015-07-16 13:45:50 -07:00
000d6b8b0b
added tests for SHOW GRANTS FOR statements
2015-06-17 01:24:09 +10:00
cdf7188259
Only ORDER BY ASC is valid for now
...
Fix issue #2731
2015-06-11 00:51:44 -07:00
aa450b7483
fix vet errors
2015-05-28 10:58:39 -06:00
0a8be47ca1
fix #2644 : make SHOW FIELD KEYS FROM /regex/ work
2015-05-27 10:26:32 -04:00
8866c09e67
fix #2644 : make SHOW SERIES FROM /<regex>/ work
2015-05-27 10:26:04 -04:00
cc8f5771fa
fix #2644 : make SHOW TAG VALUES FROM /regex/ work
2015-05-27 10:25:26 -04:00
074b3bf099
Update the way that `DROP SERIES` handles `Sources`
2015-05-21 12:38:35 -07:00
344db8ff1e
Fix up parser and handle new error message.
2015-05-20 14:55:19 -07:00
d6c7130721
more derivative tests
2015-05-19 16:25:23 -06:00
8d17c01b20
make select count(distinct(field)) work
2015-05-19 13:15:14 -06:00
b71540e57b
fix validateCountDistinct
2015-05-19 12:43:16 -06:00
7de477889b
validate arguments for aggregate functions
2015-05-19 12:29:39 -06:00
28d53b644f
first pass at count distinct
2015-05-19 12:29:39 -06:00
b9de38e7d4
support SELECT DISTINCT foo and SELECT distinct(foo)
2015-05-19 09:16:20 -06:00
db79464ae0
more refactoring
2015-05-19 09:16:20 -06:00
06d40a2582
SELECT DISTINCT field -> SELECT distinct(field)
2015-05-19 09:16:20 -06:00
4c28c33332
validateDistinct should complain about aggregates before fields
2015-05-19 09:16:20 -06:00
66b7157fa4
add a test that has single quoted field name
2015-05-19 09:16:19 -06:00
3f9eacf24c
add validations to parser for distinct
2015-05-19 09:16:19 -06:00
b6b916edbc
add distinct keyword
2015-05-19 09:16:19 -06:00
1fa84c9387
Merge pull request #2579 from influxdb/aggregate-where-groupby-fix-2557
...
Fix false positive error for `aggregate functions with GROUP BY time …
2015-05-14 17:02:27 -07:00
098c65ad18
fix false positive error for `aggregate functions with GROUP BY time require a WHERE time clause`
2015-05-14 15:45:13 -06:00
a0a4600e7f
Add derivative function
...
Calculates the derivative of consequtive points and normalizes the
value to a given interval. It supports simple derivates over
fields as well as nested derivatives over another aggregate function.
Fixes #1822
2015-05-13 15:35:42 -06:00
eb1d7a659f
Prohibit multiple columns in select when using derivative
...
May be supported in the future but workaround is to run separate
queries.
2015-05-13 15:35:42 -06:00
cebdfea737
any aggregate function that has a group by time without a where time clause should fail
2015-05-11 17:48:37 -06:00
832ca01cd3
learn to spell claus
2015-05-11 17:48:21 -06:00
892a6e831b
error out for invalid count group select without where time
2015-05-11 17:48:21 -06:00
86db3574ad
fix #2286 : parse error on CREATE CONTINUOUS QUERY
2015-04-17 16:40:29 -04:00
3739433f0c
fix #2268 : fix expression parsing bug
...
Parsing:
WHERE time > now() - 2d AND time < now() + 10d
generated an expression tree that evaluated as:
... AND (time < now()) + 10d
instead of:
... AND time < (now() + 10d)
2015-04-15 12:37:19 -04:00
ebd8ca7016
Merge pull request #2191 from influxdb/calls_case
...
Case-insensitive check for "fill"
2015-04-13 12:13:43 -07:00
a67e9a8a95
fix #2215 : allow keyword default to be unquoted
...
InfluxDB creates a default retention policy named "default". DEFAULT is
also a keyword in the language. This required double quoting "default"
in the ALTER RETENTION POLICY statement. This commit makes the parser
accept it unquoted for that one statement.
2015-04-09 16:37:20 -04:00
25cea58635
refactor scanning & parsing of identifiers
2015-04-09 13:21:13 -04:00
39d74e0486
fix fmt error
2015-04-08 09:26:23 -06:00
f5b769781b
Case-insensitive check for "fill"
2015-04-07 19:21:37 -07:00
e1b9982401
Add support for SET PASSWORD FOR user = 'PASSWORD'
...
Added support for the set password for user, so we can update user
password via the new server administration commands
2015-04-04 14:16:54 +11:00
1219ba7b93
Add simple WHERE time > absolute value test
2015-03-30 16:37:25 -07:00
1b700264a7
Also include NEQ in filters
...
This fixes != for field value comparisons.
2015-03-27 23:07:57 -07:00
272f7f760e
Add unit tests, pass now.
2015-03-27 17:04:46 -07:00
94a8019fc7
Wire up DROP CONTINUOUS QUERY
2015-03-25 11:58:33 -07:00
1c440f8542
Implement "SHOW DIAGNOSTICS"
2015-03-23 23:45:57 -07:00
dd6bb91463
fix test
2015-03-20 16:52:32 -06:00
3c8e830aa3
fixing tests
2015-03-20 16:51:41 -06:00
dc0d8a35dc
wip
2015-03-20 16:51:41 -06:00
fe44f63495
Fix parser unit test, statement is raw
2015-03-19 16:36:24 -07:00
da171cfe32
make vet happy
2015-03-19 15:05:23 -06:00
a6171b3382
refactor of limit/offset
2015-03-19 13:31:46 -06:00
62ae32b0ce
wire up regex in FROM clause
2015-03-16 19:40:59 -04:00
fd005a5f15
influxql: allow regex in FROM clause
2015-03-16 19:40:21 -04:00
e08066495a
Add "SHOW STATS" command
2015-03-15 14:31:16 -07:00
08b15d9370
zeros are ok after all
2015-03-12 18:59:38 -06:00
eda74a25f1
allow offset 0
2015-03-12 18:20:58 -06:00
06e8c1b3e8
Add fill to select statements.
...
Fixes #1913
Add fill(none), fill(<num>), and fill(previous) options
2015-03-11 18:05:31 -07:00
de1defc528
add SHOW SERVERS to query language
2015-03-10 13:46:05 -06:00
1a545a1cc0
Update Slimit and Soffset to SLimit and SOffset
2015-03-09 20:09:47 -07:00
8d2abc5c86
Add Slimit and Soffset. Update tests and behavior to use those.
2015-03-09 18:46:05 -07:00
eca4af5514
Wire ip limits, fix server_test, remove warns
2015-03-07 16:30:42 -08:00
a2e4556563
Allow 'INF' to indicate infinite retention
2015-03-05 15:23:54 -08:00
9d6d36f2e9
fix #1799 : change regex delim to '/' & RHS only
2015-03-03 09:32:15 -05:00
08796bd6af
fix #1799 : make scanner recognize regex
...
Change the regex delimiter from single quotes to back ticks (`) and make
the scanner recognize regex tokens.
Single quotes are used for string literals. Using a unique delimiter for
regular expression literals allows the scanner to recognize regular
expression tokens, which is inline with the way the rest of the
scanner / parser work.
2015-03-03 09:32:15 -05:00
661482937f
Support keys wrapped in dbl quotes
...
Issue: 1729
Trim off any leading or lagging dbl quotes.
2015-02-26 12:40:30 -08:00
c34e28ba10
adding more test coverage for parsting create continuous query statements
2015-02-25 13:01:32 -07:00
60a08466c8
add drop measurement test for parser
2015-02-25 12:42:23 -07:00
151015b4b8
parsing DROP MEASUREMENT
2015-02-25 12:42:23 -07:00
2aa155c428
wip
2015-02-25 12:42:23 -07:00
5f71aed8bd
Fix previously failing GROUP BY * unit tests
...
GROUP BY * functionality is now in place.
2015-02-23 19:09:55 -08:00
27d7f45729
support drop series without from but with where
2015-02-21 17:05:08 -07:00
918c5c8ce9
one more err test condition for drop series
2015-02-21 17:05:08 -07:00
fd9c19ad9c
wire up drop series parsing
2015-02-21 17:05:08 -07:00
9bff9cdeee
issue #1431 : wire up regex queries
2015-02-21 15:38:35 -05:00
12bed3e74f
issue #1430 : add where regex to influxql
2015-02-21 15:37:52 -05:00
5f14d5faf5
WIP: start implementation of continuous queries
...
* Update SelectStatement to have GroupByInterval
* Update parser to verify that CQs have GroupByInterval if Aggregated
* Implement CreateContinousQuery on Server
* Add ContinuousQueries to database
2015-02-17 21:00:24 -05:00
2e4b9d8b3b
Add missing valid statements for SHOW
...
And alphabetize the order.
2015-02-09 17:06:18 -08:00
54a1ac01b1
Test parsing of milliseconds
2015-02-05 14:51:36 -08:00
2b84113487
issue #1423 : wire up show field keys
2015-02-04 10:59:47 -05:00
19992f3ecc
gofmt -s (simplify)
2015-02-01 15:33:12 -05:00
0cf681d19c
influxql: remove TagKeyIdent, add WITH KEY clause
2015-01-29 15:01:25 -05:00
ae33bc99db
issue #1411 : wire up show tag keys
2015-01-28 21:33:19 -05:00
2cf41d6ea9
influxql: fix WHERE TAG KEY parsing
2015-01-28 05:02:36 -05:00
780831bb17
change LIST to SHOW
2015-01-25 22:56:20 -05:00
c524d9afe5
Fix parser tests
2015-01-25 17:51:51 -05:00
ab39d471a3
influxql: add OFFSET
2015-01-25 15:34:49 -05:00
73bc8215bc
Remove combined string/ident scanning.
2015-01-19 16:01:24 -07:00
3c8c8724ed
Implement full ident scanning, single quote strings.
2015-01-19 13:05:38 -07:00
Cory LaNou
Jason Wilder
Ben Johnson
David Norton
Philip O'Toole
Daniel Morsing
gunnaraasen
Robert Nubel
Dejan Golja
Philip O'Toole
Todd Persen
Todd Persen
Paul Dix
Joseph Rothrock
Mark Rushakoff