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'


---

Reply via email to