Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

[JSON SUPPORT] Select nested field return exception in JDBC format #369

Closed
penghuo opened this issue Feb 18, 2020 · 0 comments
Closed

[JSON SUPPORT] Select nested field return exception in JDBC format #369

penghuo opened this issue Feb 18, 2020 · 0 comments
Labels
bug Something isn't working JSON-SUPPORT-partiql

Comments

@penghuo
Copy link
Contributor

penghuo commented Feb 18, 2020

Issue

Test Data

PUT /customer/_doc/1
{
  "name": "John Doe",
  "address": {
    "city": "seattle",
    "state": "wa",
    "street": {
      "zip": 98004
    }
  }
}

Query

GET _opendistro/_sql/
{
  "query": "SELECT address.street.zip FROM customer"
}

Result

{
  "error": {
    "reason": "There was internal problem at backend",
    "details": "",
    "type": "NullPointerException"
  },
  "status": 500
}

Expectation

{
  "schema": [{
    "name": "address.city.zip",
    "type": "integer"
  }],
  "total": 1,
  "datarows": [[98004]],
  "size": 1,
  "status": 200
}
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working JSON-SUPPORT-partiql
Projects
None yet
Development

No branches or pull requests

2 participants