You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "xubo245 (JIRA)" <ji...@apache.org> on 2018/01/27 09:03:00 UTC
[jira] [Closed] (CARBONDATA-2087) Order rule should keep consistent
for create datamap
[ https://issues.apache.org/jira/browse/CARBONDATA-2087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
xubo245 closed CARBONDATA-2087.
-------------------------------
Resolution: Won't Fix
no need to fix, because it will be changed.
> Order rule should keep consistent for create datamap
> ----------------------------------------------------
>
> Key: CARBONDATA-2087
> URL: https://issues.apache.org/jira/browse/CARBONDATA-2087
> Project: CarbonData
> Issue Type: Bug
> Components: core, spark-integration
> Affects Versions: 1.3.0
> Reporter: xubo245
> Priority: Minor
> Fix For: 1.3.0
>
>
> It success:
> {code:java}
> test("test timeseries create table 18: support day=1,year=1,month=1") {
> try {
> sql(
> """create datamap agg1 on table mainTable
> | using 'preaggregate'
> | DMPROPERTIES (
> | 'timeseries.eventTime'='dataTime',
> | 'timeseries.hierarchy'='day=1,year=1,month=1')
> | as select dataTime, sum(age) from mainTable
> | group by dataTime
> """.stripMargin)
> checkExistence(sql("show tables"), false, "maintable_agg1_hour")
> checkExistence(sql("show tables"), true, "maintable_agg1_day", "maintable_agg1_month", "maintable_agg1_year")
> } catch {
> case _: Exception =>
> assert(false)
> }
> }
> {code}
> but it fail:
> {code:java}
> test("test timeseries create table 21: don't support year=1,month=1") {
> try {
> sql(
> """create datamap agg1 on table mainTable
> |using 'preaggregate'
> |DMPROPERTIES (
> | 'timeseries.eventTime'='dataTime',
> | 'timeseries.hierarchy'='year=1,month=1')
> |as select dataTime, sum(age) from mainTable
> |group by dataTime""".stripMargin)
> assert(false)
> } catch {
> case e: MalformedCarbonCommandException =>
> assert(e.getMessage.contains("year=1,month=1 is in wrong order"))
> } finally {
> checkExistence(sql("show tables"), false, "maintable_agg1_year")
> }
> }
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)