Getting started with DSQL maps
Create a simple DSQL map and test it with sample data.
Before you begin
- You have created an input and an output structure. You can use the JSON samples below to create your structures.
- You have set the Map Lines preference in to All Elements.
About this task
{
"store":"Bikes and Scoots",
"address":{
"street":"47 High St",
"city":"Linlithgow",
"zip":"75858",
"phone":"713 844445"
},
"categories":[
{
"category":"bicycles",
"items":[
{
"make":"MBIKE",
"description":"27.5 inch electric mountain bike",
"color":"blue",
"price":899.99
},
{
"make":"EBIKE",
"description":"Electric hybrid bike",
"color":"grey/green",
"price":999.99
},
{
"make":"WBIKE",
"description":"Women's road bike",
"color":"white",
"price":299.99
}
]
},
{
"category":"scooters",
"items":[
{
"make":"ESCOOT",
"description":"Camou electric scooter",
"color":"black",
"price":749
},
{
"make":"EVSCOOT",
"description":"Folding electric velocity+ scooter",
"color":"black",
"price":599.99
},
{
"make":"KSCOOT",
"description":"24 volt kid scooter",
"color":"white",
"price":299.99
}
]
}
]
}The output structure looks like this:
{
"items":[
{
"make":"",
"description":"",
"price":""
}
]
}