Support for Cassandra Duration type

[RyanQuey]

Describe the feature: Support for duration data type
Currently, unless I am mistaken there does not seem to be support for Cassandra's duration data type. When I try to create an ES index for my existing C* table of type duration, I get the following error:

{"error":{
  "root_cause": [{"type":"mapper_parsing_exception","reason":"Failed to execute query:null : Existing column [duration] type [duration] mismatch with inferred type [text]"}],
  "type":"mapper_parsing_exception",
  "reason":"Failed to execute query:null : Existing column [duration] type [duration] mismatch with inferred type [text]",
  "caused_by": {"type":"configuration_exception","reason":"Existing column [duration] type [duration] mismatch with inferred type [text]"}},
  "status":400
}

Furthermore, the duration type is not mentioned in Elassandra's docs related to type mapping.

It would be nice to have support for this if possible, though I'm not sure how it would be implemented exactly

[vroyer]

Cassandra duration is not supported, as far as I know, there is not corresponding types in Lucene for that.

…

On 29 Jun 2020, at 09:13, Ryan Quey ***@***.***> wrote: Describe the feature: Support for duration data type Currently, unless I am mistaken there does not seem to be support for Cassandra's duration data type <https://cassandra.apache.org/doc/3.11/cql/types.html#working-with-durations>. When I try to create an ES index for my existing C* table of type duration, I get the following error: {"error":{ "root_cause": [{"type":"mapper_parsing_exception","reason":"Failed to execute query:null : Existing column [duration] type [duration] mismatch with inferred type [text]"}], "type":"mapper_parsing_exception", "reason":"Failed to execute query:null : Existing column [duration] type [duration] mismatch with inferred type [text]", "caused_by": {"type":"configuration_exception","reason":"Existing column [duration] type [duration] mismatch with inferred type [text]"}}, "status":400 } Furthermore, the duration type is not mentioned in Elassandra's docs related to type mapping <https://elassandra.readthedocs.io/en/latest/mapping.html#type-mapping>. It would be nice to have support for this if possible, though I'm not sure how it would be implemented exactly — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#355>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACOMPGJ265U3DIJDWLVXBJ3RZA5IJANCNFSM4OK7JGJA>.

[RyanQuey]

Ok that makes sense. Is there a recommended best practice then for handling Cassandra durations? Or is there a way to convert one into an integer (probably integer in milliseconds or nanoseconds) or something like that?

[vroyer]

Yes, an integer or a long (bigint in Cassandra)...

…

On 29 Jun 2020, at 21:00, Ryan Quey ***@***.***> wrote: Ok that makes sense. Is there a recommended best practice then for handling Cassandra durations? Or is there a way to convert one into an integer (probably integer in milliseconds or nanoseconds) or something like that? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#355 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACOMPGLDIOV2C5NBYIGQTITRZDQEHANCNFSM4OK7JGJA>.