AS JSON Usage Notes - Teradata Vantage
Teradata® VantageCloud Lake
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata Vantage
- Published
- January 2023
- ft:locale
- en-US
- ft:lastEdition
- 2024-12-11
- dita:mapPath
- phg1621910019905.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- phg1621910019905
- The SELECT AS JSON statement composes column values into a text format JSON document. Binary formats such as BSON or UBJSON are not supported.
- You cannot specify SELECT AND CONSUME with SELECT AS JSON to compose JSON documents.
- If you specify TOP n or ORDER BY in the SELECT statement, you must explicitly specify the sorted fields because you cannot sort by the JSON column.