[
https://issues.apache.org/jira/browse/HAWQ-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15837357#comment-15837357
]
Xiang Sheng commented on HAWQ-1271:
-----------------------------------
Actually, if you run "hawq extract -d postgres -o t.yaml public.t" it will
success.
The reason you failed is your table is not exist in the database that
hawqextract connect to when you want to extract. If you run hawq extract
without assign the database with "-d" option, the default database is
"template1". But your table was created in the database "postgres" ( I guess
) and schema "public". So hawq extract cannot find the table in "public" schema
in "template1" database.
> hawqextract fails to find existing table
> ----------------------------------------
>
> Key: HAWQ-1271
> URL: https://issues.apache.org/jira/browse/HAWQ-1271
> Project: Apache HAWQ
> Issue Type: Improvement
> Reporter: Dmitry Buzolin
> Assignee: Xiang Sheng
>
> SET
> Timing is on.
> psql (8.2.15)
> Type "help" for help.
> gpadmin=# select count(*) from public.t;
> count
> ----------
> 71994207
> (1 row)
> Time: 1161.946 ms
> gpadmin=# \q
> $ hawqextract -o t.yaml t
> 20170113:09:42:55:453137 gpadmin-[INFO]:-try to connect database
> localhost:5432 template1
> 20170113:09:42:55:453137 gpadmin-[INFO]:-try to extract metadata of table 't'
> 20170113:09:42:55:453137 gpadmin-[ERROR]:-Failed to extract metadata: Table
> public.t not exists!
> $ hawqextract -o t.yaml public.t
> [ERROR]:-Failed to extract metadata: Table public.t not exists!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
