[
https://issues.apache.org/jira/browse/HIVE-23069?focusedWorklogId=459168&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-459168
]
ASF GitHub Bot logged work on HIVE-23069:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 15/Jul/20 09:30
Start Date: 15/Jul/20 09:30
Worklog Time Spent: 10m
Work Description: pkumarsinha commented on a change in pull request #1225:
URL: https://github.com/apache/hive/pull/1225#discussion_r454918458
##########
File path:
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/TestReplicationScenariosExternalTables.java
##########
@@ -210,6 +210,66 @@ public void externalTableReplicationWithDefaultPaths()
throws Throwable {
assertExternalFileInfo(Arrays.asList("t2", "t3", "t4"),
tuple.dumpLocation, true);
}
+ @Test
+ public void externalTableReplicationWithDefaultPathsLazyCopy() throws
Throwable {
+ List<String> lazyCopyClause = Arrays.asList("'" +
HiveConf.ConfVars.REPL_DATA_COPY_LAZY.varname + "'='true'");
+ //creates external tables with partitions
+ WarehouseInstance.Tuple tuple = primary
+ .run("use " + primaryDbName)
+ .run("create external table t1 (id int)")
+ .run("insert into table t1 values (1)")
+ .run("insert into table t1 values (2)")
+ .run("create external table t2 (place string) partitioned by
(country string)")
+ .run("insert into table t2 partition(country='india') values
('bangalore')")
+ .run("insert into table t2 partition(country='us') values
('austin')")
+ .run("insert into table t2 partition(country='france') values
('paris')")
+ .dump(primaryDbName, lazyCopyClause);
+
+ // verify that the external table info is written correctly for bootstrap
+ assertExternalFileInfo(Arrays.asList("t1", "t2"), tuple.dumpLocation,
primaryDbName, false);
+
+
+
+ replica.load(replicatedDbName, primaryDbName, lazyCopyClause)
+ .run("use " + replicatedDbName)
+ .run("show tables like 't1'")
+ .verifyResult("t1")
+ .run("show tables like 't2'")
+ .verifyResult("t2")
+ .run("repl status " + replicatedDbName)
+ .verifyResult(tuple.lastReplicationId)
+ .run("select country from t2 where country = 'us'")
+ .verifyResult("us")
+ .run("select country from t2 where country = 'france'")
+ .verifyResult("france")
+ .run("show partitions t2").verifyResults(new String[]
{"country=france", "country=india", "country=us"});
Review comment:
Above we have queries to select data, isn't that what you are looking
for?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 459168)
Time Spent: 4h 10m (was: 4h)
> Memory efficient iterator should be used during replication.
> ------------------------------------------------------------
>
> Key: HIVE-23069
> URL: https://issues.apache.org/jira/browse/HIVE-23069
> Project: Hive
> Issue Type: Improvement
> Reporter: Pravin Sinha
> Assignee: Pravin Sinha
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-23069.01.patch, HIVE-23069.02.patch
>
> Time Spent: 4h 10m
> Remaining Estimate: 0h
>
> Currently the iterator used while copying table data is memory based. In case
> of a database with very large number of table/partitions, such iterator may
> cause HS2 process to go OOM.
> Also introduces a config option to run data copy tasks during repl load
> operation.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
