Rules for Using SELECT AS JSON - Analytics Database - Teradata Vantage
SQL Data Manipulation Language
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2025-04-02
- dita:mapPath
- pon1628111750298.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- esx1472246586715
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- 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 together 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.