| 失效链接处理 |
|
Teradata Vantage JSON Data Type PDF 下载
本站整理下载：
相关截图：
主要内容：
Overview
Teradata Vantage ™ is our flagship analytic platform offering, which evolved from our industry-leading
Teradata ® Database. Until references in content are updated to reflect this change, the term Teradata
Database is synonymous with Teradata Vantage.
Teradata NewSQL Engine is a core of Teradata Vantage, based on our best-in-class Teradata Database
processing capability. NewSQL refers to the ability to run advanced analytic functions beyond that of
standard SQL.
For information on data type mapping between NewSQL Engine and ML Engine, see Teradata Vantage ™
User Guide, B700-4002.
Teradata Vantage ™ JSON Data Type describes Teradata support for JSON data, including the JSON data
type and the functions and methods available for processing, shredding, and publishing JSON data.
Changes and Additions
Date Description
March 2019
Added the following information:
• Composing JSON data using the SELECT AS JSON statement. See JSON Composition
Using SELECT AS JSON.
• JSON shredding using the INSERT...JSON statement and the JSON AUTO COLUMN.
See JSON Shredding.
Updated the information about casting JSON dot notation expressions to other data types.
See About JSON Type Cast.
April 2018
Added information about the SET TRANSFORM GROUP FOR TYPE statement for
changing the active transform group in the current session. See Support for Multiple
Transform Groups.
November
2017
Changed cross-references from "Teradata JDBC Driver User Guide" to "Teradata JDBC
Driver Reference".
Introduction to the Teradata JSON Data Type
1
Teradata Vantage™ JSON Data Type, Release 16.20 6
Teradata Support for JSON
JSON (Javascript Object Notation) is a data interchange format, often used in web applications to transmit
data. JSON has been widely adopted by web application developers because compared to XML it is easier
to read and write for humans and easier to parse and generate for machines. JSON documents can be
stored and processed in Teradata Database.
Teradata Database can store JSON records as a JSON document or store JSON records in relational
format. Teradata Database provides the following support for JSON data:
• Ability to store JSON data in text and binary (BSON, UBJSON) storage formats.
• Methods, functions, and stored procedures that operate on the JSON data type, such as parsing and
validation.
• Shredding functionality that allows you to extract values from JSON documents up to 16MB in size and
store the extracted data in relational format.
• Publishing functionality that allows you to publish the results of SQL queries in JSON format.
• Schema-less or dynamic schema with the ability to add a new attribute without changing the schema.
Data with new attributes is immediately available for querying. Rows without the new column can be
filtered out.
• Use existing join indexing structures on extracted portions of the JSON data type.
• Apply advanced analytics to JSON data.
• Functionality to convert an ST_Geometry object into a GeoJSON value and a GeoJSON value into an
ST_Geometry object.
• Allows JSON data of varying maximum length and JSON data can be internally compressed.
• Collect statistics on extracted portions of the JSON data type.
• Use standard SQL to query JSON data.
• JSONPath provides simple traversal and regular expressions with wildcards to filter and navigate
complex JSON documents.
Requirements
To enable JSON support in Teradata Database, the DBS Control field EnableJSON must be set to TRUE.
This is the default setting. For more information, see Teradata Vantage ™ - Database Utilities, B035-1102.
Client Support for JSON
The following table describes the support provided by the Teradata Database client products for the JSON
data type.
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
