[jira] [Commented] (HIVE-11750) ODBC Driver returns column names prefixed with table name

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

    [ https://issues.apache.org/jira/browse/HIVE-11750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14734588#comment-14734588 ] 

Stefan commented on HIVE-11750:
-------------------------------

In JDBC, compared to ODBC, it seems that both res.getMetaData().getColumnLabel(i) and res.getMetaData().getColumnName(i) return 'table.columnName' for both partitioned and non-partitioned tables.

> ODBC Driver returns column names prefixed with table name
> ---------------------------------------------------------
>
>                 Key: HIVE-11750
>                 URL: https://issues.apache.org/jira/browse/HIVE-11750
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Stefan
>
> I created two tables, e.g.
>   1.) create table t1 (abc int comment 'test column') PARTITIONED BY (abc2 string comment 'zzzz');
>   2.) create table t2 (abc int comment 'test column');
> For table t1 the odbc driver returns a table with column names 't1.abc' and 't1.abc2'. Notice the table prefix, which causes problems in some aplications.
> For table t2 the odbc driver returns a table with column names 'abc', which is ok.
> It seems that the partitioned by is causing some problems to the ODBC driver.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)