[
https://issues.apache.org/jira/browse/HAWQ-1437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15977206#comment-15977206
]
Oleksandr Diachenko commented on HAWQ-1437:
-------------------------------------------
[~lynnyuan] try this:
pxfautomation=# CREATE EXTERNAL TABLE pxf_hdfs_textsimple(location text, month
text, num_orders int, total_sales float8) LOCATION
('pxf://mycluster/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple')
FORMAT 'TEXT' (delimiter=E',');
It should work if you have "mycluster" as a nameservice configured in HDFS.
> Hadoop enabled Kerberos，HAWQ occurs errors
> ------------------------------------------
>
> Key: HAWQ-1437
> URL: https://issues.apache.org/jira/browse/HAWQ-1437
> Project: Apache HAWQ
> Issue Type: Bug
> Components: PXF
> Reporter: lynn
> Assignee: Ed Espino
> Fix For: 2.2.0.0-incubating
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
