6.4. 访问外部表时报错failed to get block location of path

➢ 问题
访问外部表 select * from ext_table 时报错：pq: hdfsprotocol_blocklocation: failed to get block location of path /tmp/hdfs//.csv. It is reported generally due to HDFS servie error or another session’s ongoing writing. (exthdfs.c 151)
➢ 解答
建立外表时指定 location 要注意最后不带/ 。