You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Goden Yao (JIRA)" <ji...@apache.org> on 2016/04/23 01:09:13 UTC
[jira] [Updated] (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:all-tabpanel ]
Goden Yao updated HAWQ-705:
---------------------------
Component/s: PXF
> \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: Lei Chang
>
> *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)