One Index 2 data type join query

One Index 2 data type join query

# delete old index if exists
curl -XDELETE 'http://localhost:9200/productindex?pretty'

# Create new Index productindex
curl -XPUT 'http://localhost:9200/productindex?pretty' -d '{}'

# Insert data in productindex for offertype
curl -XPUT 'http://localhost:9200/productindex/offertype/1?pretty' -d '{"skuid": "1983001", "offer_id": "promo00001,promo00002,promo00003"}'
curl -XPUT 'http://localhost:9200/productindex/offertype/2?pretty' -d '{"skuid": "1983002", "offer_id": "promo00001,promo00002"}'
curl -XPUT 'http://localhost:9200/productindex/offertype/3?pretty&refresh=true' -d '{"skuid": "1983003", "offer_id": "promo00001,promo00003"}'

# Insert data in productindex for categorytype
curl -XPUT 'http://localhost:9200/productindex/categorytype/4?pretty' -d '{"skuid": "1983004", "category": "Mobile"}'
curl -XPUT 'http://localhost:9200/productindex/categorytype/5?pretty' -d '{"skuid": "1983005", "category": "Mobile"}'
curl -XPUT 'http://localhost:9200/productindex/categorytype/6?pretty&refresh=true' -d '{"skuid": "1983006", "category": "Mobile"}'