libhdfs3 icon indicating copy to clipboard operation
libhdfs3 copied to clipboard

clickhouse version 23, connect hdfs error

Open jdxia opened this issue 1 year ago • 1 comments

CREATE TABLE guandata.of0b4be941d9_0( idNullable(Int32), customer_nameNullable(String), commentsNullable(String) )ENGINE=HDFS('hdfs://nameserver1/guandata-store/of0b4/part-000.snappy.parquet','Parquet')

select * from guandata.of0b4be941d9_0; When I execute the SQL query, ClickHouse reports an error.

connection reset by peer: While executing ParquetBlockInputFormat: While exeuting HDFSSource. (NETWORK_ERROR)

The error logs on HDFS are as follows: image

My environment involves connecting ClickHouse to HDFS with Kerberos authentication to query data. I have confirmed that my Kerberos configuration is correct. I can obtain tickets using kinit and verify them with klist.

jdxia avatar Oct 27 '23 10:10 jdxia

hdfs version 2.7

jdxia avatar Oct 31 '23 11:10 jdxia