Sqoop data to non-default azure storage -


is possible import data sql database using sqoop different blob storage, other default hdinsight cluster blob storage?

even if set azure storage access "public blob", error message "container testcontainer in account nondefaultstorage.blob.core.windows.net not found, , can't create using anoynomous credentials."

this sqoop command running:

import  --connect jdbc:sqlserver://sqlservername;user=sqllogin;password=sqlpass;database=sqldbname  --table tablename  --target-dir wasb://testcontainer@nondefaultstorage.blob.core.windows.net/data/csv 

it shall work linked storage accounts, or public containers. public blob won't work because container data not available. more information on 3 access types, see https://azure.microsoft.com/en-us/documentation/articles/storage-manage-access-to-resources/#restrict-access-to-containers-and-blobs


Comments