[
https://issues.apache.org/jira/browse/HAWQ-122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lei Chang updated HAWQ-122:
---------------------------
Issue Type: Wish (was: Improvement)
> FILESPACE URL in pg_filespace_entry is confusing
> ------------------------------------------------
>
> Key: HAWQ-122
> URL: https://issues.apache.org/jira/browse/HAWQ-122
> Project: Apache HAWQ
> Issue Type: Wish
> Components: Storage
> Reporter: Lirong Jian
> Assignee: Lirong Jian
> Fix For: backlog
>
>
> postgres=# SELECT * FROM pg_filespace_entry;
> fsefsoid | fsedbid | fselocation
> ----------+---------+------------------------------
> 16384 | 0 | hdfs://Lirong-MBP:9000/gpsql
> (1 row)
> postgres=# CREATE FILESPACE fs_1 ON HDFS (
> postgres(# 'Lirong-MBP:9000/hawq/fs_1');
> CREATE FILESPACE
> postgres=# CREATE FILESPACE fs_2 ON HDFS (
>
>
> 'Lirong-MBP:9000/hawq/fs_2') WITH (NUMREPLICA=2);
> CREATE FILESPACE
> postgres=# CREATE FILESPACE fs_3 ON HDFS (
>
>
> 'Lirong-MBP:9000/hawq/fs_3') WITH (NUMREPLICA=3);
> CREATE FILESPACE
> postgres=# SELECT * FROM pg_filespace_entry;
> fsefsoid | fsedbid | fselocation
> ----------+---------+---------------------------------------------
> 16384 | 0 | hdfs://Lirong-MBP:9000/gpsql
> 16532 | 0 | hdfs://Lirong-MBP:9000/hawq/fs_1
> 16533 | 0 | hdfs://{replica=2}Lirong-MBP:9000/hawq/fs_2
> 16534 | 0 | hdfs://{replica=3}Lirong-MBP:9000/hawq/fs_3
> (4 rows)
> The {replica=3} option is very confusing. It is not a valid HDSF url, which
> means we can only access that URL through external tools such as hdfs,
> although it is valid inside HAWQ (we exclude that part when we are really
> going to access that path).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
