Elasticseach 6.5+ mapping and indexing data by Logstash from Sql Server

$30-250 USD

Completed

Posted

over 5 years ago

$30-250 USD

Paid on delivery

The job is defining mapping from following structure in elasticsearch 6.5+ version and create logstash script to index data to elasticseach in one-to-many join table as sctructure shown below. booking-index -- hotel ------hotel_id(int) ------name(string) ------images => [{id:1,url:"[login to view URL]"}] (array of image entity) (max 100 images) ------rooms => [{id:1,price:10.65,start:2019-01-17}] (array of room entity) (massive 1000s of records) -----------------(optional) room_prices => [{id:1,price:10.65,start:2019-01-17}] Acceptance citeria: 1) maapings containing following structure -images field should be nested array object -rooms field should be join relation for one-to-many and contains massive data 2)logstash script to index data from sql server to defined mapping 3)aggregation script to query and create facet 4) Sql schema will be provided

Elasticsearch

Project ID: 18697074

About the project

2 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@yuwtennis3

* My deliverables which I am assuming are: 1. elasticsearch index loaded with data 2. logstash configuration file 3. index template for the booking-index * Additional discussions after project started: 1. Would you be considering timebased index rotation for production? (e.g monthly, daily , etc) If yes, I would like to know the rotation period so that I could add it to the index name. 2. Do you have any thoughts about number of shards for elasticsearch? If yes, I would like to know the number of primary and replica shards so that I could set up for the index template. * Notes 1. I live in Japan so there might be delay with response to your any of the message. I appreciate if you could understand the situation. 2. I have a full time job during weekdays thus, if possible , I would like to work on your project on weekends.

$75 USD in 2 days

5.0

(3 reviews)

3.3

2 freelancers are bidding on average $148 USD for this job

@deytps86

Hello I am working in ELK stack for many years. I completed a few projects in Freelancer as well. I also work in Bigdata Hadoop technologies using Spark, Kafka, Cassandra, Hive Habse Mapr etc. Can we further talk on this?.. Thanks

$220 USD in 3 days