103991

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2876, "title": "2026-02-11 12:03:12", "queryText": "SELECT 1;"}

2026-02-11 12:03:23

103990

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2876, "role": "", "title": "2026-02-11 12:03:12", "database": "default", "warehouse": ""}

2026-02-11 12:03:16

103989

worksheet

create

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2876, "title": "2026-02-11 12:03:12"}

2026-02-11 12:03:13

103988

taskflow

update

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"ID": 758, "Name": "test_un_relative", "Version": "572652e"}

2026-02-11 11:28:49

103987

taskflow

update

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"ID": 758, "Name": "test_un_relative", "Version": "5b4a55b"}

2026-02-11 11:28:43

103986

account

signin

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"by": "email", "email": "zhangsenquan@datafuselabs.com"}

2026-02-11 10:13:06

103985

account

signin

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"by": "email", "email": "zhangsenquan@datafuselabs.com"}

2026-02-11 09:59:20

103984

account

signin

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"by": "email", "email": "chenxiaoyu@databend.com"}

2026-02-11 08:20:54

103983

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "role": "account_admin", "title": "2025-08-27 12:55:21", "database": "default", "warehouse": "bohu-small"}

2026-02-11 02:23:15

103982

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1`;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:23:04

103981

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:23:03

103980

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1` limit 2000;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:20:57

103979

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1` limit 20000;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:20:36

103978

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1` limit 100;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:20:25

103977

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1`;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:17:30

103976

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1` limit 10;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:17:16

103975

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,*,*, FROM `default`.`tttt1` limit 10;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:17:13

103974

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT *,*,* FROM `default`.`tttt1` limit 10;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:16:58

103973

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT * FROM `default`.`tttt1` limit 10;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-11 02:16:44

103972

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT * FROM `default`.`tttt1`;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-10 10:00:18

103971

worksheet

update

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"id": 2526, "title": "2025-08-27 12:55:21", "queryText": "CREATE OR REPLACE TASK task_111\n WAREHOUSE='system' \n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\nAS SELECT 111;\n\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\n\nCREATE OR REPLACE TASK task_222\n WAREHOUSE='system' \n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\nAS SELECT 222;\n\nCREATE OR REPLACE TASK task_333\n WAREHOUSE='system' \n AFTER 'task_111'\nAS SELECT 333;\n\nCREATE OR \nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\nSELECT 333;\n\nSHOW TASKS;\n\n\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\n\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\n\nDROP TASK __taskflow_1_22;\nDROP TASK __taskflow_1_11;\nDROP TASK __taskflow_3_11;\nDROP TASK smallfish_test1;\n\nALTER TASK __taskflow_1_11 RESUME;\nALTER TASK __taskflow_1_11 SUSPEND;\n\nCREATE TABLE orders (\n order_id INT,\n product_name VARCHAR,\n quantity INT,\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nselect1 aa from xx.db;\n\nCREATE STREAM order_changes ON TABLE orders;\n\nSHOW FULL STREAMS;\n\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\n\nshow CONNECTIONS;\nshow STAGES;\n\ndesc stage bohu_20231;\n\nshow ROLES;\n\n\n\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\n `Index` VARCHAR NULL DEFAULT 'aaa',\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\n `FirstName` VARCHAR NULL DEFAULT '',\n `LastName` VARCHAR NULL DEFAULT '',\n `Company` VARCHAR NULL DEFAULT '',\n `City` VARCHAR NULL DEFAULT '',\n `Country` VARCHAR NULL DEFAULT '',\n `Phone1` VARCHAR NULL DEFAULT '',\n `Phone2` VARCHAR NULL DEFAULT '',\n `Email` VARCHAR NULL DEFAULT '',\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\n `Website` VARCHAR NULL DEFAULT ''\n);\n\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\n FROM 's3://smallfish-bk/testdata/book1.csv'\n CONNECTION = (\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\n SECRET_ACCESS_KEY = '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'\n )\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\n', SKIP_HEADER = 1 );\n\n\nSELECT count(*) FROM `default`.`tttt1` ;\nSELECT * FROM `default`.`tttt1`;\n\n BEGIN;\n select 11111;\n select 22222;\n COMMIT;\n\n BEGIN; select 3333; select 444; COMMIT;\n\n\nshow SETTINGS like '%result%';\n\nshow tables1 like '%csv%';\n\nSELECT * FROM TASK_HISTORY();\n\nSHOW ROLES;\nSHOW USERS;\nSHOW GRANTS;\n\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\nSHOW GRANTS FOR ROLE 'test_role1';\nSHOW GRANTS OF ROLE account_admin;\nSHOW GRANTS ON DATABASE default;\n\nSHOW WAREHOUSES;\n\n-- ALTER WAREHOUSE <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\n\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\n\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\nALTER WAREHOUSE 'default' UNSET TAG 'env';"}

