usql
usql copied to clipboard
Never finished compilation
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.