Skip to content

Instantly share code, notes, and snippets.

@jccorrea

jccorrea/gist:dede5d5b7ae68532dee6b8472d935da7

Created December 23, 2016 12:20
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 jccorrea/dede5d5b7ae68532dee6b8472d935da7 to your computer and use it in GitHub Desktop.
Save jccorrea/dede5d5b7ae68532dee6b8472d935da7 to your computer and use it in GitHub Desktop.
Download ZIP
hive- weekofyear
Raw
gistfile1.txt
--com substr de data
select dt_referencia , weekofyear(regexp_replace(substr(dt_referencia,1,10),'/','-') )from gvt.gvt_lis_stg limit 10;
-- sem substr
select dt_referencia , weekofyear(regexp_replace(dt_referencia,'/','-') )from gvt.gvt_lis_stg limit 10;
# dummy
create table dual as select 1 as X ;
Select '23/12/2016' , weekofyear(regexp_replace('23/12/2016','/','-') )from DUAL ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment