Test sets

Integration tests

Once a Qserv mono-node instance is running, you can run advanced integration test on one dataset by using:

qserv-check-integration.py --load --case=01
# See advanced options with --help option

You can also run the whole integration test suite, with fixed parameters by using :

qserv-test-integration.py
# See advanced options with --help option

Results are stored in $QSERV_RUN_DIR/tmp/qservTest_case<number>/outputs/, and are erased before each run.

Input data sets

Directory structure

case<number>/
    README.txt - contains info about data
    queries/
    data/
    <table>.schema - contains schema info per table
    <table>.csv.gz - contains data``

Database

data from case<number> will be loaded into databases called
  • qservTest_case<number>_mysql, for mysql

  • and LSST, for qserv

Query file format

Query file are named <idA>_<descr>.sql where <idA> means :
  • 0xxx supported, trivial (single object)

  • 1xxx supported, simple (small area)

  • 2xxx supported, medium difficulty (full scan)

  • 3xxx supported, difficult /expensive (e.g. full sky joins)

  • 4xxx supported, very difficult (eg near neighbor for large area)

  • 8xxx queries with bad syntax. They can fail, but should not crash the server

  • 9xxx unknown support

Files that are not yet supported should have extension .FIXME.