[HIVE-2167] Getting metadata after executing group by query is giving wrong meta data

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.5.0, 0.8.0
• Component/s: Query Processor, Server Infrastructure

Environment

Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5).

• Assignee: Unassigned
• Reporter: Chinna Rao Lalam
• Created: 16/May/11 11:56
• Updated: 16/May/11 11:56

Description

The following group by query returned wrong meta data

create table sampletable (key string,value string) PARTITIONED BY(dt STRING, country STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '@';

LOAD DATA LOCAL INPATH '/home/data/details1.txt' OVERWRITE INTO TABLE sampletable partition (dt='21Oct',country='x');

select * from sampletable group by key,value;

"Meta Data :"+resutSet.getMetaData().getColumnName(1)+" --- Data :"+resutSet.getString(1)

Ouput:

"Meta Data :"resutSet.getMetaData().getColumnName(1)" — Data :"+resutSet.getString(1)

Meta Data :(tok_table_or_col key)--- Data :122
Meta Data :(tok_table_or_col key)--- Data :123
Meta Data :(tok_table_or_col key)--- Data :124

Expected Output:

Meta Data : key — Data :122
Meta Data : key — Data :123
Meta Data : key — Data :124