[ https://issues.apache.org/jira/browse/CARBONDATA-3354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17379642#comment-17379642 ]
Indhumathi commented on CARBONDATA-3354: ---------------------------------------- @[~imsuyash] Hope, the information provided above by Akash has clarified your doubts. Closing this JIRA, For further doubts, you can contact us through carbondata slack channel. [https://join.slack.com/t/carbondataworkspace/shared_invite/zt-g8sv1g92-pr3GTvjrW5H9DVvNl6H2dg] > how to use filiters in datamaps > ------------------------------- > > Key: CARBONDATA-3354 > URL: https://issues.apache.org/jira/browse/CARBONDATA-3354 > Project: CarbonData > Issue Type: Task > Components: core > Affects Versions: 1.5.2 > Environment: apache carbon data 1.5.x > Reporter: suyash yadav > Priority: Major > > 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: > > # How to use timiebased filters while creating datamap.We tried a time based > condition while creating a datamap but it didn't work. > # 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")* > # *In above query endMs is having epoch time value.* > # We got an error like below: "Timeseries event time is only supported on > Timestamp column" > # 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*'.* -- This message was sent by Atlassian Jira (v8.3.4#803005)