[
https://issues.apache.org/jira/browse/IMPALA-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-5141:
----------------------------------
Component/s: Catalog
> Refresh table & Recover partitions & DML queries fail with
> "FileNotFoundException" when run concurrently with "invalidate metadata foo"
> ---------------------------------------------------------------------------------------------------------------------------------------
>
> Key: IMPALA-5141
> URL: https://issues.apache.org/jira/browse/IMPALA-5141
> Project: IMPALA
> Issue Type: Bug
> Components: Catalog
> Affects Versions: Impala 2.9.0
> Reporter: Mostafa Mokhtar
> Priority: Major
> Attachments: Concurrent operations failure.txt,
> fc4ac8b7600276d0-6a1f4ae90000000d_711368339_data.0.parq,
> table_level_tests_shell.jmx
>
>
> Jmeter JMX file attached.
> When running Repro adjust SOURCE_TABLE_HDFS_PATH to point to your HDFS path
> and copy the parq file attached to that path.
> Errors
> {code}
> TableLoadingException: Failed to load metadata for table: store_sales
> CAUSED BY: RuntimeException: Error loading block metadata for directory
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales:
> File
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales/_impala_insert_staging/7c407f51b95eda50_585abc2f00000000
> does not exist.
> CAUSED BY: FileNotFoundException: File
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales/_impala_insert_staging/7c407f51b95eda50_585abc2f00000000
> does not exist.
> , Query: insert into store_sales partition(ss_sold_date_sk=107) select *
> from store_sales_source.
> {code}
> {code}
> ERROR processing query/statement. Error Code: ERROR_STATE, SQL state:
> TableLoadingException: Failed to load metadata for table: store_sales
> CAUSED BY: RuntimeException: Error loading block metadata for directory
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales:
> File
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales/_impala_insert_staging/7c407f51b95eda50_585abc2f00000000
> does not exist.
> CAUSED BY: FileNotFoundException: File
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales/_impala_insert_staging/7c407f51b95eda50_585abc2f00000000
> does not exist.
> , Query: insert into store_sales partition(ss_sold_date_sk) /*+
> clustered,shuffle */ select * from (select *, mod(cast(rand(52) * 1000000000
> as int),30) from store_sales_source union all select *, 0 from
> store_sales_source limit 0) a.
> {code}
> {code}
> ERROR processing query/statement. Error Code: 0, SQL state:
> TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:
> TableLoadingException: Failed to load metadata for table: store_sales
> CAUSED BY: RuntimeException: Error loading block metadata for directory
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales:
> File
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales/_impala_insert_staging/7c407f51b95eda50_585abc2f00000000
> does not exist.
> CAUSED BY: FileNotFoundException: File
> hdfs://vd1320.halxg.cloudera.com:8020/user/hive/warehouse/table_level_tests/store_sales/_impala_insert_staging/7c407f51b95eda50_585abc2f00000000
> does not exist.
> ), Query: ALTER TABLE store_sales RECOVER PARTITIONS.
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
