Github user xubo245 commented on a diff in the pull request:
https://github.com/apache/carbondata/pull/1878#discussion_r165807476
--- Diff:
integration/spark-common-test/src/test/scala/org/apache/carbondata/integration/spark/testsuite/preaggregate/TestPreAggCreateCommand.scala
---
@@ -270,6 +284,28 @@ class TestPreAggCreateCommand extends QueryTest with
BeforeAndAfterAll {
sql("DROP DATAMAP IF EXISTS agg0 ON TABLE maintable")
}
+ test("remove agg tables from show table command") {
+ sql("DROP TABLE IF EXISTS tbl_1")
+ sql("create table if not exists tbl_1(imei string,age int,mac string
,prodate timestamp,update timestamp,gamepoint double,contrid double) stored by
'carbondata' ")
+ sql("create datamap agg1 on table tbl_1 using 'preaggregate' as select
mac, sum(age) from tbl_1 group by mac")
+ sql("create table if not exists sparktable(imei string,age int,mac
string ,prodate timestamp,update timestamp,gamepoint double,contrid double) ")
+ checkExistence(sql("show tables"), false, "tbl_1_agg1")
+ checkExistence(sql("show tables"), true, "sparktable","tbl_1")
+ }
+
+
+ test("remove TimeSeries agg tables from show table command") {
+ sql("DROP TABLE IF EXISTS tbl_1")
+ sql("create table if not exists tbl_1(imei string,age int,mac string
,prodate timestamp,update timestamp,gamepoint double,contrid double) stored by
'carbondata' ")
+ sql(
+ "create datamap agg2 on table tbl_1 using 'preaggregate'
DMPROPERTIES ('timeseries" +
--- End diff --
we don't support create timeseries table like this :
'timeseries.eventTime'='prodate', 'timeseries.hierarchy'
---
