[
https://issues.apache.org/jira/browse/HAWQ-1437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
lynn updated HAWQ-1437:
-----------------------
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
was:
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
> 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.4.14#64029)
