Syntax

BSON_INPUT_STREAM_TO_ARRAY(<input>)

Examples

Note: The following examples explicitly cast string to BSON for clarity. Similarly, the output is cast to JSON.

• Convert a BSON array:

  SQL

  Copy

  SELECT table_col:>JSON AS Result
  FROM TABLE(BSON_INPUT_STREAM_TO_ARRAY('[{"a":1},{"b":2},{"c":3},{"d":4}]':>BSON));

  +---------+
  | Result  |
  +---------+
  | {"a":1} |
  | {"b":2} |
  | {"c":3} |
  | {"d":4} |
  +---------+

  SQL

  Copy

  SELECT table_col:>JSON AS Result
  FROM TABLE(BSON_INPUT_STREAM_TO_ARRAY('[{"a":1,"b":"abcdef","c":null},{"b":2,"e":{"f":{"g":[]}}},{"c":3},{}]':>JSON:>BSON));

  +-------------------------------+
  | Result                        |
  +-------------------------------+
  | {"a":1,"b":"abcdef","c":null} |
  | {"b":2,"e":{"f":{"g":[]}}}    |
  | {"c":3}                       |
  | {}                            |
  +-------------------------------+

• Convert concatenated documents:

  SQL

  Copy

  SELECT table_col:>JSON AS Result
  FROM TABLE(BSON_INPUT_STREAM_TO_ARRAY(x'0C00000010610001000000000C00000010620002000000000C00000010630003000000000C0000001064000400000000'))
  AS Result;

  +---------+
  | Result  |
  +---------+
  | {"a":1} |
  | {"b":2} |
  | {"c":3} |
  | {"d":4} |
  +---------+

  where, x'0C00000010610001000000000C00000010620002000000000C00000010630003000000000C0000001064000400000000' is a hex literal that is formed by concatenating the following BSON documents:

  Document	Hex Representation
  {"a":1}	0C0000001061000100000000
  {"b":2}	0C0000001062000200000000
  {"c":3}	0C0000001063000300000000
  {"d":4}	0C0000001064000400000000