/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/positive/groupby5.q

# · text · 4 lines · 3 code · 1 blank · 0 comment · 0 complexity · 610840a165bfd3d41ea2f6c9387b5045 MD5 · raw file 

    

  1. SELECT src.key, sum(substr(src.value,5)) 
    2. 

  2. FROM src
    3. 

  3. GROUP BY src.key
    4.