[ https://issues.apache.org/jira/browse/HAWQ-705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15254943#comment-15254943 ]
ASF GitHub Bot commented on HAWQ-705: ------------------------------------- Github user GodenYao commented on the pull request: https://github.com/apache/incubator-hawq/pull/628#issuecomment-213631788 +1 > \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)