deniskuzZ commented on a change in pull request #2413:
URL: https://github.com/apache/hive/pull/2413#discussion_r657937252
##########
File path:
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/parse/TestReplicationScenariosAcidTables.java
##########
@@ -176,6 +177,41 @@ public void
testReplOperationsNotCapturedInNotificationLog() throws Throwable {
assert lastEventId == currentEventId;
}
+ @Test
+ public void testReadOperationsNotCapturedInNotificationLog() throws
Throwable {
+ //Perform empty bootstrap dump and load
+ String dbName = testName.getMethodName();
+ String replDbName = "replicated_" + testName.getMethodName();
+ try {
+ primary.run("CREATE DATABASE " + dbName + " WITH DBPROPERTIES ( '" +
+ SOURCE_OF_REPLICATION + "' = '1,2,3')");
+ primary.hiveConf.set("hive.txn.readonly.enabled", "true");
+ primary.run("CREATE TABLE " + dbName + ".t1 (id int)");
+ primary.dump(dbName);
+ replica.run("REPL LOAD " + dbName + " INTO " + replDbName);
+ //Perform empty incremental dump and load so that all db level
properties are altered.
+ primary.dump(dbName);
+ replica.run("REPL LOAD " + dbName + " INTO " + replDbName);
+ primary.run("INSERT INTO " + dbName + ".t1 VALUES(1)");
+ long lastEventId = primary.getCurrentNotificationEventId().getEventId();
+ primary.run("USE " + dbName);
+ primary.run("DESCRIBE DATABASE " + dbName);
+ primary.run("DESCRIBE "+ dbName + ".t1");
+ primary.run("SELECT * FROM " + dbName + ".t1");
+ primary.run("SHOW TABLES " + dbName);
+ primary.run("SHOW TABLE EXTENDED LIKE 't1'");
+ primary.run("SHOW TBLPROPERTIES t1");
+ primary.run("EXPLAIN SELECT * from " + dbName + ".t1");
+ primary.run("SHOW LOCKS");
+ primary.run("EXPLAIN SHOW LOCKS");
Review comment:
Could you please add test case for 'EXPLAIN LOCKS <query>' that is
widely used?
```
EXPLAIN LOCKS UPDATE target SET b = 1 WHERE p IN (SELECT t.q1 FROM source t
WHERE t.a1=5)'
```
--
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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
