You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
INSERT OVERWRITE 【db_name.table_name】 WITH LABEL insert_load_table_name SELECT column1,column2,...... FROM 【mysql_catalog.db_name.table_name】
Expected behavior (Required)
The number of rows for 【db_name.table_name】 and 【mysql_catalog.db_name.table_name】 is the same
Real behavior (Required)
【db_name.table_name】 has less data than 【mysql_catalog.db_name.table_name】. Some data has been filtered, and by checking the value of field trackingSQL in command 【show load from db_name where label like 'insert_load_table_name'】, it was found that it was due to some column length values in table【mysql_catalog.db_name.table_name】 exceeding the maximum value of varchar.
I would like to add an optional configuration where when the length value of a field exceeds the maximum value of varchar, the field value is set to null instead of filtering out the entire row.
StarRocks version (Required)
3.1.5-5d8438a
The text was updated successfully, but these errors were encountered:
Steps to reproduce the behavior (Required)
INSERT OVERWRITE 【db_name.table_name】 WITH LABEL insert_load_table_name SELECT column1,column2,...... FROM 【mysql_catalog.db_name.table_name】
Expected behavior (Required)
The number of rows for 【db_name.table_name】 and 【mysql_catalog.db_name.table_name】 is the same
Real behavior (Required)
【db_name.table_name】 has less data than 【mysql_catalog.db_name.table_name】. Some data has been filtered, and by checking the value of field trackingSQL in command 【show load from db_name where label like 'insert_load_table_name'】, it was found that it was due to some column length values in table【mysql_catalog.db_name.table_name】 exceeding the maximum value of varchar.
I would like to add an optional configuration where when the length value of a field exceeds the maximum value of varchar, the field value is set to null instead of filtering out the entire row.
StarRocks version (Required)
3.1.5-5d8438a
The text was updated successfully, but these errors were encountered: