WRITE_NOS (
ON { [ database_name.]table_name | (subquery) }
[ PARTITION BY column_name [ ,...] ORDER BY column_name [ ,...] |
HASH BY column_name [ ,...] LOCAL ORDER BY column_name [ ,...] |
LOCAL ORDER BY column_name [ ,...]]
USING
LOCATION ('external_storage_path')
[ AUTHORIZATION ( { [DatabaseName.]AuthorizationObjectName |
'{"Access_ID":"access_id", "Access_Key":"secret_key", "Session_Token":"session_token"}' } ) ]
STOREDAS ({ 'PARQUET' | 'CSV' })
[ NAMING ({ 'DISCRETE' | 'RANGE' }) ]
[ HEADER ( { 'TRUE' | 'FALSE' } ) ]
[ ROWFORMAT ( 'encoding_format' ) ]
[ MANIFESTFILE ('manifest_name') ]
[ MANIFESTONLY ('TRUE') ]
[ OVERWRITE ({ 'TRUE' | 'FALSE' }) ]
[ INCLUDE_ORDERING ({ 'TRUE' | 'FALSE' }) ]
[ INCLUDE_HASHBY ({ 'TRUE' | 'FALSE' }) ]
[ MAXOBJECTSIZE ('max_object_size') ]
[ COMPRESSION ( { 'GZIP' | 'SNAPPY' } ) ]
)
You must type the bold curly braces shown in '{"Access_ID":"access_id", "Access_Key":"secret_key", "Session_Token":"session_token"}'. Those curly braces are part of the READ_NOS statement.