2026-02-10 09:19:01

103970

account

signin

188.253.126.213

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"by": "email", "email": "zhangsenquan@datafuselabs.com"}

2026-02-10 03:01:27

103969

account

signin

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"by": "email", "email": "chenxiaoyu@databend.com"}

2026-02-10 02:53:22

103968

account

signout

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

Xiaoyu Chen (smallfish) (smallfish.xy@gmail.com)

{"email": "smallfish.xy@gmail.com", "state": "activated"}

2026-02-10 02:53:20

103967

account

signin

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

Xiaoyu Chen (smallfish) (smallfish.xy@gmail.com)

{"by": "oauth2", "email": "smallfish.xy@gmail.com"}

2026-02-10 02:53:06

103966

account

signup

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

Xiaoyu Chen (smallfish) (smallfish.xy@gmail.com)

{"by": "oauth2", "email": "smallfish.xy@gmail.com"}

2026-02-10 02:53:06

103965

account

signout

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"email": "chenxiaoyu@databend.com", "state": "activated"}

2026-02-10 02:52:55

103964

account

signin

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"by": "email", "email": "chenxiaoyu@databend.com"}

2026-02-10 02:52:17

103963

account

signout

2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af

smallfish (chenxiaoyu@databend.com)

{"email": "chenxiaoyu@databend.com", "state": "activated"}

2026-02-10 02:52:13

103962

worksheet

update

188.253.126.212

cloud (hanshanjie@datafuselabs.com)

{"id": 2867, "title": "2026-02-09 14:52:07", "queryText": "show tables;\n\nselect count(1) from test_0209;"}

2026-02-09 14:52:43

103961

worksheet

update

188.253.126.212

cloud (hanshanjie@datafuselabs.com)

{"id": 2867, "title": "2026-02-09 14:52:07", "queryText": "show tables;\n\nselect * from test_0209;"}

2026-02-09 14:52:30

103960

worksheet

update

188.253.126.212

cloud (hanshanjie@datafuselabs.com)

{"id": 2867, "title": "2026-02-09 14:52:07", "queryText": "show tables;"}

2026-02-09 14:52:20

103959

worksheet

update

188.253.126.212

cloud (hanshanjie@datafuselabs.com)

{"id": 2867, "role": "account_admin", "title": "2026-02-09 14:52:07", "database": "default", "warehouse": "default"}

2026-02-09 14:52:16

103958

worksheet

update

188.253.126.212

cloud (hanshanjie@datafuselabs.com)

{"id": 2867, "role": "account_admin", "title": "2026-02-09 14:52:07", "database": "default", "warehouse": ""}

2026-02-09 14:52:15

103957

worksheet

create

188.253.126.212

cloud (hanshanjie@datafuselabs.com)

{"id": 2867, "title": "2026-02-09 14:52:07"}

2026-02-09 14:52:09

103956

dataintegration_task

update

cloud (hanshanjie@datafuselabs.com)

{"Operate": "Start", "TaskIDs": [82]}

2026-02-09 14:51:30

103955

dataintegration_task

create

cloud (hanshanjie@datafuselabs.com)

