[
https://issues.apache.org/jira/browse/HAWQ-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15900835#comment-15900835
]
Xiang Sheng commented on HAWQ-1271:
-----------------------------------
Check the "hawq extract" help , I found that for the "-d database" option ,
"The database to connect to. If not specified, reads from the environment
variable $PGDATABASE or defaults to 'template1'." So it will read the
$PGDATABASE as the database option. Users should set this environment variable
before they use these utilities. And there is no need to update the default
database if user set that variable.
> hawqextract fails to find existing table
> ----------------------------------------
>
> Key: HAWQ-1271
> URL: https://issues.apache.org/jira/browse/HAWQ-1271
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Command Line Tools
> 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.15#6346)
