๐Ÿฅ

hive s3 ๋ฐ์ดํ„ฐ ์กฐํšŒ ์‹œ Unknown error 255 Root cause: ConnectionPoolTimeoutException: Timeout waiting for connection from pool ๋ฐœ์ƒ ๋ณธ๋ฌธ

๋ฐ์ดํ„ฐ/ํ•˜๋‘ก

hive s3 ๋ฐ์ดํ„ฐ ์กฐํšŒ ์‹œ Unknown error 255 Root cause: ConnectionPoolTimeoutException: Timeout waiting for connection from pool ๋ฐœ์ƒ

•8• 2022. 10. 5. 14:32
CREATE EXTERNAL TABLE some_table
(   some columns... )
STORED AS SOME_FILE_FORMAT LOCATION 's3a://s3_bucket/my_s3_path/'

์œ„์™€ ๊ฐ™์ด s3 ๊ฒฝ๋กœ๋ฅผ ์ฐธ์กฐํ•˜๋Š” ํ…Œ์ด๋ธ” ์ƒ์„ฑ ํ›„ ์กฐํšŒ ์‹œ ์•„๋ž˜์˜ ์—๋Ÿฌ ๋ฐœ์ƒํ–ˆ๋‹ค.

Disk I/O error on "my_server_info" Failed to open HDFS file s3a:"my_s3_file" Error(255): Unknown error 255 Root cause: ConnectionPoolTimeoutException: Timeout waiting for connection from pool

https://docs.cloudera.com/documentation/enterprise/5-8-x/topics/impala_s3.html#s3_best_practices

 

Using Impala with the Amazon S3 Filesystem | 5.8.x | Cloudera Documentation

Just as with tables located on HDFS storage, you can designate S3-based tables as either internal (managed by Impala) or external, by using the syntax CREATE TABLE or CREATE EXTERNAL TABLE respectively. When you drop an internal table, the files associated

docs.cloudera.com

์œ„ ๋ฌธ์„œ ํ† ๋Œ€๋กœ HDFS์—์„œ ์•„๋ž˜์™€ ๊ฐ™์ด ์„ค์ • ํ›„ ํ•ด๊ฒฐ๋๋‹ค.