{"ID": 82, "Desc": "{\"id\":82,\"org_id\":1,\"account_id\":31,\"name\":\"test-1\",\"datasource_id\":42,\"provider_id\":0,\"service_id\":2,\"service_args\":\"{\\\"syncMode\\\":1,\\\"includeTables\\\":[\\\"test_0119\\\"],\\\"conflictKey\\\":\\\"id\\\",\\\"mergeIntervalSeconds\\\":3,\\\"batchSize\\\":1000,\\\"archiveSchedule\\\":{\\\"enabled\\\":true,\\\"cronExpression\\\":\\\"0 1 * * *\\\",\\\"archiveMode\\\":1,\\\"timeColumnName\\\":\\\"timestamp_field\\\",\\\"autoGenerateCondition\\\":true}}\",\"warehouse\":\"default\",\"database\":\"default\",\"table_name\":\"test_0209\",\"table_fields\":\"[]\",\"continuous_ingestion\":0,\"status\":1,\"updated_account_id\":0,\"created_at\":\"2026-02-09T14:51:21.989239389Z\",\"updated_at\":\"2026-02-09T14:51:21.989239389Z\",\"deleted_at\":null}", "Name": "test-1", "Database": "default", "TableName": "test_0209", "Warehouse": "default", "DatasourceID": 42}

2026-02-09 14:51:22

103954

dataintegration_task

update

cloud (hanshanjie@datafuselabs.com)

{"Operate": "Stop", "TaskIDs": [81]}

2026-02-09 14:42:48

103953

account

signin

188.253.126.216

cloud (hanshanjie@datafuselabs.com)

{"by": "email", "email": "hanshanjie@datafuselabs.com"}

2026-02-09 14:42:38

103952

account

signin

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"by": "email", "email": "zhangsenquan@datafuselabs.com"}

2026-02-09 13:17:10

103951

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\n\n "}

2026-02-09 13:16:08

103950

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\ncel\n "}

2026-02-09 13:16:04

103949

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\ncell\n "}

2026-02-09 13:15:57

103948

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\ncel\n "}

2026-02-09 13:15:55

103947

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nce\n "}

2026-02-09 13:15:53

103946

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\ncel\n "}

2026-02-09 13:15:49

103945

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\ncell\n "}

2026-02-09 13:15:36

103944

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "role": "account_admin", "title": "2026-02-06 05:37:56", "database": "automq_db", "warehouse": "default"}

2026-02-09 13:14:40

103943

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nce\n "}

2026-02-09 13:14:23

103942

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\ncell\n "}

2026-02-09 13:14:08

103941

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyxf\n "}

2026-02-09 13:14:00

103940

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyxf cell\n "}

2026-02-09 13:13:58

103939

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyxf \n "}

2026-02-09 13:13:17

103938

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyxf zha\n "}

2026-02-09 13:13:15

103937

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyxf\n "}

2026-02-09 13:13:11

103936

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyxf zha\n "}

2026-02-09 13:13:06

103935

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyxf zhao\n "}

2026-02-09 13:11:47

103934

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyxf\n "}

2026-02-09 13:11:39

103933

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\nyx\n "}

2026-02-09 13:11:36

103932

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333 LIMIT 10;\ny\n "}

2026-02-09 13:11:36

103931

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_2333;\n "}

2026-02-09 13:07:54

103930

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_towers_233;\n "}

2026-02-09 13:06:55

103929

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell_tow\n "}

2026-02-09 13:06:51

103928

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cell\n "}

2026-02-09 13:06:47

103927

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM \n "}

2026-02-09 13:06:26

103926

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * FROM cel\n "}

2026-02-09 13:05:29

103925

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nSELECT * from\n "}

2026-02-09 13:05:26

103924

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\ns\n "}

2026-02-09 13:05:21

103923

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n\nSELECT * from book_db.ce\n "}

2026-02-09 13:05:14

103922

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "role": "account_admin", "title": "2026-02-06 05:37:56", "database": "book_db", "warehouse": "default"}

2026-02-09 13:05:04

103921

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "role": "account_admin", "title": "2026-02-06 05:37:56", "database": "automq_db", "warehouse": "default"}

2026-02-09 13:05:01

103920

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n\nSELECT * from book_db.bo\n "}

2026-02-09 13:04:57

103919

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n\nSELECT * from book_db.b\n "}

2026-02-09 13:04:55

103918

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n\nSELECT * from book_db.\n "}

2026-02-09 13:04:52

103917

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n\nSELECT \n "}

2026-02-09 13:04:43

103916

account

signin

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"by": "email", "email": "zhangsenquan@datafuselabs.com"}

