blob: 1c05e2181dfa90e472aba9ebcddd14b3471953e9 [file] [log] [blame]
--! qt:dataset:src
FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, DISTINCT substr(src.value,4,1) GROUP BY src.key