nsivarajan commented on issue #65422:
URL: https://github.com/apache/doris/issues/65422#issuecomment-4924694965
```
[doris@ip-240-79-98-14 ~]$ mysql -uroot -P9030 -h127.0.0.1
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.99 doris version doris-0.0.0-8dd0879f83 (Cloud Mode)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MySQL [(none)]>
MySQL [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| __internal_schema |
| information_schema |
| mysql |
| tt_test_db |
+--------------------+
4 rows in set (0.001 sec)
MySQL [(none)]>
MySQL [(none)]>
MySQL [(none)]> use tt_test_db;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MySQL [tt_test_db]>
MySQL [tt_test_db]> show tables;
+----------------------+
| Tables_in_tt_test_db |
+----------------------+
| tt_orders_dup |
| tt_orders_mow |
| tt_travel_v2 |
| tt_travel_v3 |
| tt_travel_v4 |
| tt_travel_v5 |
+----------------------+
6 rows in set (0.001 sec)
MySQL [tt_test_db]>
MySQL [tt_test_db]> show create table tt_travel_v5;
+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tt_travel_v5 | CREATE TABLE `tt_travel_v5` (
`id` int NULL,
`status` varchar(20) NULL,
`amount` decimal(10,2) NULL
) ENGINE=OLAP
DUPLICATE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 3
PROPERTIES (
"file_cache_ttl_seconds" = "0",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V3",
"light_schema_change" = "true",
"storage_vault_id" = "1",
"storage_vault_name" = "dr_s3_vault",
"disable_auto_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728",
"enable_time_travel" = "true",
"time_travel_retention_days" = "7"
); |
+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.006 sec)
MySQL [tt_test_db]>
MySQL [tt_test_db]> select * from tt_travel_v5;
+------+-----------+--------+
| id | status | amount |
+------+-----------+--------+
| 4 | shipped | 400.00 |
| 5 | delivered | 500.00 |
| 6 | delivered | 600.00 |
| 2 | pending | 200.00 |
| 1 | pending | 100.00 |
| 3 | shipped | 300.00 |
| 7 | delivered | 700.00 |
| 8 | delivered | 800.00 |
+------+-----------+--------+
8 rows in set (0.055 sec)
MySQL [tt_test_db]> SELECT * FROM tt_travel_v5 FOR TIME AS OF '2026-07-05
17:07:35' ORDER BY id;
+------+---------+--------+
| id | status | amount |
+------+---------+--------+
| 1 | pending | 100.00 |
| 2 | pending | 200.00 |
+------+---------+--------+
2 rows in set (0.037 sec)
MySQL [tt_test_db]>
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
