[IMPALA-9275] Impala refresh the ORC table does not take effect

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.2.0
• Component/s: Catalog
• Environment: Impala 3.2.0-cdh6.2.0 RELEASE+Hive 1.2.1+Spark 2.0.2
• Epic Color: ghx-label-13
• Assignee: Unassigned
• Reporter: dapeng
• Created: 03/Jan/20 02:16
• Updated: 02/Mar/20 02:59

Description

I'm using Impala to refresh the ORC table created by Spark and then execute the select statement to report an error:

Caused by: java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: Encountered parse error in tail of ORC file hdfs://hadoop2cluster/user/hive-1.2.1/warehouse/test.db/dim_department_adminuc/part-00000: Invalid ORC postscript length

I added the sync_ddl parameter to follow the refresh operation with the same result,so I dropped the table and rebuilt with Hive,and then I can refresh and query this table and it's fine