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

# · text · 4 lines · 4 code · 0 blank · 0 comment · 0 complexity · 2ab8006c9ff0c5fe15b59a8c1136a366 MD5 · raw file

  1. -- bucket column is the same as table sample
  2. -- No need for sample filter
  3. INSERT OVERWRITE TABLE dest1 SELECT s.*
  4. FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) s