hawq 通过pxf 如何访问hdfs数据
template1=# create external table pxf_hdfs_textsimple(location text,month text ,num_orders int ,total_sales float8) LOCATION ('pxf://mdw:51200/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple') FORMAT 'TEXT' (delimiter=E',');
template1=# \d pxf_hdfs_textsimple
External table "public.pxf_hdfs_textsimple"
Column | Type | Modifiers
-------------+------------------+-----------
location | text |
month | text |
num_orders | integer |
total_sales | double precision |
Type: readable
Encoding: UTF8
Format type: text
Format options: delimiter ',' null '\N' escape '\'
External location: pxf://mdw:51200/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple
template1=# select * from pxf_hdfs_textsimple ;
ERROR: remote component error (0): (libchurl.c:897)