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|