[ 
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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to