Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Export Parquet files to HDFS

I want to export a table to HDFS, but I got the error below, what is my problem?

shr2_vrt_itg_001=> select * from pa_itg.test;
a | b | c | d
1 | 3 | 5 | odds
11 | 13 | 19 | odds
10 | 14 | 8 | evens
(3 rows)

The hdfs directory has the permission of 766

shr2_vrt_itg_001=> ! hdfs dfs -ls -d /MAPR/DATA
drwxrw-rw- - srvc_haven_hitg ldap_haven_hitg 0 2019-02-12 23:26 /MAPR/DATA

shr2_vrt_itg_001=> EXPORT TO PARQUET(directory = 'hdfs:///MAPR/DATA') AS SELECT * FROM pa_itg.test;
WARNING 2005: Directory [/etc/hadoop/conf] does not exist
ERROR 8198: Unable to verify if directory [hdfs:///MAPR/DATA/] exists due to 'Error listing directory [hdfs:///MAPR/DATA] Could not connect to [hdfs://]'

The Vertica account (e.g. shr2_vrt_itg_001) I ran is not a DB admin account.

Appreciate your help on this!



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.