[GitHub] [carbondata] ShreelekhyaG commented on a diff in pull request #4282: [WIP] Create MV fails with "LOCAL_DICTIONARY_INCLUDE/LOCAL _DICTIONARY_EXCLUDE column: does not exist in table. Please check the DDL" error

[GitBox <gi...@apache.org>]

ShreelekhyaG commented on code in PR #4282:
URL: https://github.com/apache/carbondata/pull/4282#discussion_r906978554


##########
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:
   done.



-- 
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: dev-unsubscribe@carbondata.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org