Comments (3)
@Taylor-lagrange Right. Thank you!
I'm moving this issue to the docs repo for further improvement.
from docs.
Range query indeed support where
sub clause, but where must show before align
sub clause
from docs.
SELECT ts, COUNT(1) RANGE '1h' as times
FROM
keyboard_monitor
WHERE date_trunc('day', ts) = '2024-03-11'
ALIGN '1h'
ORDER BY ts DESC LIMIT 10;
This may solve the problem
from docs.
Related Issues (20)
- Update docs for fix(index): S3 `EntityTooSmall` error
- Update docs for COPY FROM not support windows path in 0.6.0 HOT 1
- GreptimeDB is available on FreeBSD HOT 5
- Update docs for New partition grammar
- Clarify greptimedb's supported functions
- Update docs for feat: add configuration for tls watch option
- Update docs for feat: support tracing rule sampler
- Update docs for feat: support tracing rule sampler
- Add testlint
- Add a glossary
- update GreptimeCloud tutorials
- add timezone documentation HOT 1
- Add demo illustrations for node and tables
- Update docs for feat(metasrv): implement maintenance
- Update vector docs when vector 0.37 released
- Update docs for feat: support time range in copy table
- Update docs for feat: add append mode to table options
- Propose - Sidebar label differs from doc title HOT 1
- Update docs for fix: columns table in information_schema misses some columns
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from docs.