-- View the current Catalog and Database
SHOW CURRENT CATALOG;
SHOW CURRENT DATABASE;

-- View all Catalogs
SHOW CATALOGS;

-- Simple Query
SELECT 1;
SELECT CURRENT_TIMESTAMP AS ts, UUID() AS u;
SELECT CAST('2026-01-01' AS DATE) AS d;

-- Multi-Column Query
SELECT 1 AS id, 'hello' AS name, 3.14 AS pi;

-- Create a temporary table (Data Generator)
CREATE TEMPORARY TABLE datagen_source (
  id INT,
  name STRING
) WITH (
  'connector' = 'datagen',
  'rows-per-second' = '1',
  'number-of-rows' = '10'
);

-- Query the temporary table
SELECT * FROM datagen_source;

-- Aggregate Query
SELECT COUNT(*) AS cnt, AVG(id) AS avg_id FROM datagen_source;

-- Switch to the Paimon Catalog
USE CATALOG my_paimon_catalog;

-- View databases and tables
SHOW DATABASES;
USE my_database;
SHOW TABLES;

-- Query the Paimon table
SELECT * FROM my_table LIMIT 100;
SELECT COUNT(*) FROM my_table;

-- Query with VALUES clause (Data Construction)
SELECT * FROM (VALUES (1, 'a'), (2, 'b'), (3, 'c')) AS t(id, name);

-- Filter with WHERE clause
SELECT x, x*x AS sq FROM (VALUES (1),(2),(3),(4),(5)) AS t(x) WHERE x > 2;

-- Aggregate with GROUP BY
SELECT grp, COUNT(*) AS cnt, SUM(val) AS total
FROM (VALUES ('a',1), ('a',2), ('b',10), ('b',20)) AS t(grp, val)
GROUP BY grp;

-- View the current configuration
SET;

-- View the specified configuration
SET 'parallelism.default';

-- Switch the execution mode
SET 'execution.runtime-mode' = 'streaming';
SET 'execution.runtime-mode' = 'batch';

-- Set the time zone
SET 'table.local-time-zone' = 'Asia/Shanghai';