Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-3354

how to use filiters in datamaps

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.5.2
    • Fix Version/s: NONE
    • Component/s: core
    • Labels:
      None
    • Environment:
      apache carbon data 1.5.x

      Description

      Hi Team,

       

      We are doing a POC on apache carbon data so that we can verify if this database is capable of handling amount of data we are collecting form network devices.

       

      We are stuck on few of our datamap related activities and have below queries: 

       

      1. How to use timiebased filters while creating datamap.We tried a time based condition while creating a datamap but it didn't work.
      2. How to create a timeseries datamap with column which is having value of epoch time.Our query is like below:-  carbon.sql("CREATE DATAMAP test ON TABLE carbon_RT_test USING 'timeseries' DMPROPERTIES ('event_time'='endMs','minute_granularity'='1',) AS SELECT sum(inOctets) FROM carbon_RT_test GROUP BY inIfId")
      3. In above query endMs is having epoch time value.
      4. We got an error like below: "Timeseries event time is only supported on Timestamp column"
      5. Also we need to know if we can have a time granularity other then 1 like in above query, can we have minute_granularity='5*'.*

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              imsuyash suyash yadav
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: