You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2011/05/05 23:13:03 UTC
[jira] [Commented] (HIVE-1346) Table column name changed to
_col1,_col2 ..._coln when where clause used in the select quert statement
[ https://issues.apache.org/jira/browse/HIVE-1346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13029578#comment-13029578 ]
Carl Steinbach commented on HIVE-1346:
--------------------------------------
Update: the original 1 line patch does not seem to address all of the problems. This needs to get reworked before it can be committed.
> 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: Hive
> Issue Type: Bug
> Components: Clients
> Affects Versions: 0.5.0, 0.6.0
> Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1
> Reporter: Sunil Kumar
> Assignee: Sunil Kumar
> Priority: Minor
> Attachments: HIVE-1346-with-regenerated-outfiles.patch, 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira