[CARBONDATA-2083] Timeseries pre-aggregate table should support hour != 1 , others are the same

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.3.0
• Fix Version/s: 1.3.0
• Component/s: core, spark-integration
• Assignee: Unassigned
• Reporter: Bo Xu
• Created: 26/Jan/18 03:32
• Updated: 27/Jan/18 09:22
• Resolved: 27/Jan/18 08:53

Description

test case find the error:

  test("test timeseries create table 13: don't support hour=2") {
    try {
      sql(
        """create datamap agg1 on table mainTable using 'preaggregate'
          |DMPROPERTIES (
          |   'timeseries.eventTime'='dataTime',
          |   'timeseries.hierarchy'='hour=2')
          |as select dataTime, sum(age) from mainTable
          |group by dataTime
        """.stripMargin)
      assert(false)
    } catch {
      case e: MalformedCarbonCommandException =>
        assert(e.getMessage.contains("Unsupported Value for hierarchy:hour=2"))
    } finally {
      checkExistence(sql("show tables"), false, "maintable_agg1_hour")
    }
  }

Issue Links

• links to: GitHub Pull Request #1869