I have a flow that is connected to an impala database that errors out depending on the size of the data fed into the output tool. It gives the following error code:
Error: Output Data (85): DataWrap2ODBC::SendBatch: [Cloudera][ImpalaODBC] (450) Error when calling the Impala Thrift API ExecuteStatement: SSL_read: error code: 0 Insert into `d_sw_lar_data_analytics`.`pub_la_sales_merge_output`(`employeeid`,`seller`,`start_date`,`direct_manager_full_name`,`right_manager_status`,`manager_status`,`country`,`year`,`year_total_target`,`year_total_actual`,`q1_target`,`q1_actual`,`q2_target`,`q2_actual`,`q3_target`,`q3_actual`,`q4_target`,`q4_actual`,`q1_quota`,`q2_quota`,`q3_quota`,`q4_quota`,`org_hierarchy_leadership_level_1_name`,`org_hierarchy_leadership_level_2_name`,`org_hierarchy_leadership_level_3_name`,`org_hierarchy_leadership_level_4_name`,`org_hierarchy_leadership_level_5_name`,`sub_department`,`grade`,`band_description`,`status`,`years_at_trane`,`quota_fy21`,`year_target_percent_met`,`q1_target_percent_met`,`q2_target_percent_met`,`q3_target_percent_met`,`q4_target_percent_met`,`percent_error_q1`,`percent_error_q2`,`percent_error_q3`,`percent_error_q4`,`percent_error_year`,`last_updated`) Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
As a result, it drops the destination table from the database and overwrites it with a null table. From what I can tell, the schema is still intact, it just has no data in it. The funny thing is that it runs fine (if not a bit slow) when I run it in the gallery. This incident has also made me concerned about the integrity of my output data as it is lost every time the flow is run on my local computer and errors out. Any idea what is causing this issue and how to fix it?
