Skip to content

Instantly share code, notes, and snippets.

@velotiotech
Created January 19, 2022 07:41
Show Gist options
  • Save velotiotech/a8706fc0d51a6fc02d8760eb4a190338 to your computer and use it in GitHub Desktop.
Save velotiotech/a8706fc0d51a6fc02d8760eb4a190338 to your computer and use it in GitHub Desktop.
insert into sparkLog select
split(line, ' ')[0] as datedata,
split(line, ' ')[1] as timedata,
split(split(line, ': ')[0],' ')[3] as component,
split(line, ': ')[1] as action
from log ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment