You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Oleksandr Diachenko (JIRA)" <ji...@apache.org> on 2017/04/20 18:27:04 UTC
[jira] [Commented] (HAWQ-1437) Hadoop enabled Kerberos，HAWQ occurs errors
[ 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)