CREATE TABLE users (
    user_id UUID,
    timestamp TIMESTAMP,
    action TEXT,
    details TEXT,
    PRIMARY KEY (user_id, timestamp)
);

INSERT INTO users (username, email, created_at)
VALUES ('john_doe', 'john@example.com', toTimestamp(now()))
IF NOT EXISTS;

CREATE INDEX ON users (email);

SELECT * FROM users WHERE email = 'john@example.com';

CREATE MATERIALIZED VIEW users_by_email AS
    SELECT * FROM users
    WHERE email IS NOT NULL AND user_id IS NOT NULL
    PRIMARY KEY (email, user_id);

INSERT INTO sessions (session_id, user_id, data)
VALUES (uuid(), 12345, 'session_data')
USING TTL 3600;  -- 1시간 후 자동 삭제

CREATE TABLE page_views (
    page_id UUID PRIMARY KEY,
    view_count COUNTER
);

UPDATE page_views SET view_count = view_count + 1
WHERE page_id = some-uuid;

CREATE FUNCTION avgState (state tuple<int,bigint>, val int)
CALLED ON NULL INPUT
RETURNS tuple<int,bigint>
LANGUAGE java
AS '
    if (val != null) {
        state.setInt(0, state.getInt(0) + 1);
        state.setLong(1, state.getLong(1) + val.intValue());
    }
    return state;
';

CREATE TABLE sensor_data (
    sensor_id UUID,
    year INT,
    month INT,
    timestamp TIMESTAMP,
    temperature FLOAT,
    humidity FLOAT,
    PRIMARY KEY ((sensor_id, year, month), timestamp)
) WITH CLUSTERING ORDER BY (timestamp DESC);