[jira] Created: (HIVE-1346) Table column name changed to _col1,_col2 ..._coln when where clause used in the select quert statement

[Sunil Kumar (JIRA)]

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


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.