yihua commented on code in PR #18876: URL: https://github.com/apache/hudi/pull/18876#discussion_r3322265616
########## website/docs/sql_dml.md: ########## @@ -48,6 +48,29 @@ INSERT INTO hudi_cow_pt_tbl PARTITION(dt = '2021-12-09', hh='11') SELECT 2, 'a2' INSERT INTO hudi_cow_pt_tbl PARTITION(dt, hh) SELECT 1 AS id, 'a1' AS name, 1000 AS ts, '2021-12-09' AS dt, '10' AS hh; ``` +#### Inserting VECTOR, BLOB, and VARIANT columns + +```sql +-- VECTOR: pass an ARRAY of floats with the declared dimension +INSERT INTO products SELECT 'prod_001', 'Shoes', ARRAY(0.12, -0.03, /* ... 768 floats ... */); + +-- BLOB (INLINE): construct the internal struct with named_struct +INSERT INTO media_assets VALUES ( + 'asset_001', 'logo.png', 'image/png', 45230, + named_struct( Review Comment: not a concern -- 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]
