You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2020/03/02 03:00:05 UTC
[jira] [Commented] (IMPALA-9275) Impala refresh the ORC table does
not take effect
[ https://issues.apache.org/jira/browse/IMPALA-9275?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17048749#comment-17048749 ]
Quanlong Huang commented on IMPALA-9275:
----------------------------------------
Looks like the same cause as IMPALA-8561.
> Impala refresh the ORC table does not take effect
> -------------------------------------------------
>
> Key: IMPALA-9275
> URL: https://issues.apache.org/jira/browse/IMPALA-9275
> Project: IMPALA
> Issue Type: Bug
> Components: Catalog
> Affects Versions: Impala 3.2.0
> Environment: Impala 3.2.0-cdh6.2.0 RELEASE+Hive 1.2.1+Spark 2.0.2
> Reporter: dapeng
> Priority: Major
> Attachments: bi_test.dim_department_create.sql
>
>
> I'm using Impala to refresh the ORC table created by Spark and then execute the select statement to report an error:
> {code:java}
> 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
> {code}
> 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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org