Are there something like SELECT IF EXISTS...Funktion in Dremio

[igreg]

I’m trying to do the same and Dremio shows an error: “Unable to find the referenced field: [product.details.price].” Below is a related thread. Looks like COALESCE and CASE can check if a field is null but not that the field exists. Is there an IF Exists type function in dremio?

Query to select an elasticsearch field which is not part of ES mapping

I’m querying an elasticsearch index and extracting a field from a JSON tructure (product.details.price) for which there is no corresponding elasticsearch mapping. i.e The field uses elasticsearch dynamic mapping. In addition this field value can also be null. Below is an example: In elasticsearch: { “_index”: “myIndex”, “_type”: “data”, “_id”: “myIndex_20180925141725_5524_1_000000070”, “_score”: 1.0, “_source”: { “product”: { “details”: { “price”: null } } } } Dremio query: SELEC…