Full table of contents#
- Introduction
- Administration Guide
- User Guide
- Introduction
- Selected Design Aspects
- Extensions
- Restrictions
- Spatial constraints should be expressed through our qserv_areaspec_* functions
- Spatial constraints must appear at the beginning of WHERE
- Only one spatial constraint is allowed per query
- Arguments passed to spatial constraints functions must be simple literals
- OR is not allowed after qserv_areaspec_* constraint
- Secondary index constraint must be expressed through “=”, “IN”, or “BETWEEN”
- Column(s) used in ORDER BY or GROUP BY must appear in SELECT
- Expressions/functions in ORDER BY clauses are not allowed
- Sub-queries are NOT supported
- Commands that modify tables are disallowed
- Outer joins are not supported with near-neighbor queries
- MySQL-specific syntax is not supported
- Repeated column names through * are not supported
- “USE INDEX()” is not supported
- Variables are not supported
- User Defined Functions
- Example Queries Supported
- Known Bugs
- Notes of Performance
- Developer Guide
- Quick start guide for developers
- Generate documentation
- CSS metadata layout
- Worker Manager API
- Overview
- General API description
- Database API
GET /dbs
POST /dbs
DELETE /dbs/<dbName>
GET /dbs/<dbName>/tables
POST /dbs/<dbName>/tables
DELETE /dbs/<dbName>/tables/<tblName>
GET /dbs/<dbName>/tables/<tblName>/schema
GET /dbs/<dbName>/tables/<tblName>/columns
GET /dbs/<dbName>/tables/<tblName>/chunks
POST /dbs/<dbName>/tables/<tblName>/chunks
DELETE /dbs/<dbName>/tables/<tblName>/chunks/<chunkId>
POST /<dbName>/tables/<tblName>/data
POST /<dbName>/tables/<tblName>/chunks/<chunkId>/data
POST /<dbName>/tables/<tblName>/chunks/<chunkId>/overlap
GET /dbs/<dbName>/tables/<tblName>/index
GET /dbs/<dbName>/tables/<tblName>/chunks/<chunkId>/index
- Xrootd API
- Services API