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

[Stefan (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-11750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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 '');
>   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)

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

[Stefan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-11750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stefan updated HIVE-11750:
--
Description: 
I created two tables, e.g.
  1.) create table t1 (abc int comment 'test column') PARTITIONED BY (abc2 
string comment '');
  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.


  was:
I created two tables, e.g.
  1.) create table t1 (abc int comment 'test column') PARTITIONED BY (abc2 
string comment '');
  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 JDBC driver.



> 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 '');
>   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)