NCPOLLDATA queries

Use these sample NCPOLLDATA queries to investigate issues associated with partioning of poll data tables.

Logging in to the NCPOLLDATA database
Log in to the NCPOLLDATA database to run an SQL query that retrieves polling data.
Show partitions allocated to a specific raw or historical poll data table
This query lists the partitions allocated to a specific raw or historical poll data table. This query is useful if you want to investigate whether all partitions are being created properly.
Show which partitions have recently been detached and dropped
This query shows the recent history of which partitions have been detached and then dropped and also those which have not yet been detached but are pending a drop soon. This query is useful if you want to investigate whether partitions are being detached and dropped correctly.
Show log messages for recently attached and detached partitions
This query displays log messages for recently attached and detached partitions.

Parent topic: NCPOLLDATA database