[
https://issues.apache.org/jira/browse/HIVE-3227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424380#comment-13424380
]
Edward Capriolo commented on HIVE-3227:
---------------------------------------
I think we have to be careful here. What does it do for partitioned tables.
What does it do for bucket tables? What does it do for tables that are ordered
by something? We know that this is just supposed to be used for light testing
but users will likely use it for everything and then it either needs to work or
fail with error
> Implement data loading from user provided string directly for test
> ------------------------------------------------------------------
>
> Key: HIVE-3227
> URL: https://issues.apache.org/jira/browse/HIVE-3227
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor, Testing Infrastructure
> Affects Versions: 0.10.0
> Reporter: Navis
> Assignee: Navis
> Priority: Trivial
>
> {code}
> load data instream 'key value\nkey2 value2' into table test;
> {code}
> This will make test easier and also can reduce test time. For example,
> {code}
> -- 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;
> {code}
> last query is 4MR job. But can be replaced by
> {code}
> 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');
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
