CREATE EXTERNAL TABLE (Transact-SQL) - SQL Server
docs.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&preserve-view=true&tabs=dedicated
1 Users
0 Comments
5 Highlights
0 Notes
Tags
Top Highlights
'dirty' if it actual data types or the number of columns don't match the column definitions of the external table.
change reject values, PolyBase uses default values.
s is stored as additional metadata when you create an external table with CREATE EXTERNAL TABLE statement. When a future SELECT statement or SELECT INTO SELECT statement selects data from the external table, PolyBase will use the reject options to determine the number or percentage of rows that can be rejected before the actual query fails
turn (partial) results until the reject threshold is exceeded. It then fails with the appropriate error message.
REJECT_VALUE is a literal value, not a percentage. The PolyBase query will fail when the number of rejected rows exceeds reject_value.
Ready to highlight and find good content?
Glasp is a social web highlighter that people can highlight and organize quotes and thoughts from the web, and access other like-minded people’s learning.