Weird Export to Parquet logs in UDX_EVENTS
I am a bit puzzled by both the appearance and the meaning of these events found in UDX_EVENTS:
clearseedwh=> select * from udx_events limit 1;
-[ RECORD 1 ]-->+--------------------------------------------------------------------------------------------------------------------------->---------------------------------------------------------------------------------------------------------------------------->------------------------------------------------
report_time | 2025-05-05 14:12:02.527305+00
node_name | v_my_db_node0002
session_id | v_my_db_node0002-104725:0x3148
user_id | 45035996273704962
user_name | dbadmin
transaction_id | 49539595901082292
statement_id | 20
request_id | 0
udx_name | ParquetExport
raw | ▒ (Ebf▒▒▒▒▒2025-05-05 14:12:02.520129+002025-05-05 14:11:16.962678+00file/data/>my_tableGFsDDwhm/225df225->v_my_db_node0002-139679827060288-0.parquet5121030667280.159358 (.5?>C]g▒▒closedcreatedevent_typefilerow_group_expected_size_mbrow_groupsrow_groups_exceeding_targ>etrowssize_mb
any idea what that means and why it looks so weird? Those weird characters are the way they appear in the console.
Here is what I ran
EXPORT TO PARQUET (directory='/data/my_table/') AS SELECT * FROM prod.my_table;
That is on vertica 25
Answers
is it possible to share the parquet file and table definition?