You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/04/23 01:46:12 UTC
[jira] [Commented] (HAWQ-705) \d combines hive tables with same
prefix but different suffix (numbers) only
[ https://issues.apache.org/jira/browse/HAWQ-705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15254920#comment-15254920 ]
ASF GitHub Bot commented on HAWQ-705:
-------------------------------------
GitHub user sansanichfb opened a pull request:
https://github.com/apache/incubator-hawq/pull/628
HAWQ-705. Fixed aggregation on psql for Hive tables.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/apache/incubator-hawq HAWQ-705
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/628.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #628
----
commit 395d790a87cec5e11a774572b0ed1ec97dd897f9
Author: Oleksandr Diachenko <od...@pivotal.io>
Date: 2016-04-22T23:44:53Z
HAWQ-705. Fixed aggregation on psql for Hive tables.
----
> \d combines hive tables with same prefix but different suffix (numbers) only
> ----------------------------------------------------------------------------
>
> Key: HAWQ-705
> URL: https://issues.apache.org/jira/browse/HAWQ-705
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Hcatalog, PXF
> Reporter: Goden Yao
> Assignee: Oleksandr Diachenko
> Fix For: 2.0.0
>
>
> *repro steps*
> 1) in hive, created test table
> {code}
> hive> CREATE TABLE test (name string, type string, supplier_key int, full_price double) row format delimited fields terminated by ',';
> OK
> Time taken: 1.586 seconds
> {code}
> 2) in hive, created second test table, randomly named test##
> {code}
> hive> CREATE TABLE test22 (name string, type string) row format delimited fields terminated by ',';
> OK
> Time taken: 1.511 seconds
> {code}
> 3) in psql, tried describing schema and i got all test* tables combined into one:
> {code}
> postgres=# \d hcatalog.*
> PXF Hive Table "default.test"
> Column | Type
> --------------+--------
> type | text
> name | text
> supplier_key | int4
> full_price | float8
> type | text
> name | text
> {code}
> I repeated and found the same for other tables with _number_ postfixes. It did not do this for tables with extra characters, however.
> {code}
> hive> CREATE TABLE testabc (name string, type string) row format delimited fields terminated by ',';
> OK
> Time taken: 0.082 seconds
> postgres=# \d+ hcatalog.*
> PXF Hive Table "default.test"
> Column | Type
> --------------+--------
> type | text
> name | text
> supplier_key | int4
> full_price | float8
> type | text
> name | text
> PXF Hive Table "default.testabc"
> Column | Type
> --------+------
> type | text
> name | text
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)