nodetool viewbuildstatus¶
Displays the build status of materialized views.
Synopsis¶
nodetool [connection_options] viewbuildstatus [keyspace.view]
Description¶
nodetool viewbuildstatus shows the progress of materialized view builds. When a materialized view is created, Cassandra must populate it with existing data, which can take time for large tables.
Arguments¶
| Argument | Description |
|---|---|
keyspace.view |
Optional: specific view to check |
Examples¶
Check All Views¶
nodetool viewbuildstatus
Check Specific View¶
nodetool viewbuildstatus my_keyspace.my_view
Sample Output¶
Keyspace View Host Status
my_keyspace my_view 192.168.1.101 SUCCESS
my_keyspace my_view 192.168.1.102 BUILDING
my_keyspace my_view 192.168.1.103 SUCCESS
Status Values¶
| Status | Meaning |
|---|---|
| SUCCESS | Build complete |
| BUILDING | Build in progress |
| STARTED | Build initiated |
| FAILED | Build failed |
When to Use¶
After Creating View¶
# Create view
cqlsh -e "CREATE MATERIALIZED VIEW..."
# Monitor build progress
watch nodetool viewbuildstatus my_keyspace.my_view
Troubleshoot View Issues¶
# Check if view build failed
nodetool viewbuildstatus | grep FAILED
Best Practices¶
Guidelines
- Monitor large builds - View builds can take significant time
- Check all nodes - Build status varies per node
- Investigate failures - Check logs if build fails
Related Commands¶
| Command | Relationship |
|---|---|
| compactionstats | View build shows in compaction |
| tablestats | View table statistics |