2026-02-09 13:03:16

103915

account

signout

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"email": "zhangsenquan@datafuselabs.com", "state": "activated"}

2026-02-09 13:03:11

103914

account

signin

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"by": "email", "email": "zhangsenquan@datafuselabs.com"}

2026-02-09 13:02:43

103913

account

signout

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"email": "zhangsenquan@datafuselabs.com", "state": "activated"}

2026-02-09 13:02:36

103912

worksheet

update

10.1.158.166

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "role": "account_admin", "title": "2026-02-06 05:37:56", "database": "book_db", "warehouse": "default"}

2026-02-09 10:45:23

103911

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n "}

2026-02-09 09:29:50

103910

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nstudents\n\n \n "}

2026-02-09 09:28:48

103909

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\nsty\n\n \n "}

2026-02-09 09:28:45

103908

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n\n\n \n "}

2026-02-09 09:28:37

103907

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n\n\n\n \n "}

2026-02-09 09:28:33

103906

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "role": "account_admin", "title": "2026-02-06 05:37:56", "database": "automq_db", "warehouse": "default"}

2026-02-09 09:28:23

103905

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickvisual.tb1;\n\n \n "}

2026-02-09 09:28:13

103904

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM cl.tb1;\n\n \n "}

2026-02-09 09:28:12

103903

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, key FROM clickbench.tb1;\n\n \n "}

2026-02-09 09:27:57

103902

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, k FROM clickbench.tb1;\n\n \n "}

2026-02-09 09:27:56

103901

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, _ky FROM clickbench.tb1;\n\n \n "}

2026-02-09 09:27:53

103900

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _log_, _k FROM clickbench.tb1;\n\n \n "}

2026-02-09 09:27:51

103899

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_, _ FROM clickbench.tb1;\n\n \n "}

2026-02-09 09:27:42

103898

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_ FROM clickbench.tb1;\n\n \n "}

2026-02-09 09:27:15

103897

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _time_ FROM clickbench.tb1\n\n \n "}

2026-02-09 09:27:12

103896

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT _ FROM clickbench.tb1\n\n \n "}

2026-02-09 09:27:08

103895

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT * FROM clickbench.tb1\n\n \n "}

2026-02-09 09:26:58

103894

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT * FROM clickbench.\n\n \n "}

2026-02-09 09:26:54

103893

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT * FROM \n\n \n "}

2026-02-09 09:26:52

103892

worksheet

update

10.1.160.61

zhang senquan2 (zhangsenquan@datafuselabs.com)

{"id": 2865, "title": "2026-02-06 05:37:56", "queryText": " create or replace table users (\n user_id int,\n country varchar,\n signup_at timestamp\n );\n\n create or replace table orders (\n order_id int,\n user_id int,\n amount decimal(10,2),\n created_at timestamp,\n channel varchar\n );\n\n insert into users values\n (1, 'CN', '2024-01-01 10:00:00'),\n (2, 'US', '2024-01-02 11:00:00'),\n (3, 'CN', '2024-01-03 12:00:00');\n\n insert into orders values\n (101, 1, 88.80, '2024-02-01 12:00:00', 'app'),\n (102, 1, 30.00, '2024-02-03 09:00:00', 'web'),\n (103, 2, 120.00, '2024-02-02 20:00:00', 'app'),\n (104, 3, 15.50, '2024-02-05 08:30:00', 'web'),\n (105, 3, 70.00, '2024-02-06 21:10:00', 'app');\n\n -- 坏查询 1：列名拼写错误（amout）\nselect user_id, sum(amount) as total_amount\n from orders\n group by user_id;\n\n -- 坏查询 2：JOIN 键写错（o.user 不存在）\n select u.country, count(*) as cnt\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 3：GROUP BY 不完整（select 了 channel 但没 group by）\n select u.country, any_value(o.channel), sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country;\n\n -- 坏查询 4：把聚合别名/聚合条件写在 WHERE（应该走 HAVING 或子查询）\n select u.country, sum(o.amount) as gmv\n from orders o\n join users u on o.user_id = u.user_id\n group by u.country\n having sum(o.amount) > 100;\n\nSELECT * from\n\n \n "}

2026-02-09 09:26:50