[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-tabpanelfocusedCommentId=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
[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-tabpanelfocusedCommentId=12987932#action_12987932
]
Carl Steinbach commented on HIVE-1346:
--
Review request: https://reviews.apache.org/r/364/
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.
-
You can reply to this email to add a comment to the issue online.
[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-tabpanelfocusedCommentId=12987933#action_12987933
]
Carl Steinbach commented on HIVE-1346:
--
+1. Will commit if tests pass.
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.
-
You can reply to this email to add a comment to the issue online.
[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-tabpanelfocusedCommentId=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.
