Ad-hoc queries
An ad-hoc query refers to a query that is created on-the-fly to fulfill immediate and specific information needs. Unlike predefined queries, ad-hoc queries are generated in real-time based on your current requirements. They are commonly used in data analysis, decision-making, and exploratory data tasks, where flexibility and quick access to information are crucial.
Similar to traditional databases, RisingWave stores data and allows users to perform ad-hoc queries on it. However, it is important to note that RisingWave does not persist data in a source object, and direct querying of a source is not supported.
| Features | Tables | Sources | Materialized Views |
|---|---|---|---|
| Support ad-hoc queries ( select statement) | yes | no | yes |
| Support streaming queries ( create materialized view statement) | yes | yes | yes |
