Hello Team , I am introducing Vertica with Apache Iceberg to query our data lake ,
I am following this [https://docs.vertica.com/12.0.x/en/sql-reference/statements/create-statements/create-external-table-iceberg/]
First I mapped Path prefixes
ALTER SESSION SET IcebergPathMapping=
'{"hdfs://node-196.example.com:8020":"webhdfs://node-196.example.com:50070"}';
then I have created the table and referred to iceberg metadata path ,
CREATE EXTERNAL TABLE tablename STORED BY ICEBERG LOCATION 'hdfs_path_to_iceberg_table';
if I made the count
select count(*) from tablename ;
it prints the correct count .
but when I query the tablename I receive all the results as NULL
select * from tablename limit 100;
So please, is there any thing missing from my side ?
Thanks in Advance .
