[HAWQ-1437] Hadoop enabled Kerberos，HAWQ occurs errors

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Fix Version/s: 2.2.0.0-incubating
• Component/s: PXF
• Assignee: Ed Espino
• Reporter: lynn
• Created: 20/Apr/17 03:40
• Updated: 27/Jun/17 07:46
• Resolved: 27/Jun/17 07:46

Description

When kerberos enabled with Hadoop , HAWQ create external table from hdfs need principal information， what should I do can create it success?

postgres=#
postgres=#
postgres=# CREATE EXTERNAL TABLE pxf_hdfs_textsimple(location text, month text, num_orders int, total_sales float8)
postgres-# LOCATION ('pxf://mycluster/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple')
postgres-# FORMAT 'TEXT' (delimiter=E',');
ERROR: Invalid URI pxf://mycluster/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple : missing authority section

postgres=#
postgres=#
postgres=# CREATE EXTERNAL TABLE pxf_hdfs_textsimple(location text, month text, num_orders int, total_sales float8)
postgres-# LOCATION ('pxf:///mycluster/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple&principal=hdfs-bigdatacenter@BIGDATA')
postgres-# FORMAT 'TEXT' (delimiter=E',');
ERROR: Invalid URI pxf:///mycluster/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple&principal=hdfs-bigdatacenter@BIGDATA : missing authority section