| 474 | return 100000 |
| 475 | |
| 476 | def setup(self): |
| 477 | execute_sql(self.host, self.port, f"DROP TABLE IF EXISTS {self.table_name}") |
| 478 | execute_sql(self.host, self.port, f""" |
| 479 | CREATE TABLE {self.table_name} ( |
| 480 | id LONG, |
| 481 | value DOUBLE, |
| 482 | ts TIMESTAMP |
| 483 | ) TIMESTAMP(ts) PARTITION BY DAY BYPASS WAL |
| 484 | """) |
| 485 | execute_sql(self.host, self.port, f""" |
| 486 | INSERT INTO {self.table_name} |
| 487 | SELECT |
| 488 | x as id, |
| 489 | rnd_double() as value, |
| 490 | timestamp_sequence('2024-01-01', 1000000) as ts |
| 491 | FROM long_sequence(100000) |
| 492 | """) |
| 493 | execute_sql(self.host, self.port, |
| 494 | f"ALTER TABLE {self.table_name} ADD COLUMN sym SYMBOL") |
| 495 | execute_sql(self.host, self.port, f""" |
| 496 | INSERT INTO {self.table_name} |
| 497 | SELECT |
| 498 | 100000 + x as id, |
| 499 | rnd_double() as value, |
| 500 | timestamp_sequence('2024-01-01T00:01:40', 1000000) as ts, |
| 501 | rnd_symbol('A','B','C','D','E') as sym |
| 502 | FROM long_sequence(100000) |
| 503 | """) |
| 504 | |
| 505 | def run(self) -> bool: |
| 506 | """Override run to verify symbol column null count statistics.""" |