Last modified 6 years ago Last modified on 03/22/2013 10:09:33 AM


It is probably inevitable qserv will need to deal with views. The information about views sufficient for qserv to handle it appropriately can be kept in the qserv metadata.

Use cases: use a view to...

  • hide columns
  • join similarly partitioned tables (eg Source x Object)
  • join small dimensions tables (star schema)
  • join a table that has been split into several tables, eg Object_core, Object_extras, Object_photoZ etc

Only power users will be able to define new views in production.


  • views are not very portable between different RDBMSes!