[jira] [Commented] (CARBONDATA-3354) how to use filiters in datamaps

["Indhumathi (Jira)" <ji...@apache.org>]

    [ 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)