Indhumathi27 commented on code in PR #4282:
URL: https://github.com/apache/carbondata/pull/4282#discussion_r905890119
##########
integration/spark/src/test/scala/org/apache/carbondata/view/rewrite/MVCreateTestCase.scala:
##########
@@ -1556,6 +1557,35 @@ class MVCreateTestCase extends QueryTest with
BeforeAndAfterAll {
assert(TestUtil.verifyMVHit(df.queryExecution.optimizedPlan, "decimal_mv"))
}
+ test("test create MV after alter add column, drop table and refresh") {
+ sql("drop table if exists source1")
+ sql("CREATE table source1 (empno int, empname String, " +
+ "designation String, doj Timestamp, workgroupcategory int, " +
+ "workgroupcategoryname String, deptno int, deptname String,
projectcode int, " +
+ "projectjoindate Timestamp, projectenddate Timestamp, attendance int,
" +
+ "utilization int,salary int) STORED AS CARBONDATA")
+ sql(s"LOAD DATA LOCAL INPATH '$resourcesPath/data.csv' INTO " +
+ "TABLE source1 OPTIONS('DELIMITER'=',', 'QUOTECHAR'='\"', " +
+ "'BAD_RECORDS_LOGGER_ENABLE'='FALSE', 'BAD_RECORDS_ACTION'='FORCE')")
+ sql("alter table source1 add columns(a int)")
Review Comment:
Please add validations to check if MV is inheriting from main table after
ADD column with TBLPROPERTIES
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
