search

byzer-org / byzer-lang

Byzer (former MLSQL): A low-code open-source programming language for data pipeline, analytics and AI.
https://www.byzer.org
Apache License 2.0
1.84k stars 547 forks source link

The query result ui will miss the column #6

Closed allwefantasy closed 6 years ago

allwefantasy commented 8 years ago

When the query result is following:

[
  {
    "ac": "block"
  },
  {
    "ac": "gslb"
  },
  {
    "ac": "time",
    "pt": 14
  },
  {
    "ac": "play"
  },
  {
    "ac": "block"
  },
  {
    "ac": "play"
  },
  {
    "ac": "end"
  },
  {
    "ac": "time",
    "pt": 5
  },
  {
    "ac": "init"
  },
  {
    "ac": "init"
  },
  {
    "ac": "time",
    "pt": 8
  },
  {
    "ac": "end"
  },
  {
    "ac": "gslb"
  },
  {
    "ac": "block"
  },
  {
    "ac": "gslb"
  },
  {
    "ac": "init"
  },
  {
    "ac": "block"
  },
  {
    "ac": "end"
  },
  {
    "ac": "time",
    "pt": 0
  }
]

The query result ui will miss the pt column.

allwefantasy commented 8 years ago

It looks like this issue is caused by spark df.toJSON function. When converting row to json, null value will be ignored.