04-Query¶
¶
Query: column datatypes
1. Create a super table containing 1 data column and 1 tag column
2. With data column data types: bool, smallint, tinyint, int, bigint, unsigned bigint, float, double, binary
3. Create child tables and insert data
4. Execute queries on the super table with filtering conditions based on regular data columns, including: Projection queries, Aggregate queries, Group-by queries
¶
Query: column filter
1. Create a super table containing multiple data columns and tags (2-6 fields)
2. Create child tables and insert data
3. Execute queries on the super table with filtering conditions based on regular data columns, including:
Projection queries
Aggregate queries
Group-by queries
4.
¶
Query: during leader election
1. Create 3 dnodes
2. Create db with 10 vgroups 3 replications
2. Create supper table and sub table
3. Stop one of the dnodes with leader vnode on it
4. Select data from super table, it should be success
¶
Query: from dnodes
1. Create a super table distributed across multiple dnodes and vnodes
2. Insert data and query the results
3. Perform partitioned queries using PARTITION BY
4. Check query results when data is distributed across different vnodes, memory, and disk
5. Restart all nodes and verify the computation results
¶
Query: tag scan
1. Create super table with tags
2. Create multiple child tables with different tag values
3. Insert data into child tables
4. Query tag with order by, limit, slimit, group by, distinct, partition by
5. Query tag with sub-queries
6. Query tag with single vgroup and multi vgroups
7. Query tag with different data types
8. Query tag with various combinations of clauses
¶
Query: tag datatypes
1. Create a super table containing 1 data column and 1 tag column
2. With tag column data types: bool, smallint, tinyint, int, bigint, unsigned bigint, float, double, binary
3. Create child tables and insert data
4. Execute queries on the super table with filtering conditions based on regular data columns, including: Projection queries, Aggregate queries, Group-by queries
¶
Query: tag filter
1. Create a super table containing multiple data columns and tags (1-6 fields)
2. Create child tables and insert data
3. Execute queries on the super table with filtering conditions based on regular data columns, including:
Projection queries
Aggregate queries
Group-by queries
4. Jira TS-4421
¶
Query: tbname filter
1. Create a super table
2. Create child tables and insert data
3. Execute the following query operations on the super table using tbname INconditions:• Projection queries (column selection)• Aggregate queries (COUNT/SUM/AVG/MIN/MAX)• Grouping queries (GROUP BY with HAVING)