none
File Name Length issue

    Question

  • I keep getting an error when submitting a job:

    Description Input 1 (adl://xxx.azuredatalakestore.net/Weather/Wunderground/History/WunderGround_history_20161030_IA_Des Moines_20161104_143737.json[0]) is unavailable. Could not read adl://xxx.azuredatalakestore.net/Weather/Wunderground/History/WunderGround_history_20161030_IA_Des Moines_20161104_143737.json. Error: I/O error (read)

    Resolution

    Details

    Error JM_PrimaryInputsUnavailable

    Message Job inputs are unavailable.

    Job Url https://xxx.azuredatalakeanalytics.net/jobs/fc8f01de-3e7f-4c0f-9e97-ba318a4d9f4b?api-version=2015-11-01-preview

    My USQL is:

    REFERENCE ASSEMBLY [Newtonsoft.Json];
    REFERENCE ASSEMBLY [Microsoft.Analytics.Samples.Formats]; 
    DECLARE @file string = 
    "/Weather/Wunderground/History/WunderGround_history_20161030_IA_Des Moines_20161104_143737.json";
    DECLARE @output string 
    = "/Weather/Wunderground/Output/DumpFile.csv";
    @json =
    	EXTRACT response string
    	, history string
    	FROM @file
      USING new Microsoft.Analytics.Samples.Formats.Json.JsonExtractor();
    
    @query = SELECT
    	response, history
    	FROM @json;
    	
    OUTPUT @query
    TO @output
    USING Outputters.Csv();
    

    If I replace the file name with "t.json", the query works.

    Is there a problem with the file name length?


    Russel Loski, MCSE Data Platform/Business Intelligence Twitter: @sqlmovers; blog: www.sqlmovers.com

    Monday, November 7, 2016 6:12 PM

Answers

  • Found the error.  My file name had a space in it between Des and Moines.  I remove the space and the query works.

    "/Weather/Wunderground/History/WunderGround_history_20161030_IA_Des Moines_20161104_143737.json";



    Russel Loski, MCSE Data Platform/Business Intelligence Twitter: @sqlmovers; blog: www.sqlmovers.com

    • Marked as answer by Russ Loski Tuesday, November 8, 2016 5:24 PM
    Tuesday, November 8, 2016 5:24 PM