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 -349	Record -348	Record -347	Record -346	Record -345	Record -344	Record -343	Record -342	Record -341	Record -340	Record -339	Record -338	Record -337	Record -336	Record -335	Record -334	Record -333	Record -332	Record -331	Record -330	Record -329	Record -328	Record -327	Record -326	Record -325	Record -324	Record -323	Record -322	Record -321	Record -320	Record -319	Record -318	Record -317	Record -316	Record -315	Record -314	Record -313	Record -312	Record -311	Record -310	Record -309	Record -308	Record -307	Record -306	Record -305	Record -304	Record -303	Record -302	Record -301	Record -300
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 -6 of 8 (367 total records)