Last active
August 29, 2015 14:20
-
-
Save vicenteg/00d0b73c29898b0d86cd to your computer and use it in GitHub Desktop.
ES Marvel - add mapping for tweet timestamp
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELETE /tweets-2015-04-29 | |
POST tweets-2015-04-28 | |
PUT /tweets-2015-04-29 | |
{ | |
"settings": { | |
"analysis": { | |
"analyzer": { | |
"tweet_text_analyzer": { | |
"type": "english" | |
} | |
} | |
} | |
} | |
} | |
GET /tweets-*/_mapping | |
PUT /tweets-*/tweets/_mapping | |
{ | |
"tweets": { | |
"properties": { | |
"body": { | |
"properties": { | |
"coordinates": { | |
"properties": { | |
"coordinates": { | |
"type": "double" | |
}, | |
"type": { | |
"type": "string" | |
} | |
} | |
}, | |
"created_at": { | |
"type": "string" | |
}, | |
"entities": { | |
"properties": { | |
"hashtags": { | |
"properties": { | |
"indices": { | |
"type": "long" | |
}, | |
"text": { | |
"type": "string" | |
} | |
} | |
}, | |
"media": { | |
"properties": { | |
"display_url": { | |
"type": "string" | |
}, | |
"expanded_url": { | |
"type": "string" | |
}, | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"indices": { | |
"type": "long" | |
}, | |
"media_url": { | |
"type": "string" | |
}, | |
"media_url_https": { | |
"type": "string" | |
}, | |
"sizes": { | |
"properties": { | |
"large": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"medium": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"small": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"thumb": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
} | |
} | |
}, | |
"source_status_id": { | |
"type": "long" | |
}, | |
"source_status_id_str": { | |
"type": "string" | |
}, | |
"type": { | |
"type": "string" | |
}, | |
"url": { | |
"type": "string" | |
} | |
} | |
}, | |
"symbols": { | |
"properties": { | |
"indices": { | |
"type": "long" | |
}, | |
"text": { | |
"type": "string" | |
} | |
} | |
}, | |
"urls": { | |
"properties": { | |
"display_url": { | |
"type": "string" | |
}, | |
"expanded_url": { | |
"type": "string" | |
}, | |
"indices": { | |
"type": "long" | |
}, | |
"url": { | |
"type": "string" | |
} | |
} | |
}, | |
"user_mentions": { | |
"properties": { | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"indices": { | |
"type": "long" | |
}, | |
"name": { | |
"type": "string" | |
}, | |
"screen_name": { | |
"type": "string" | |
} | |
} | |
} | |
} | |
}, | |
"extended_entities": { | |
"properties": { | |
"media": { | |
"properties": { | |
"display_url": { | |
"type": "string" | |
}, | |
"expanded_url": { | |
"type": "string" | |
}, | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"indices": { | |
"type": "long" | |
}, | |
"media_url": { | |
"type": "string" | |
}, | |
"media_url_https": { | |
"type": "string" | |
}, | |
"sizes": { | |
"properties": { | |
"large": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"medium": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"small": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"thumb": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
} | |
} | |
}, | |
"source_status_id": { | |
"type": "long" | |
}, | |
"source_status_id_str": { | |
"type": "string" | |
}, | |
"type": { | |
"type": "string" | |
}, | |
"url": { | |
"type": "string" | |
} | |
} | |
} | |
} | |
}, | |
"favorite_count": { | |
"type": "long" | |
}, | |
"favorited": { | |
"type": "boolean" | |
}, | |
"filter_level": { | |
"type": "string" | |
}, | |
"geo": { | |
"properties": { | |
"coordinates": { | |
"type": "double" | |
}, | |
"type": { | |
"type": "string" | |
} | |
} | |
}, | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"in_reply_to_screen_name": { | |
"type": "string" | |
}, | |
"in_reply_to_status_id": { | |
"type": "long" | |
}, | |
"in_reply_to_status_id_str": { | |
"type": "string" | |
}, | |
"in_reply_to_user_id": { | |
"type": "long" | |
}, | |
"in_reply_to_user_id_str": { | |
"type": "string" | |
}, | |
"lang": { | |
"type": "string" | |
}, | |
"place": { | |
"properties": { | |
"attributes": { | |
"type": "object" | |
}, | |
"bounding_box": { | |
"properties": { | |
"coordinates": { | |
"type": "double" | |
}, | |
"type": { | |
"type": "string" | |
} | |
} | |
}, | |
"country": { | |
"type": "string" | |
}, | |
"country_code": { | |
"type": "string" | |
}, | |
"full_name": { | |
"type": "string" | |
}, | |
"id": { | |
"type": "string" | |
}, | |
"name": { | |
"type": "string" | |
}, | |
"place_type": { | |
"type": "string" | |
}, | |
"url": { | |
"type": "string" | |
} | |
} | |
}, | |
"possibly_sensitive": { | |
"type": "boolean" | |
}, | |
"retweet_count": { | |
"type": "long" | |
}, | |
"retweeted": { | |
"type": "boolean" | |
}, | |
"retweeted_status": { | |
"properties": { | |
"coordinates": { | |
"properties": { | |
"coordinates": { | |
"type": "double" | |
}, | |
"type": { | |
"type": "string" | |
} | |
} | |
}, | |
"created_at": { | |
"type": "string" | |
}, | |
"entities": { | |
"properties": { | |
"hashtags": { | |
"properties": { | |
"indices": { | |
"type": "long" | |
}, | |
"text": { | |
"type": "string" | |
} | |
} | |
}, | |
"media": { | |
"properties": { | |
"display_url": { | |
"type": "string" | |
}, | |
"expanded_url": { | |
"type": "string" | |
}, | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"indices": { | |
"type": "long" | |
}, | |
"media_url": { | |
"type": "string" | |
}, | |
"media_url_https": { | |
"type": "string" | |
}, | |
"sizes": { | |
"properties": { | |
"large": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"medium": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"small": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"thumb": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
} | |
} | |
}, | |
"source_status_id": { | |
"type": "long" | |
}, | |
"source_status_id_str": { | |
"type": "string" | |
}, | |
"type": { | |
"type": "string" | |
}, | |
"url": { | |
"type": "string" | |
} | |
} | |
}, | |
"symbols": { | |
"properties": { | |
"indices": { | |
"type": "long" | |
}, | |
"text": { | |
"type": "string" | |
} | |
} | |
}, | |
"urls": { | |
"properties": { | |
"display_url": { | |
"type": "string" | |
}, | |
"expanded_url": { | |
"type": "string" | |
}, | |
"indices": { | |
"type": "long" | |
}, | |
"url": { | |
"type": "string" | |
} | |
} | |
}, | |
"user_mentions": { | |
"properties": { | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"indices": { | |
"type": "long" | |
}, | |
"name": { | |
"type": "string" | |
}, | |
"screen_name": { | |
"type": "string" | |
} | |
} | |
} | |
} | |
}, | |
"extended_entities": { | |
"properties": { | |
"media": { | |
"properties": { | |
"display_url": { | |
"type": "string" | |
}, | |
"expanded_url": { | |
"type": "string" | |
}, | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"indices": { | |
"type": "long" | |
}, | |
"media_url": { | |
"type": "string" | |
}, | |
"media_url_https": { | |
"type": "string" | |
}, | |
"sizes": { | |
"properties": { | |
"large": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"medium": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"small": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
}, | |
"thumb": { | |
"properties": { | |
"h": { | |
"type": "long" | |
}, | |
"resize": { | |
"type": "string" | |
}, | |
"w": { | |
"type": "long" | |
} | |
} | |
} | |
} | |
}, | |
"source_status_id": { | |
"type": "long" | |
}, | |
"source_status_id_str": { | |
"type": "string" | |
}, | |
"type": { | |
"type": "string" | |
}, | |
"url": { | |
"type": "string" | |
} | |
} | |
} | |
} | |
}, | |
"favorite_count": { | |
"type": "long" | |
}, | |
"favorited": { | |
"type": "boolean" | |
}, | |
"filter_level": { | |
"type": "string" | |
}, | |
"geo": { | |
"properties": { | |
"coordinates": { | |
"type": "double" | |
}, | |
"type": { | |
"type": "string" | |
} | |
} | |
}, | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"in_reply_to_screen_name": { | |
"type": "string" | |
}, | |
"in_reply_to_status_id": { | |
"type": "long" | |
}, | |
"in_reply_to_status_id_str": { | |
"type": "string" | |
}, | |
"in_reply_to_user_id": { | |
"type": "long" | |
}, | |
"in_reply_to_user_id_str": { | |
"type": "string" | |
}, | |
"lang": { | |
"type": "string" | |
}, | |
"place": { | |
"properties": { | |
"attributes": { | |
"type": "object" | |
}, | |
"bounding_box": { | |
"properties": { | |
"coordinates": { | |
"type": "double" | |
}, | |
"type": { | |
"type": "string" | |
} | |
} | |
}, | |
"country": { | |
"type": "string" | |
}, | |
"country_code": { | |
"type": "string" | |
}, | |
"full_name": { | |
"type": "string" | |
}, | |
"id": { | |
"type": "string" | |
}, | |
"name": { | |
"type": "string" | |
}, | |
"place_type": { | |
"type": "string" | |
}, | |
"url": { | |
"type": "string" | |
} | |
} | |
}, | |
"possibly_sensitive": { | |
"type": "boolean" | |
}, | |
"retweet_count": { | |
"type": "long" | |
}, | |
"retweeted": { | |
"type": "boolean" | |
}, | |
"scopes": { | |
"properties": { | |
"followers": { | |
"type": "boolean" | |
} | |
} | |
}, | |
"source": { | |
"type": "string" | |
}, | |
"text": { | |
"type": "string" | |
}, | |
"truncated": { | |
"type": "boolean" | |
}, | |
"user": { | |
"properties": { | |
"contributors_enabled": { | |
"type": "boolean" | |
}, | |
"created_at": { | |
"type": "string" | |
}, | |
"default_profile": { | |
"type": "boolean" | |
}, | |
"default_profile_image": { | |
"type": "boolean" | |
}, | |
"description": { | |
"type": "string" | |
}, | |
"favourites_count": { | |
"type": "long" | |
}, | |
"followers_count": { | |
"type": "long" | |
}, | |
"friends_count": { | |
"type": "long" | |
}, | |
"geo_enabled": { | |
"type": "boolean" | |
}, | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"is_translator": { | |
"type": "boolean" | |
}, | |
"lang": { | |
"type": "string" | |
}, | |
"listed_count": { | |
"type": "long" | |
}, | |
"location": { | |
"type": "string" | |
}, | |
"name": { | |
"type": "string" | |
}, | |
"profile_background_color": { | |
"type": "string" | |
}, | |
"profile_background_image_url": { | |
"type": "string" | |
}, | |
"profile_background_image_url_https": { | |
"type": "string" | |
}, | |
"profile_background_tile": { | |
"type": "boolean" | |
}, | |
"profile_banner_url": { | |
"type": "string" | |
}, | |
"profile_image_url": { | |
"type": "string" | |
}, | |
"profile_image_url_https": { | |
"type": "string" | |
}, | |
"profile_link_color": { | |
"type": "string" | |
}, | |
"profile_sidebar_border_color": { | |
"type": "string" | |
}, | |
"profile_sidebar_fill_color": { | |
"type": "string" | |
}, | |
"profile_text_color": { | |
"type": "string" | |
}, | |
"profile_use_background_image": { | |
"type": "boolean" | |
}, | |
"protected": { | |
"type": "boolean" | |
}, | |
"screen_name": { | |
"type": "string" | |
}, | |
"statuses_count": { | |
"type": "long" | |
}, | |
"time_zone": { | |
"type": "string" | |
}, | |
"url": { | |
"type": "string" | |
}, | |
"utc_offset": { | |
"type": "long" | |
}, | |
"verified": { | |
"type": "boolean" | |
} | |
} | |
} | |
} | |
}, | |
"source": { | |
"type": "string" | |
}, | |
"text": { | |
"type": "string", "index": "not_analyzed" | |
}, | |
"timestamp_ms": { | |
"type": "string" | |
}, | |
"truncated": { | |
"type": "boolean" | |
}, | |
"user": { | |
"properties": { | |
"contributors_enabled": { | |
"type": "boolean" | |
}, | |
"created_at": { | |
"type": "string" | |
}, | |
"default_profile": { | |
"type": "boolean" | |
}, | |
"default_profile_image": { | |
"type": "boolean" | |
}, | |
"description": { | |
"type": "string" | |
}, | |
"favourites_count": { | |
"type": "long" | |
}, | |
"followers_count": { | |
"type": "long" | |
}, | |
"friends_count": { | |
"type": "long" | |
}, | |
"geo_enabled": { | |
"type": "boolean" | |
}, | |
"id": { | |
"type": "long" | |
}, | |
"id_str": { | |
"type": "string" | |
}, | |
"is_translator": { | |
"type": "boolean" | |
}, | |
"lang": { | |
"type": "string" | |
}, | |
"listed_count": { | |
"type": "long" | |
}, | |
"location": { | |
"type": "string" | |
}, | |
"name": { | |
"type": "string" | |
}, | |
"profile_background_color": { | |
"type": "string" | |
}, | |
"profile_background_image_url": { | |
"type": "string" | |
}, | |
"profile_background_image_url_https": { | |
"type": "string" | |
}, | |
"profile_background_tile": { | |
"type": "boolean" | |
}, | |
"profile_banner_url": { | |
"type": "string" | |
}, | |
"profile_image_url": { | |
"type": "string" | |
}, | |
"profile_image_url_https": { | |
"type": "string" | |
}, | |
"profile_link_color": { | |
"type": "string" | |
}, | |
"profile_sidebar_border_color": { | |
"type": "string" | |
}, | |
"profile_sidebar_fill_color": { | |
"type": "string" | |
}, | |
"profile_text_color": { | |
"type": "string" | |
}, | |
"profile_use_background_image": { | |
"type": "boolean" | |
}, | |
"protected": { | |
"type": "boolean" | |
}, | |
"screen_name": { | |
"type": "string" | |
}, | |
"statuses_count": { | |
"type": "long" | |
}, | |
"time_zone": { | |
"type": "string" | |
}, | |
"url": { | |
"type": "string" | |
}, | |
"utc_offset": { | |
"type": "long" | |
}, | |
"verified": { | |
"type": "boolean" | |
} | |
} | |
} | |
} | |
}, | |
"timestamp": { | |
"type": "date" | |
} | |
} | |
} | |
} | |
PUT /tweets-*/tweet/_mapping | |
{ | |
"tweet": { | |
"properties": { | |
"body": { | |
"properties": { | |
"created_at": { | |
"type": "date", | |
"format": "EE MMM d HH:mm:ss Z yyyy" | |
} | |
}, | |
"timestamp": { | |
"type": "date" | |
} | |
} | |
} | |
} | |
} | |
DELETE /tweets-*/tweet/_mapping | |
PUT /tweets-2015-04-28 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment