[jira] [Created] (HAWQ-705) \d combines hive tables with same prefix but different suffix (numbers) only

["Goden Yao (JIRA)" <ji...@apache.org>]

Goden Yao created HAWQ-705:
------------------------------

             Summary: \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
            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)