[HIVE-3227] Implement data loading from user provided string directly for test

• Type: Improvement
• Status: Patch Available
• Priority: Trivial
• Resolution: Unresolved
• Affects Version/s: 0.10.0
• Component/s: Query Processor, Testing Infrastructure
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 05/Jul/12 08:10
• Updated: 08/Jul/14 05:27

Description

load data instream 'key value\nkey2 value2' into table test;

This will make test easier and also can reduce test time. For example,

-- ppr_pushdown.q
create table ppr_test (key string) partitioned by (ds string);
alter table ppr_test add partition (ds = '1234');
insert overwrite table ppr_test partition(ds = '1234') select * from (select '1234' from src limit 1 union all select 'abcd' from src limit 1) s;

last query is 4MR job. But can be replaced by

create table ppr_test (key string) partitioned by (ds string) ROW FORMAT delimited fields terminated by ' ';
alter table ppr_test add partition (ds = '1234');
load data local instream '1234\nabcd' overwrite into table ppr_test partition(ds = '1234');

Issue Links

• links to: review board