Skip to content

Instantly share code, notes, and snippets.

@velotiotech

velotiotech/hql_step_6.txt

Created January 19, 2022 07:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save velotiotech/a8706fc0d51a6fc02d8760eb4a190338 to your computer and use it in GitHub Desktop.
Save velotiotech/a8706fc0d51a6fc02d8760eb4a190338 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hql_step_6.txt
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