usql icon indicating copy to clipboard operation
usql copied to clipboard

Never finished compilation

Open hodzanassredin opened this issue 8 years ago • 0 comments

I have a simple script, but compilation could not be finished.

USE DATABASE master;
USE SCHEMA dbo;
@mix = 
    EXTRACT date DateTime,
            time long,
            eventName string,
            distinct_id string,
            app string
	FROM "/mixpanel/statuses/{date:yyyy}/{date:MM}/{date:dd}/{app:*}.csv" 
	USING Extractors.Csv(quoting:false, skipFirstNRows : 1);

OUTPUT @mix TO "/export/mix_report.csv" USING Outputters.Csv(outputHeader: true);

Problem is in line

FROM "/mixpanel/statuses/{date:yyyy}/{date:MM}/{date:dd}/{app:*}.csv" if i replace it by FROM "/mixpanel/statuses/{*}/{*}/{*}/{*}.csv" then it starts to work.

hodzanassredin avatar May 11 '17 09:05 hodzanassredin