[
https://issues.apache.org/jira/browse/HIVE-1346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12968563#action_12968563
]
Carl Steinbach commented on HIVE-1346:
--------------------------------------
@Vinithra: the patch needs to be rebased to trunk and submitted for review.
Another issue is that
this patch does not include any test output updates, which is almost certainly
an oversight since this
change should affect the output of EXPLAIN.
> 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_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.
