none
Extension-less files in Input Files

    Question

  • Are extension less files supported as input into a USQL query? The docs are a bit light on examples but I'm following the Input Files section from https://msdn.microsoft.com/en-us/library/azure/mt621294.aspx I can't seem to get the File_Name_Pattern right. 

    If my files are given extensions (i.e. filename.json) then then all is good and I can match all files with a wildcard pattern like:

    wasb://{containername}@{storageaccunt}.blob.core.windows.net/{*}.{*} or wasb://{containername}@{storageaccunt}.blob.core.windows.net/{*}.json

    However without the file extension wildcard I get 'A user operation has resulted in a store failure.':

    wasb://{containername}@{storageaccunt}.blob.core.windows.net/{*}

    Suffixing with a dot (.) gives no error but does not select any files:

    wasb://{containername}@{storageaccunt}.blob.core.windows.net/{*}.

    Anyone got more examples of file patterns to use with USQL?

    Thanks

    Monday, November 30, 2015 3:07 PM

Answers