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 "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/10/23 15:45:00 UTC

[jira] [Commented] (IMPALA-7745) java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement

    [ https://issues.apache.org/jira/browse/IMPALA-7745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16660853#comment-16660853 ] 

Tim Armstrong commented on IMPALA-7745:
---------------------------------------

[~dankerzizov] can you provide steps to reproduce this? At a minimum "SHOW CREATE TABLE" output, maybe "SHOW FILES" output for the input table and also any SQL statements to ran to reproduce the problem. 

Any other information about what is going on with the cluster or table also improves the odds that we'll be able to help you. E.g. is the table being modified by any other processes? Are files or partitions deleted from the table from outside of Impala?

My guess is that there's an issue with the workflow where files are deleted or partitions are overwritten outside of impala and the table is not REFRESHed.

> java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement
> -----------------------------------------------------------------------------------------
>
>                 Key: IMPALA-7745
>                 URL: https://issues.apache.org/jira/browse/IMPALA-7745
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>            Reporter: Daniel Sinurat
>            Priority: Major
>
> Caused by: com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: ERROR_STATE, SQL state: 
> Failed to open HDFS file hdfs://xxxx/user/hive/warehouse/report.db/xxxxxxx.
> Error(2): No such file or directory
> I find this error when I try to insert data in impala tables. 
> How to avoid this error?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org