Member since
03-02-2021
1
Post
0
Kudos Received
0
Solutions
03-02-2021
05:28 PM
Hi All, We are copying data as .csv file on HDFS folder which map to schema. When we copied new file "IDQ_log_202103010730.csv" we get provided error on Impala but we can see data from hive. ================================================== HDFS :- [HDFS~]$ hdfs dfs -ls /rdz/idq/files/rdz_idq_monitor/idq_status/ Found 2 items -rw------- 2 impala supergroup 901 2021-03-01 15:26 /rdz/idq/files/rdz_idq_monitor/idq_status/IDQ_log_202103010730.csv -rw-r--r-- 3 impala supergroup 3596 2021-01-28 07:30 /rdz/idq/files/rdz_idq_monitor/idq_status/IDQ_test.log ================================================== [HDFS:21000] default> select * from rdz_idq_monitor.idq_status; Query: select * from rdz_idq_monitor.idq_status Query submitted at: 2021-03-03 10:24:54 (Coordinator: HDFS:25000) ERROR: AnalysisException: Failed to load metadata for table: 'rdz_idq_monitor.idq_status' CAUSED BY: TableLoadingException: Could not load table rdz_idq_monitor.idq_status from catalog CAUSED BY: TException: TGetPartialCatalogObjectResponse(status:TStatus(status_code:GENERAL, error_msgs:[TableLoadingException: Loading file and block metadata for 1 paths for table rdz_idq_monitor.idq_status: failed to load 1 paths. Check the catalog server log for more details.]), lookup_status:OK)
... View more
Labels:
- Labels:
-
Apache Impala