Database Reference
In-Depth Information
Table 10.4
External Table Extended Properties
PDW Extended Property
Name
Definition
pdw_physical_name
Internal mapping name of the external
table exposed via
sys.pdw_table_mappings
.
pdw_distribution_type
Determines the table geometry, and in
this case identifies the table as an external
table. Value =
N'External'.
Other
values are
Distributed
and
Replicated
.
pdw_column_delimiter
Identifies the column delimiter used to
parse the file in Hadoop when imposing
structure.
pdw_string_delimiter
Identifies the string delimiter used to
parse the file in Hadoop when imposing
structure.
pdw_reject_type
States whether the query error threshold
will be measured by
VALUE
or by
PERCENTAGE
.
pdw_reject_value
Depending on the reject type, this will
either equal the
VALUE
or
PERCENTAGE
threshold value before a query will fail.
pdw_reject_sample_value
Defines the number of rows to attempt to
load before calculating the percentage of
rejected rows.
Contains the date format to be used when
parsing dates.
pdw_date_format
States how to process missing values
when importing data from HDFS.
0
=
USE NULL
.
1
= use the column default.
pdw_use_type_default
Holds the URI for the Hadoop location of
the data file in HDFS.
pdw_external_uri