dialect_data_types - DATADA.AI Server

Tables

dialect_data_types 367 records

dialect	type_name	type_template	datada_type	supports_length	default_length	default_precision	default_scale	max_length	description
AVRO	null	null	STRING	0	null	null	null	null	Null value (no value)
AVRO	boolean	null	STRING	0	null	null	null	null	Boolean value
AVRO	int	null	STRING	0	null	null	null	null	32-bit signed integer
AVRO	long	null	STRING	0	null	null	null	null	64-bit signed integer
AVRO	float	null	STRING	0	null	null	null	null	32-bit IEEE floating-point
AVRO	double	null	STRING	0	null	null	null	null	64-bit IEEE floating-point
AVRO	bytes	null	STRING	0	null	null	null	null	Sequence of 8-bit unsigned bytes
AVRO	string	null	STRING	0	null	null	null	null	Unicode character sequence
AVRO	record	null	STRING	0	null	null	null	null	Named record with typed fields
AVRO	enum	null	STRING	0	null	null	null	null	Enumeration of symbols
AVRO	array	null	STRING	0	null	null	null	null	Ordered collection of items
AVRO	map	null	STRING	0	null	null	null	null	Map of string keys to values
AVRO	union	null	STRING	0	null	null	null	null	Union of schemas
AVRO	fixed	null	STRING	1	null	null	null	null	Fixed number of bytes
ORACLE	number	null	STRING	0	null	null	null	null	Variable-precision number
ORACLE	integer	null	STRING	0	null	null	null	null	Integer number
ORACLE	float	null	STRING	0	null	null	null	null	Floating-point number
ORACLE	binary_float	null	STRING	0	null	null	null	null	32-bit floating point
ORACLE	binary_double	null	STRING	0	null	null	null	null	64-bit floating point
ORACLE	char	null	STRING	0	null	null	null	null	null
ORACLE	nchar	null	STRING	0	null	null	null	null	Fixed-length Unicode string
ORACLE	varchar2	null	STRING	0	null	null	null	null	Variable-length string
ORACLE	nvarchar2	null	STRING	0	null	null	null	null	Variable-length Unicode string
ORACLE	varchar	null	STRING	0	null	null	null	null	Variable-length string (deprecated, use VARCHAR2)
ORACLE	clob	null	STRING	0	null	null	null	null	Character large object
ORACLE	nclob	null	STRING	0	null	null	null	null	Unicode character large object
ORACLE	long	null	STRING	0	null	null	null	null	Long character data (deprecated, use CLOB)
ORACLE	raw	null	STRING	0	null	null	null	null	Variable-length binary data
ORACLE	long_raw	null	STRING	0	null	null	null	null	Long binary data (deprecated, use BLOB)
ORACLE	blob	null	STRING	0	null	null	null	null	Binary large object
ORACLE	bfile	null	STRING	0	null	null	null	null	Binary file locator
ORACLE	date	null	STRING	0	null	null	null	null	Date and time
ORACLE	timestamp	null	STRING	0	null	null	null	null	Timestamp with fractional seconds
ORACLE	timestamp_with_time_zone	null	STRING	0	null	null	null	null	null
ORACLE	timestamp_with_local_time_zone	null	STRING	0	null	null	null	null	null
ORACLE	interval_year_to_month	null	STRING	0	null	null	null	null	null
ORACLE	interval_day_to_second	null	STRING	0	null	null	null	null	null
ORACLE	rowid	null	STRING	0	null	null	null	null	null
ORACLE	urowid	null	STRING	0	null	null	null	null	null
ORACLE	xmltype	null	STRING	0	null	null	null	null	null
PARQUET	boolean	null	STRING	0	null	null	null	null	Boolean value
PARQUET	int32	null	STRING	0	null	null	null	null	32-bit signed integer
PARQUET	int64	null	STRING	0	null	null	null	null	64-bit signed integer
PARQUET	int96	null	STRING	0	null	null	null	null	96-bit integer (legacy timestamp)
PARQUET	float	null	STRING	0	null	null	null	null	32-bit IEEE floating-point
PARQUET	double	null	STRING	0	null	null	null	null	64-bit IEEE floating-point
PARQUET	byte_array	null	STRING	0	null	null	null	null	Variable-length byte array
PARQUET	fixed_len_byte_array	null	STRING	1	null	null	null	null	Fixed-length byte array
PARQUET	string	null	STRING	0	null	null	null	null	UTF-8 encoded string
PARQUET	uuid	null	STRING	0	null	null	null	null	UUID (16-byte fixed length)

Attribute	Record -299	Record -298	Record -297	Record -296	Record -295	Record -294	Record -293	Record -292	Record -291	Record -290	Record -289	Record -288	Record -287	Record -286	Record -285	Record -284	Record -283	Record -282	Record -281	Record -280	Record -279	Record -278	Record -277	Record -276	Record -275	Record -274	Record -273	Record -272	Record -271	Record -270	Record -269	Record -268	Record -267	Record -266	Record -265	Record -264	Record -263	Record -262	Record -261	Record -260	Record -259	Record -258	Record -257	Record -256	Record -255	Record -254	Record -253	Record -252	Record -251	Record -250
dialect	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	AVRO	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	ORACLE	PARQUET	PARQUET	PARQUET	PARQUET	PARQUET	PARQUET	PARQUET	PARQUET	PARQUET	PARQUET
type_name	null	boolean	int	long	float	double	bytes	string	record	enum	array	map	union	fixed	number	integer	float	binary_float	binary_double	char	nchar	varchar2	nvarchar2	varchar	clob	nclob	long	raw	long_raw	blob	bfile	date	timestamp	timestamp_with_time_zone	timestamp_with_local_time_zone	interval_year_to_month	interval_day_to_second	rowid	urowid	xmltype	boolean	int32	int64	int96	float	double	byte_array	fixed_len_byte_array	string	uuid
type_template	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
datada_type	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING	STRING
is_default	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
supports_length	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0
supports_precision	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
supports_scale	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
default_length	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
default_precision	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
default_scale	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
max_length	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
description	Null value (no value)	Boolean value	32-bit signed integer	64-bit signed integer	32-bit IEEE floating-point	64-bit IEEE floating-point	Sequence of 8-bit unsigned bytes	Unicode character sequence	Named record with typed fields	Enumeration of symbols	Ordered collection of items	Map of string keys to values	Union of schemas	Fixed number of bytes	Variable-precision number	Integer number	Floating-point number	32-bit floating point	64-bit floating point	null	Fixed-length Unicode string	Variable-length string	Variable-length Unicode string	Variable-length string (deprecated, use VARCHAR2)	Character large object	Unicode character large object	Long character data (deprecated, use CLOB)	Variable-length binary data	Long binary data (deprecated, use BLOB)	Binary large object	Binary file locator	Date and time	Timestamp with fractional seconds	null	null	null	null	null	null	null	Boolean value	32-bit signed integer	64-bit signed integer	96-bit integer (legacy timestamp)	32-bit IEEE floating-point	64-bit IEEE floating-point	Variable-length byte array	Fixed-length byte array	UTF-8 encoded string	UUID (16-byte fixed length)

Page -5 of 8 (367 total records)