Not Able to access HDFS table from Vertica
I have created the text tables in HDFS. Which i am not able to access from vertica external table.
admin=> select count(*),APPLICATION_ID from HADOOPTEST.WTDA_IP_BILL_TRANSFORMED_TEXT group by 2 order by 2;
ERROR 2886: Could not open file [hdfs:///user/hive/warehouse/wtdadev.db/wtda_ip_bill_transformed_text_test/IPBILL_RAW_TRANSFORMED.txt] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
But i am able to access parquet/orc tables from HDFS with same ipaddress and port.
Is there anything i missed? why i am able to access parquet/orc table and why not text table using vertica external?
Thanks & Regards,