You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Xiang Sheng (JIRA)" <ji...@apache.org> on 2017/03/08 07:24:38 UTC

[jira] [Commented] (HAWQ-1271) hawqextract fails to find existing table

    [ 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)