101 lines
3.9 KiB
Plaintext
101 lines
3.9 KiB
Plaintext
[2026-03-19 17:56:53] DuckDB ready with view 'deliveries' from s3://nearle/parquet/deliveries/*.parquet
|
|
[2026-03-19 17:56:55] NODE: Semantic Column Selector - Who is the top revenue tenant?
|
|
[2026-03-19 17:56:55] Selected Columns: ['tenantname', 'orderamount', 'deliveryamt', 'tenantid', 'tenantcontactno', 'tenanttoken', 'tenantsuburb', 'tenantcity', 'tenantaddress', 'othercharges']
|
|
[2026-03-19 17:56:55] NODE: Intent Detection - Who is the top revenue tenant?
|
|
[2026-03-19 17:56:55] NODE: Metric Selection (Semantic Layer)
|
|
[2026-03-19 17:56:55] Semantic Match Found: revenue -> SUM(deliveryamount)
|
|
[2026-03-19 17:56:55] NODE: Chart Planning
|
|
[2026-03-19 17:57:31] NODE: SQL Generation (Reduced Schema)
|
|
[2026-03-19 17:58:29] GEN SQL: Top Performance Comparison -> SELECT
|
|
DATE(deliverydate) AS day,
|
|
COUNT(deliveryid) AS delivery_count
|
|
FROM deliveries
|
|
WHERE
|
|
deliverydate >= (
|
|
SELECT
|
|
MAX(deliverydate)
|
|
FROM deliveries
|
|
) - INTERVAL '30 days'
|
|
GROUP BY
|
|
day
|
|
ORDER BY
|
|
SUM(deliveryamount) DESC
|
|
LIMIT 10
|
|
[2026-03-19 17:58:29] NODE: Batch Execute SQL with Fallback
|
|
[2026-03-19 17:58:29] Initializing DuckDB with live S3 data
|
|
[2026-03-19 17:58:31] DuckDB ready with view 'deliveries' from s3://nearle/parquet/deliveries/*.parquet
|
|
[2026-03-19 17:58:31] EXECUTING SQL for 'Top Performance Comparison':
|
|
SELECT
|
|
DATE(deliverydate) AS day,
|
|
COUNT(deliveryid) AS delivery_count
|
|
FROM deliveries
|
|
WHERE
|
|
deliverydate >= (
|
|
SELECT
|
|
MAX(deliverydate)
|
|
FROM deliveries
|
|
) - INTERVAL '30 days'
|
|
GROUP BY
|
|
day
|
|
ORDER BY
|
|
SUM(deliveryamount) DESC
|
|
LIMIT 10
|
|
[2026-03-19 17:58:33] EXEC DONE: Top Performance Comparison found 10 rows
|
|
[2026-03-19 17:58:33] NODE: Forecasting Layer
|
|
[2026-03-19 17:58:33] NODE: Anomaly Detection
|
|
[2026-03-19 17:58:33] NODE: Batch Validation & Smart Suggestions
|
|
[2026-03-19 17:58:33] NODE: Results Analysis
|
|
[2026-03-19 17:58:57] NODE: Business Insights
|
|
[2026-03-19 17:59:50] NODE: Dashboard Assembly
|
|
[2026-03-19 19:00:02] NODE: Dataset Summary
|
|
[2026-03-19 19:00:02] Initializing DuckDB with live S3 data
|
|
[2026-03-19 19:00:03] DuckDB ready with view 'deliveries' from s3://nearle/parquet/deliveries/*.parquet
|
|
[2026-03-19 19:00:06] NODE: Semantic Column Selector - Who is the top revenue tenant?
|
|
[2026-03-19 19:00:06] Selected Columns: ['tenantname', 'orderamount', 'deliveryamt', 'tenantid', 'tenantcontactno', 'tenanttoken', 'tenantsuburb', 'tenantcity', 'tenantaddress', 'othercharges']
|
|
[2026-03-19 19:00:06] NODE: Intent Detection - Who is the top revenue tenant?
|
|
[2026-03-19 19:00:06] NODE: Metric Selection (Semantic Layer)
|
|
[2026-03-19 19:00:06] Semantic Match Found: revenue -> SUM(deliveryamount)
|
|
[2026-03-19 19:00:06] NODE: Chart Planning
|
|
[2026-03-19 19:00:43] NODE: SQL Generation (Reduced Schema)
|
|
[2026-03-19 19:01:39] GEN SQL: Top Performance Comparison -> SELECT
|
|
DATE(deliverydate) AS day,
|
|
COUNT(deliveryid) AS delivery_count
|
|
FROM deliveries
|
|
WHERE
|
|
deliverydate >= (
|
|
SELECT
|
|
MAX(deliverydate)
|
|
FROM deliveries
|
|
) - INTERVAL '30 days'
|
|
GROUP BY
|
|
day
|
|
ORDER BY
|
|
SUM(deliveryamount) DESC
|
|
LIMIT 10
|
|
[2026-03-19 19:01:39] NODE: Batch Execute SQL with Fallback
|
|
[2026-03-19 19:01:39] Initializing DuckDB with live S3 data
|
|
[2026-03-19 19:01:40] DuckDB ready with view 'deliveries' from s3://nearle/parquet/deliveries/*.parquet
|
|
[2026-03-19 19:01:40] EXECUTING SQL for 'Top Performance Comparison':
|
|
SELECT
|
|
DATE(deliverydate) AS day,
|
|
COUNT(deliveryid) AS delivery_count
|
|
FROM deliveries
|
|
WHERE
|
|
deliverydate >= (
|
|
SELECT
|
|
MAX(deliverydate)
|
|
FROM deliveries
|
|
) - INTERVAL '30 days'
|
|
GROUP BY
|
|
day
|
|
ORDER BY
|
|
SUM(deliveryamount) DESC
|
|
LIMIT 10
|
|
[2026-03-19 19:01:42] EXEC DONE: Top Performance Comparison found 10 rows
|
|
[2026-03-19 19:01:42] NODE: Forecasting Layer
|
|
[2026-03-19 19:01:42] NODE: Anomaly Detection
|
|
[2026-03-19 19:01:42] NODE: Batch Validation & Smart Suggestions
|
|
[2026-03-19 19:01:42] NODE: Results Analysis
|
|
[2026-03-19 19:02:07] NODE: Business Insights
|
|
[2026-03-19 19:02:59] NODE: Dashboard Assembly
|