hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sunil Kumar (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1346) Table column name changed to _col1,_col2 ..._coln when where clause used in the select quert statement
Date Fri, 28 May 2010 09:07:39 GMT

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

Sunil Kumar commented on HIVE-1346:
-----------------------------------

Hi Namit,

 Patch HIVE-1346_patch.patch ,2010-05-26 01:48 AM is now  created from $HIVE_TRUNK

> Table column name changed to _col1,_col2 ..._coln when where clause used in the select
quert statement
> ------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-1346
>                 URL: https://issues.apache.org/jira/browse/HIVE-1346
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1
>            Reporter: Sunil Kumar
>            Priority: Minor
>         Attachments: HIVE-1346_patch.patch, HIVE-1346_patch.patch, HIVE-1346_patch.patch
>
>
> when where clause used in the hive query hive -ResultSetMetaData  does not give original
table column name. While when where clause not used ResultSetMetaData  gives original table
column names. I have used following code:-
>                         String tableName = "user";
> 			String sql = "select * from " + tableName + " where id=1";
> 			result = stmt.executeQuery(sql);
> 			ResultSetMetaData metaData = result.getMetaData();
> 			int columnCount = metaData.getColumnCount();
> 			for (int i = 1; i <= columnCount; i++) {
> 				System.out.println("Column name: " + metaData.getColumnName(i));
> 			}
> executing above code i got following result:-
> Column name:_col1
> Column name:_col2
> while original user table columns names were (id,name).

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message