Hi Jeff, elasticsearch doesn’t have “timestamp” type. elasticsearch have only date type. http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-core-types.html#date
And you should use “transform” instead of “copy_to”. http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-transform.html Example mapping using transform: { "mappings": { "utilization": { "dynamic": "false", "transform" : { "script" : "if (!ctx._source['cst_observed'].empty && !ctx._source['date_observed'].empty) ctx._source['my_ts'] = ctx._source['cst_observed'] + ' '+ ctx._source['date_observed']", "lang": "groovy" }, "properties": { "cst_observed": {"type": "string"} ,"date_observed": {"type": "string"} ,"inbound_mbps": {"type": "float"} ,"inbound_percent": {"type": "float"} ,"ip_addr": {"type": "ip"} ,"outbound_mbps": {"type": "float"} ,"outbound_percent": {"type": "float"} ,"provider": {"type": "string"} ,"reporting_begin": {"type": "date"} ,"reporting_end": {"type": "date"} ,"speed": {"type": "float"} ,"my_ts":{"type": "date", "format": "HH:mm:ss mm/dd/yyyy"} } } } } That is only example. I hope that those help you out. ------------ Jun Ohtani [email protected] blog : http://blog.johtani.info twitter : http://twitter.com/johtani > 2014/11/18 13:40、Jeff Fogarty <[email protected]> のメール： > > I'm looking to analyze network utilization data supplied by our vendor. One > challenge is the observed data and time are in separate fields. > > I like to combine the fields date_observed and cst_observed into a date/time > field. Is this possible? > > Below defines that mapping I've come up with, I get a few errors with the > below > > No handler for type [timestamp] declared on fields > my_ts > cst_observed > > { "mappings": { > "utilization": { > "dynamic": "false", "properties": { > "cst_observed": {"type": "timestamp", "copy_to": "my_ts"} > ,"date_observed": {"type": "date", "copy_to": "my_ts"} > ,"inbound_mbps": {"type": "float"} > ,"inbound_percent": {"type": "float"} > ,"ip_addr": {"type": "ip"} > ,"outbound_mbps": {"type": "float"} > ,"outbound_percent": {"type": "float"} > ,"provider": {"type": "string"} > ,"reporting_begin": {"type": "date"} > ,"reporting_end": {"type": "date"} > ,"speed": {"type": "float"} > ,"my_ts":{"type": "timestamp", "format": "HH:mm:ss > mm/dd/yyyy"} > } > } > } > }' > > Thanks, > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/0109138a-4f04-4f66-9ab5-2f7f85fc9a77%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/B58F56BA-643C-4B75-98E3-35DB5282FE73%40gmail.com. For more options, visit https://groups.google.com/d/optout.
