talatuyarer commented on PR #35572:
URL: https://github.com/apache/beam/pull/35572#issuecomment-3065103550
This is also console output for Datagen Table
```sql
talatu-macbookpro:beam talatu$
./sdks/java/extensions/sql/jdbc/build/install/jdbc/bin/jdbc
Welcome to Beam SQL 2.67.0-SNAPSHOT (based on sqlline version 1.4.0)
0: BeamSQL> CREATE EXTERNAL TABLE user_clicks (
. . . . . > event_id BIGINT,
. . . . . > user_id VARCHAR,
. . . . . > click_timestamp TIMESTAMP,
. . . . . > score DOUBLE
. . . . . > )
. . . . . > TYPE 'datagen'
. . . . . > TBLPROPERTIES '{
. . . . . > "number-of-rows": "1000000",
. . . . . >
. . . . . > "fields.event_id.kind": "sequence",
. . . . . > "fields.event_id.start": "1",
. . . . . > "fields.event_id.end": "1000000",
. . . . . >
. . . . . > "fields.user_id.kind": "random",
. . . . . > "fields.user_id.length": "12",
. . . . . >
. . . . . > "fields.click_timestamp.kind": "random",
. . . . . > "fields.click_timestamp.max-past": "60000",
. . . . . >
. . . . . > "fields.score.kind": "random",
. . . . . > "fields.score.min": "0.0",
. . . . . > "fields.score.max": "1.0",
. . . . . > "fields.score.null-rate": "0.1"
. . . . . > }';
No rows affected (0.714 seconds)
0: BeamSQL> select * from user_clicks;
+---------------------+---------+-----------------+-----------------+
| event_id | user_id | click_timestamp | score |
+---------------------+---------+-----------------+-----------------+
| 125001 | OVPqTapBePNf | 2025-07-12 11:28:45 |
0.5743820962452271 |
| 125002 | Hesd7VAYgClK | 2025-07-12 11:29:02 |
0.7441534038969679 |
| 125003 | Ks0ASI6uOGnD | 2025-07-12 11:28:45 |
0.7967499207111198 |
| 125004 | zmzt9rTaSvMG | 2025-07-12 11:29:12 |
0.1106194591952182 |
| 125005 | 5QslGKyzbD5U | 2025-07-12 11:29:11 |
0.27626126517029725 |
| 125006 | S3gty3v2lu5u | 2025-07-12 11:29:10 |
0.9522770170244225 |
| 125007 | zmnSpWe0qElb | 2025-07-12 11:29:19 |
0.7868864046477372 |
| 125008 | bl9PS3gMFCWH | 2025-07-12 11:29:17 |
0.1828805099912838 |
| 125009 | uzi2EXbmD8mL | 2025-07-12 11:28:34 |
0.8953159078329049 |
| 125010 | qRTxOUlaJFEO | 2025-07-12 11:28:56 |
0.7019558075063901 |
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
