[
https://issues.apache.org/jira/browse/CARBONDATA-3354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17218178#comment-17218178
]
Akash R Nilugal edited comment on CARBONDATA-3354 at 10/21/20, 8:06 AM:
------------------------------------------------------------------------
Hi [~imsuyash]
Sorry for late reply. Now carbondata has good improved features in latest
version. So you can check our documentation and try your scenarios, any doubt
you can directly ask in slack channel as all dev members are present there.
https://join.slack.com/t/carbondataworkspace/shared_invite/zt-g8sv1g92-pr3GTvjrW5H9DVvNl6H2dg
Also, the above error, is valid one, as we support timeseries on time columns.
Also in our latest version, we should all the granularities from year to
second. You can refer here
https://github.com/apache/carbondata/blob/master/docs/mv-guide.md#time-series-support
Thanks
was (Author: akashrn5):
Hi [~imsuyash]
Sorry for late reply. Now carbondata has good improved features in latest
version. So you can check our documentation and try your scenarios, any doubt
you can directly ask in slack channel as all dev members are present there.
https://join.slack.com/t/carbondataworkspace/shared_invite/zt-g8sv1g92-pr3GTvjrW5H9DVvNl6H2dg
Also, the above error, is valid one, as we support timeseries on time columns.
Thanks
> 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)
