Slide 17
Slide 17 text
Copyright © 2024 HeatWavejp All Rights Reserved.
こんなことできるかやってみた
⚫ HeatWave Lakehouse …
--- テーブルの作成
SQL > CREATE TABLE test.t2 (
`r` VARCHAR(10),`b` VARCHAR(10),`swpd` VARCHAR(10),
`free` VARCHAR(10),`buff` VARCHAR(10),`cache` VARCHAR(10),
`si` VARCHAR(10),`so` VARCHAR(10),`bi` VARCHAR(10),
`bo` VARCHAR(10),`in` VARCHAR(10),`cs` VARCHAR(10),
`us` VARCHAR(10),`sy` VARCHAR(10),`id` VARCHAR(10),
`wa` VARCHAR(10),`st` VARCHAR(10),`Datetime` VARCHAR(200),
`free(MB)` VARCHAR(10),`buff(MB)` VARCHAR(10),`cache(MB)` VARCHAR(10)
) ENGINE=lakehouse ENGINE_ATTRIBUTE='{
"file": [{"par": "https://objectstorage(...)/test-murata/o/vmstat.csv"}],
"dialect": {"format": "csv","skip_rows": 1,"is_strict_mode": false,"field_delimiter": ",","record_delimiter": "¥¥n"}}';
Query OK, 0 rows affected (0.0115 sec)
SQL > ALTER TABLE test.t2 SECONDARY_ENGINE = RAPID;
Query OK, 0 rows affected (0.0192 sec)
Records: 0 Duplicates: 0 Warnings: 0
SQL > ALTER TABLE test.t2 SECONDARY_LOAD;
Query OK, 0 rows affected (3.5948 sec)
--- テーブルの参照
SQL > SELECT * FROM test.t2 LIMIT 1;
+----+---+--------+---------+------+----------+----+----+(...)+----+---------------------+----------+----------+-----------+
| r | b | swpd | free | buff | cache | si | so |(...)| st | Datetime | free(MB) | buff(MB) | cache(MB) |
+----+---+--------+---------+------+----------+----+----+(...)+----+---------------------+----------+----------+-----------+
| 31 | 1 | 332288 | 1886468 | 0 | 29498852 | 0 | 0 |(...)| 0 | 2024-09-04 13:01:52 | 1842 | 0 | 28807 |
+----+---+--------+---------+------+----------+----+----+(...)+----+---------------------+----------+----------+-----------+
1 row in set (0.0217 sec)
利用可能