[HIVE-3045] Partition column values are not valid if any of virtual columns is selected

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.10.0
• Component/s: Query Processor
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 23/May/12 13:08
• Updated: 10/Jan/13 19:53
• Resolved: 12/Dec/12 01:40

Description

For example,

hive> select * from srcpart where key < 5;

0	val_0	2008-04-08	11
4	val_4	2008-04-08	11
0	val_0	2008-04-08	11
0	val_0	2008-04-08	11
2	val_2	2008-04-08	11
0	val_1	2008-04-09	12
4	val_5	2008-04-09	12
3	val_4	2008-04-09	12
2	val_3	2008-04-09	12
0	val_1	2008-04-09	12
1	val_2	2008-04-09	12

hive> select *, BLOCK__OFFSET__INSIDE__FILE from srcpart where key < 5;

0	val_0	2008-04-09	11	968
4	val_4	2008-04-09	11	1218
0	val_0	2008-04-09	11	2088
0	val_0	2008-04-09	11	2632
2	val_2	2008-04-09	11	4004
0	val_1	2008-04-09	11	682
4	val_5	2008-04-09	11	1131
3	val_4	2008-04-09	11	1163
2	val_3	2008-04-09	11	2629
0	val_1	2008-04-09	11	4367
1	val_2	2008-04-09	11	5669

Issue Links

• is duplicated by: HIVE-2925 Support non-MR fetching for simple queries with select/limit/filter operations only