HeatWave User Guide
A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z
A
[index top]- ABS(), HeatWave 8.0.30-u1
- Adaptive Query Execution, HeatWave 8.1.0-u3
- Advisor, HeatWave 8.0.30, HeatWave 8.0.26
- Aggregate functions, HeatWave 8.3.0-u2, HeatWave 8.2.0-u1, HeatWave 8.0.23-u2
- ALTER TABLE, HeatWave 8.0.31
- ASCII(), HeatWave 8.0.23-u1
- Auto Data Compression, HeatWave 8.3.0-u2, HeatWave 8.2.0-u1
- Auto Encoding, HeatWave 8.0.30
- Auto Parallel Load, HeatWave 9.1.0, HeatWave 9.0.1-u1, HeatWave 8.4.0, HeatWave 8.3.0, HeatWave 8.2.0-u1, HeatWave 8.1.0-u4, HeatWave 8.1.0-u3, HeatWave 8.0.26
- Auto Unload, HeatWave 8.4.0, HeatWave 8.0.33
- AutoML, HeatWave 9.0.1-u1, HeatWave 9.0.0, HeatWave 8.3.0-u2, HeatWave 8.2.0-u2, HeatWave 8.1.0-u4, HeatWave 8.1.0-u3, HeatWave 8.1.0-u2, HeatWave 8.1.0, HeatWave 8.0.33, HeatWave 8.0.32-u2, HeatWave 8.0.32-u1, HeatWave 8.0.32, HeatWave 8.0.31, HeatWave 8.0.30, HeatWave 8.0.28-u2
- Autopilot, HeatWave 9.1.0, HeatWave 9.0.0
- AVG(), HeatWave 8.2.0
- Avro file format, HeatWave 8.2.0-u1, HeatWave 8.1.0-u3
B
[index top]- BIN(), HeatWave 8.2.0
- BIT_LENGTH(), HeatWave 8.2.0
- Bloom filter optimization, HeatWave 8.0.27-u2
- Bulk load, HeatWave 9.0.0, HeatWave 8.4.0, HeatWave 8.1.0-u4
C
[index top]- CAST(), HeatWave 8.2.0, HeatWave 8.0.26-u2, HeatWave 8.0.25
- Change propagation, HeatWave 8.1.0, HeatWave 8.0.30-u1, HeatWave 8.0.28-u3
- Column limits, HeatWave 8.0.28-u1
- Comparison functions , HeatWave 8.3.0, HeatWave 8.0.30
- Comparisons, HeatWave 8.0.30
- COMPRESS(), HeatWave 8.0.32
- Compression functions, HeatWave 8.0.32
- CONVERT_TZ(), HeatWave 8.0.27-u3
- COUNT(DISTINCT), HeatWave 8.0.26
- COUNT(NULL), HeatWave 8.0.26-u1
- CRC32(), HeatWave 8.0.32
- CREATE TABLE ... SELECT, HeatWave 8.0.26
- CSV file format, HeatWave 8.0.33-u3
- CUBE, HeatWave 8.2.0-u1
D
[index top]- Data compression, HeatWave 8.0.30-u1, HeatWave 8.0.28-u2
- Data placement, HeatWave 8.0.24
- Data types, HeatWave 8.0.24
- DATE, HeatWave 8.2.0, HeatWave 8.1.0-u2
- DATETIME, HeatWave 8.2.0, HeatWave 8.1.0-u2
- DATE_ADD(), HeatWave 8.0.26
- DATE_SUB(), HeatWave 8.0.26
- DAYOFYEAR(), HeatWave 8.0.23-u1
- Dictionary encoding, HeatWave 8.0.31
- DISTINCT, HeatWave 8.0.26-u1
E
[index top]- ELT(), HeatWave 8.2.0
- Encryption functions, HeatWave 8.0.32
- Error reporting, HeatWave 9.0.1-u1, HeatWave 8.3.0
- EXCEPT, HeatWave 8.1.0
- EXPORT_SET(), HeatWave 8.2.0
F
[index top]- FIELD(), HeatWave 8.2.0
- FORMAT(), HeatWave 8.0.25
- FROM_DAYS(), HeatWave 8.0.30
- FROM_UNIXTIME(), HeatWave 8.0.23-u1
G
[index top]- GenAI, HeatWave 9.1.0, HeatWave 9.0.1-u1, HeatWave 9.0.0
- gen_range(), HeatWave 8.0.30
- gen_rnd_email(), HeatWave 8.0.30
- gen_rnd_pan(), HeatWave 8.0.30
- gen_rnd_ssn(), HeatWave 8.0.30
- gen_rnd_us_phone(), HeatWave 8.0.30
- GET_FORMAT(), HeatWave 8.1.0
- GREATEST(), HeatWave 8.3.0, HeatWave 8.0.30
- GROUP BY, HeatWave 8.2.0-u1, HeatWave 8.0.26-u1
- GROUP_CONCAT(), HeatWave 8.0.30-u1
- Guided Load, HeatWave 8.3.0-u2, HeatWave 8.2.0
H
[index top]- Heap segment size, HeatWave 8.0.30
- HeatWave AutoML, HeatWave 9.0.1-u1, HeatWave 9.0.0, HeatWave 8.3.0-u2, HeatWave 8.2.0-u2, HeatWave 8.1.0-u4, HeatWave 8.1.0-u3, HeatWave 8.1.0-u2, HeatWave 8.1.0, HeatWave 8.0.33, HeatWave 8.0.32-u2, HeatWave 8.0.32-u1, HeatWave 8.0.32, HeatWave 8.0.31, HeatWave 8.0.30, HeatWave 8.0.28-u2
- HeatWave Autopilot;, HeatWave 9.1.0, HeatWave 9.0.0
- HeatWave GenAI, HeatWave 9.1.0, HeatWave 9.0.1-u1, HeatWave 9.0.0
- HeatWave Lakehouse, HeatWave 9.1.0, HeatWave 9.0.1-u1, HeatWave 9.0.0, HeatWave 8.4.0, HeatWave 8.3.0-u2, HeatWave 8.3.0, HeatWave 8.2.0-u2, HeatWave 8.2.0-u1, HeatWave 8.1.0-u4, HeatWave 8.1.0-u3, HeatWave 8.0.33-u3
- HeatWave MySQL, HeatWave 9.1.0, HeatWave 9.0.1-u1, HeatWave 9.0.0
- heatwave_advisor_report table, HeatWave 8.0.32
- heatwave_autopilot_report table, HeatWave 8.0.32
- heatwave_load_report table, HeatWave 8.0.32
- High Availability, HeatWave 8.3.0-u2
- HLL(), HeatWave 8.3.0-u2, HeatWave 8.2.0-u1
- HyperLogLog, HeatWave 8.3.0-u2, HeatWave 8.2.0-u1
J
[index top]- JavaScript, HeatWave 9.1.0
- JSON ->, HeatWave 8.2.0-u1
- JSON ->>, HeatWave 8.2.0-u1
- JSON column path, HeatWave 8.2.0-u1
- JSON data type, HeatWave 8.3.0-u2
- JSON file format, HeatWave 8.4.0
- JSON functions, HeatWave 8.2.0-u1
- JSON inline path, HeatWave 8.2.0-u1
- JSON_ARRAY(), HeatWave 8.2.0-u1
- JSON_DEPTH(), HeatWave 8.2.0-u1
- JSON_EXTRACT(), HeatWave 8.2.0-u1
- JSON_LENGTH(), HeatWave 8.2.0-u1
- JSON_OBJECT(), HeatWave 8.2.0-u1
- JSON_UNQUOTE(), HeatWave 8.2.0-u1
L
[index top]- Lakehouse, HeatWave 9.1.0, HeatWave 9.0.1-u1, HeatWave 9.0.0, HeatWave 8.4.0, HeatWave 8.3.0-u2, HeatWave 8.3.0, HeatWave 8.2.0-u2, HeatWave 8.2.0-u1, HeatWave 8.1.0-u4, HeatWave 8.1.0-u3, HeatWave 8.0.33-u3
- Lakehouse Auto Parallel Load, HeatWave 8.4.0, HeatWave 8.3.0, HeatWave 8.2.0-u1, HeatWave 8.1.0-u4, HeatWave 8.1.0-u3
- Lakehouse Incremental Load, HeatWave 9.0.0
- LAST_DAY, HeatWave 8.0.27-u3
- LEAST(), HeatWave 8.3.0, HeatWave 8.0.30
- LIMIT, HeatWave 8.0.23-u1
- Loading data, HeatWave 8.0.30
- LOG10(), HeatWave 8.0.32
- LOG2(), HeatWave 8.0.32
M
[index top]- Machine learning, HeatWave 9.0.1-u1, HeatWave 9.0.0, HeatWave 8.3.0-u2, HeatWave 8.2.0-u2, HeatWave 8.1.0-u4, HeatWave 8.1.0-u3, HeatWave 8.1.0-u2, HeatWave 8.1.0, HeatWave 8.0.33, HeatWave 8.0.32-u2, HeatWave 8.0.32-u1, HeatWave 8.0.32, HeatWave 8.0.31, HeatWave 8.0.30, HeatWave 8.0.28-u2
- MAKEDATE(), HeatWave 8.0.26-u2
- MAKETIME(), HeatWave 8.1.0
- MAKE_SET(), HeatWave 8.2.0
- mask_inner(), HeatWave 8.0.30
- mask_outer(), HeatWave 8.0.30
- mask_pan(), HeatWave 8.0.30
- mask_pan_relaxed(), HeatWave 8.0.30
- mask_ssn(), HeatWave 8.0.30
- Mathematical functions, HeatWave 8.0.32-u1, HeatWave 8.0.32, HeatWave 8.0.30-u1
- MD5(), HeatWave 8.0.32
- Memory usage, HeatWave 8.1.0
- MID, HeatWave 8.1.0-u1
- MySQL, HeatWave 9.1.0, HeatWave 9.0.1-u1, HeatWave 9.0.0
- MySQL additional functionality, HeatWave 9.0.0, HeatWave 8.4.0, HeatWave 8.3.0-u2, HeatWave 8.2.0-u1, HeatWave 8.1.0-u4
- MySQL InnoDB, HeatWave 9.0.0, HeatWave 8.4.0, HeatWave 8.1.0-u4
O
[index top]- Object Storage, HeatWave 8.0.27-u3
- OFFSET, HeatWave 8.0.23-u1
- Optimizer, HeatWave 8.0.31
- ORD(), HeatWave 8.0.23-u1
- Outbound Replication, HeatWave 8.3.0-u2
P
[index top]- Parquet file format, HeatWave 8.1.0-u3, HeatWave 8.0.33-u3
- Partitioning, HeatWave 8.0.30
- Partitions, HeatWave 9.1.0
- Performance Schema, HeatWave 8.0.33, HeatWave 8.0.32-u1, HeatWave 8.0.30, HeatWave 8.0.27-u2, HeatWave 8.0.23-u1
- PERIOD_ADD(), HeatWave 8.1.0
- PERIOD_DIFF(), HeatWave 8.1.0
- Planned shutdown, HeatWave 8.0.27-u3
- Point-in-time-recovery, HeatWave 8.3.0-u2
- POWER(), HeatWave 8.0.30-u1
Q
[index top]- QUALIFY, HeatWave 8.2.0-u1
- QUARTER(), HeatWave 8.0.23-u1
- Queries, HeatWave 8.0.26-u2, HeatWave 8.0.24
- Query cost model, HeatWave 8.0.26
- Query optimization, HeatWave 8.1.0
- Query plans, HeatWave 8.0.31
- Query scheduling, HeatWave 8.0.26, HeatWave 8.0.23-u2
- Query support, HeatWave 8.2.0-u2
R
[index top]- RAND(), HeatWave 8.0.32
- RANDOM_BYTES(), HeatWave 8.0.32
- rapid_stats_cache_max_entries, HeatWave 8.0.25
- Read Replication, HeatWave 8.3.0-u2
- Recovery, HeatWave 8.0.27-u3, HeatWave 8.0.26-u1
- REGEXP_INSTR, HeatWave 8.1.0-u1
- REGEXP_REPLACE(), HeatWave 8.0.26
- REGEXP_SUBSTR(), HeatWave 8.0.26
- Regular expression functions, HeatWave 8.0.26
- Reload tables, HeatWave 8.3.0-u2
- RENAME TABLE, HeatWave 8.0.31
- rpd_cloumns table, HeatWave 8.0.23-u1
- rpd_column_id table, HeatWave 8.0.30
- rpd_exec_stats table, HeatWave 8.0.23-u1
- rpd_nodes table, HeatWave 8.0.23-u1
- rpd_query_stats table, HeatWave 8.0.33, HeatWave 8.0.27-u2, HeatWave 8.0.23-u1
- rpd_tables table, HeatWave 8.0.32-u1
S
[index top]- Scalability, HeatWave 8.0.26-u1
- Schema inference, HeatWave 8.3.0-u2, HeatWave 8.2.0-u1, HeatWave 8.1.0-u4
- SEC_TO_TIME(), HeatWave 8.1.0
- SELECT, HeatWave 8.3.0-u2, HeatWave 8.2.0-u1
- SELECT DISTINCT, HeatWave 8.0.25
- SET timezone, HeatWave 8.0.23-u1
- SHA(), HeatWave 8.0.32
- SHA1(), HeatWave 8.0.32
- SHA2(), HeatWave 8.0.32
- SIGN(), HeatWave 8.0.30-u1
- SOUNDEX, HeatWave 8.1.0-u1
- SPACE, HeatWave 8.1.0-u1
- Statistics, HeatWave 8.0.25
- STD(), HeatWave 8.2.0-u1, HeatWave 8.2.0, HeatWave 8.0.23-u2
- STDDEV(), HeatWave 8.2.0-u1, HeatWave 8.2.0, HeatWave 8.0.23-u2
- STDDEV_POP(), HeatWave 8.2.0-u1, HeatWave 8.2.0, HeatWave 8.0.23-u2
- STDDEV_SAMP(), HeatWave 8.2.0-u1, HeatWave 8.2.0, HeatWave 8.0.23-u2
- String column encoding, HeatWave 8.0.24
- String functions, HeatWave 8.3.0, HeatWave 8.2.0, HeatWave 8.0.30, HeatWave 8.0.23-u1
- SUBTIME(), HeatWave 8.1.0
- SUM(), HeatWave 8.2.0
- SYSDATE(), HeatWave 8.1.0
T
[index top]- TABLESAMPLE, HeatWave 8.3.0-u2
- Temporal data types, HeatWave 8.2.0, HeatWave 8.0.30
- Temporal functions, HeatWave 8.4.0, HeatWave 8.1.0, HeatWave 8.0.30, HeatWave 8.0.27-u3, HeatWave 8.0.26-u2, HeatWave 8.0.26, HeatWave 8.0.23-u1
- Temporal type comparison, HeatWave 8.0.24
- TEXT, HeatWave 8.0.23-u1
- TIME, HeatWave 8.2.0, HeatWave 8.1.0-u2
- TIMEDIFF(), HeatWave 8.1.0
- Timeseries forecasting, HeatWave 8.0.31
- TIMESTAMP, HeatWave 8.2.0, HeatWave 8.1.0-u2
- Timezone, HeatWave 8.1.0-u2
- Timezone functions, HeatWave 8.4.0, HeatWave 8.0.23-u1
- TIME_TO_SEC(), HeatWave 8.0.23-u1
- TO_DAYS(), HeatWave 8.0.23-u1
- TO_SECONDS(), HeatWave 8.0.23-u1
- TRUNCATE TABLE, HeatWave 8.0.31
U
[index top]- UNCOMPRESS(), HeatWave 8.0.32
- UNCOMPRESSED_LENGTH(), HeatWave 8.0.32
- UNION, HeatWave 8.0.23-u1
- UNION ALL, HeatWave 8.0.23-u1
- UNIX_TIMESTAMP(), HeatWave 8.0.23-u1
- Unload tables, HeatWave 8.3.0-u2
V
[index top]- Variable-length encoding, HeatWave 8.0.24
- VARIANCE(), HeatWave 8.2.0-u1, HeatWave 8.2.0, HeatWave 8.0.23-u2
- VARLEN encoding, HeatWave 8.0.23-u1
- VAR_POP(), HeatWave 8.2.0-u1, HeatWave 8.2.0, HeatWave 8.0.23-u2
- VAR_SAMP(), HeatWave 8.2.0-u1, HeatWave 8.2.0, HeatWave 8.0.23-u2
- Views, HeatWave 8.0.27-u2
W
[index top]- WEEK(), HeatWave 8.0.26-u2
- WEIGHT_STRING, HeatWave 8.1.0-u1
- Window functions, HeatWave 8.2.0-u1, HeatWave 8.0.26-u1
- WITH ROLLUP, HeatWave 8.0.26-u1