Skip to content

Instantly share code, notes, and snippets.

@nileema

nileema/gist:6529739

Created September 11, 2013 21:02
Show Gist options
  • Save nileema/6529739 to your computer and use it in GitHub Desktop.
Save nileema/6529739 to your computer and use it in GitHub Desktop.
Download ZIP
tablesample examples
Raw
gistfile1.txt
presto:default> select * from presto_test tablesample SYSTEM (10);
t_string | t_tinyint | t_smallint | t_int | t_bigint | t_float | t_double | t_map | t_boolean | t_ti
-------------------+-----------+------------+-------+----------+--------------------+----------+---------------------------+-----------+-----
sequencefile test | -54 | 203 | 204 | 205 | 206.10000610351562 | 207.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -53 | 204 | 205 | 206 | 207.10000610351562 | 208.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -52 | 205 | 206 | 207 | 208.10000610351562 | 209.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -51 | 206 | 207 | 208 | 209.10000610351562 | 210.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -50 | 207 | 208 | 209 | 210.10000610351562 | 211.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -49 | 208 | 209 | 210 | 211.10000610351562 | 212.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -48 | 209 | 210 | 211 | 212.10000610351562 | 213.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -47 | 210 | 211 | 212 | 213.10000610351562 | 214.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -46 | 211 | 212 | 213 | 214.10000610351562 | 215.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -45 | 212 | 213 | 214 | 215.10000610351562 | 216.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -44 | 213 | 214 | 215 | 216.10000610351562 | 217.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -43 | 214 | 215 | 216 | 217.10000610351562 | 218.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -42 | 215 | 216 | NULL | 218.10000610351562 | 219.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -41 | 216 | 217 | 218 | 219.10000610351562 | 220.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -40 | 217 | 218 | 219 | 220.10000610351562 | 221.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -39 | 218 | 219 | 220 | 221.10000610351562 | 222.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -38 | 219 | 220 | 221 | 222.10000610351562 | 223.2 | {"format":"sequencefile"} | NULL | NULL
sequencefile test | -37 | 220 | 221 | 222 | 223.10000610351562 | 224.2 | {"format":"sequencefile"} | false | 130
NULL | -36 | 221 | 222 | 223 | 224.10000610351562 | 225.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -35 | 222 | 223 | 224 | 225.10000610351562 | 226.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -34 | 223 | 224 | 225 | 226.10000610351562 | 227.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -33 | 224 | 225 | 226 | 227.10000610351562 | 228.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -32 | 225 | 226 | 227 | 228.10000610351562 | 229.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -31 | 226 | 227 | 228 | 229.10000610351562 | 230.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -30 | 227 | 228 | 229 | 230.10000610351562 | 231.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -29 | 228 | 229 | NULL | 231.10000610351562 | 232.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -28 | 229 | 230 | 231 | 232.10000610351562 | 233.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -27 | 230 | 231 | 232 | 233.10000610351562 | 234.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -26 | 231 | 232 | 233 | 234.10000610351562 | 235.2 | NULL | NULL | 130
sequencefile test | -25 | 232 | 233 | 234 | 235.10000610351562 | 236.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -24 | 233 | 234 | 235 | 236.10000610351562 | 237.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -23 | 234 | 235 | 236 | 237.10000610351562 | 238.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -22 | 235 | 236 | 237 | 238.10000610351562 | 239.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -21 | 236 | 237 | 238 | 239.10000610351562 | 240.2 | {"format":"sequencefile"} | true | NULL
sequencefile test | -20 | 237 | 238 | 239 | 240.10000610351562 | 241.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -19 | 238 | 239 | 240 | 241.10000610351562 | 242.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -18 | 239 | 240 | 241 | 242.10000610351562 | 243.2 | {"format":"sequencefile"} | true | 130
NULL | -17 | 240 | 241 | 242 | 243.10000610351562 | 244.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -16 | 241 | 242 | NULL | 244.10000610351562 | 245.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -15 | 242 | 243 | 244 | 245.10000610351562 | 246.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -14 | 243 | 244 | 245 | 246.10000610351562 | 247.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -13 | 244 | 245 | 246 | 247.10000610351562 | 248.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -12 | 245 | 246 | 247 | 248.10000610351562 | 249.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -11 | 246 | 247 | 248 | 249.10000610351562 | 250.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -10 | 247 | 248 | 249 | 250.10000610351562 | 251.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -9 | 248 | 249 | 250 | 251.10000610351562 | 252.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -8 | 249 | 250 | 251 | 252.10000610351562 | 253.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -7 | 250 | 251 | 252 | 253.10000610351562 | 254.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -6 | 251 | 252 | 253 | 254.10000610351562 | 255.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -5 | 252 | 253 | 254 | 255.10000610351562 | 256.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -4 | 253 | 254 | 255 | 256.1000061035156 | 257.2 | {"format":"sequencefile"} | false | NULL
sequencefile test | -3 | 254 | 255 | NULL | 257.1000061035156 | 258.2 | {"format":"sequencefile"} | true | 130
sequencefile test | -2 | 255 | 256 | 257 | 258.1000061035156 | 259.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | -1 | 256 | 257 | 258 | 259.1000061035156 | 260.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 0 | 257 | 258 | 259 | 260.1000061035156 | 261.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 1 | 258 | 259 | 260 | 261.1000061035156 | 262.2 | {"format":"sequencefile"} | NULL | 130
NULL | 2 | 259 | 260 | 261 | 262.1000061035156 | 263.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 3 | 260 | 261 | 262 | 263.1000061035156 | 264.2 | NULL | true | 130
sequencefile test | 4 | 261 | 262 | 263 | 264.1000061035156 | 265.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 5 | 262 | 263 | 264 | 265.1000061035156 | 266.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 6 | 263 | 264 | 265 | 266.1000061035156 | 267.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 7 | 264 | 265 | 266 | 267.1000061035156 | 268.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 8 | 265 | 266 | 267 | 268.1000061035156 | 269.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 9 | 266 | 267 | 268 | 269.1000061035156 | 270.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 10 | 267 | 268 | NULL | 270.1000061035156 | 271.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 11 | 268 | 269 | 270 | 271.1000061035156 | 272.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 12 | 269 | 270 | 271 | 272.1000061035156 | 273.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 13 | 270 | 271 | 272 | 273.1000061035156 | 274.2 | {"format":"sequencefile"} | NULL | NULL
sequencefile test | 14 | 271 | 272 | 273 | 274.1000061035156 | 275.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 15 | 272 | 273 | 274 | 275.1000061035156 | 276.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 16 | 273 | 274 | 275 | 276.1000061035156 | 277.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 17 | 274 | 275 | 276 | 277.1000061035156 | 278.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 18 | 275 | 276 | 277 | 278.1000061035156 | 279.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 19 | 276 | 277 | 278 | 279.1000061035156 | 280.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 20 | 277 | 278 | 279 | 280.1000061035156 | 281.2 | {"format":"sequencefile"} | false | 130
NULL | 21 | 278 | 279 | 280 | 281.1000061035156 | 282.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 22 | 279 | 280 | 281 | 282.1000061035156 | 283.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 23 | 280 | 281 | NULL | 283.1000061035156 | 284.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 24 | 281 | 282 | 283 | 284.1000061035156 | 285.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 25 | 282 | 283 | 284 | 285.1000061035156 | 286.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 26 | 283 | 284 | 285 | 286.1000061035156 | 287.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 27 | 284 | 285 | 286 | 287.1000061035156 | 288.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 28 | 285 | 286 | 287 | 288.1000061035156 | 289.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 29 | 286 | 287 | 288 | 289.1000061035156 | 290.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 30 | 287 | 288 | 289 | 290.1000061035156 | 291.2 | {"format":"sequencefile"} | true | NULL
sequencefile test | 31 | 288 | 289 | 290 | 291.1000061035156 | 292.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 32 | 289 | 290 | 291 | 292.1000061035156 | 293.2 | NULL | false | 130
sequencefile test | 33 | 290 | 291 | 292 | 293.1000061035156 | 294.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 34 | 291 | 292 | 293 | 294.1000061035156 | 295.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 35 | 292 | 293 | 294 | 295.1000061035156 | 296.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 36 | 293 | 294 | NULL | 296.1000061035156 | 297.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 37 | 294 | 295 | 296 | 297.1000061035156 | 298.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 38 | 295 | 296 | 297 | 298.1000061035156 | 299.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 39 | 296 | 297 | 298 | 299.1000061035156 | 300.2 | {"format":"sequencefile"} | true | 130
NULL | 40 | 297 | 298 | 299 | 300.1000061035156 | 301.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 41 | 298 | 299 | 300 | 301.1000061035156 | 302.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 42 | 299 | 300 | 301 | 302.1000061035156 | 303.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 43 | 300 | 301 | 302 | 303.1000061035156 | 304.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 44 | 301 | 302 | 303 | 304.1000061035156 | 305.2 | {"format":"sequencefile"} | false | 130
sequencefile test | 45 | 302 | 303 | 304 | 305.1000061035156 | 306.2 | {"format":"sequencefile"} | true | 130
(100 rows)
Query 20130911_200012_00007_y8tsy, FINISHED, 1 node
http://localhost:8080/v1/query/20130911_200012_00007_y8tsy?pretty
Splits: 2 total, 2 done (100.00%)
CPU Time: 1.1s total, 179 rows/s, 44.2KB/s, 74% active
Per Node: 0.3 parallelism, 47 rows/s, 11.8KB/s
Parallelism: 0.3
0:04 [200 rows, 49.4KB] [47 rows/s, 11.8KB/s]
presto:default> select * from presto_test tablesample SYSTEM (10);
t_string | t_tinyint | t_smallint | t_int | t_bigint | t_float | t_double | t_map | t_boolean | t_timestamp | t_binary | t_array_string | t_
----------+-----------+------------+-------+----------+---------+----------+-------+-----------+-------------+----------+----------------+---
(0 rows)
presto:default> select * from presto_test tablesample bernoulli (10);
t_string | t_tinyint | t_smallint | t_int | t_bigint | t_float | t_double | t_map | t_boolean | t_ti
-------------------+-----------+------------+-------+----------+--------------------+----------+---------------------------+-----------+-----
rcfile test | 37 | 38 | 39 | 40 | 41.1 | 42.2 | {"format":"rcfile"} | false | 130
rcfile test | 43 | 44 | 45 | 46 | 47.1 | 48.2 | {"format":"rcfile"} | false | 130
rcfile test | 51 | 52 | 53 | 54 | 55.1 | 56.2 | {"format":"rcfile"} | NULL | 130
rcfile test | 55 | 56 | 57 | 58 | 59.1 | 60.2 | {"format":"rcfile"} | false | 130
rcfile test | 56 | 57 | 58 | 59 | 60.1 | 61.2 | {"format":"rcfile"} | true | 130
rcfile test | 62 | 63 | 64 | 65 | 66.1 | 67.2 | {"format":"rcfile"} | true | 130
rcfile test | 74 | 75 | 76 | 77 | 78.1 | 79.2 | {"format":"rcfile"} | true | 130
rcfile test | 83 | 84 | 85 | 86 | 87.1 | 88.2 | {"format":"rcfile"} | true | 130
NULL | 96 | 97 | 98 | 99 | 100.1 | 101.2 | {"format":"rcfile"} | NULL | 130
textfile test | -97 | 416 | 417 | 418 | 419.1000061035156 | 420.2 | {"format":"textfile"} | NULL | 130
textfile test | -95 | 418 | 419 | 420 | 421.1000061035156 | 422.2 | {"format":"textfile"} | true | 130
textfile test | -87 | 426 | 427 | 428 | 429.1000061035156 | 430.2 | {"format":"textfile"} | false | 130
textfile test | -71 | 442 | 443 | 444 | 445.1000061035156 | 446.2 | {"format":"textfile"} | true | 130
textfile test | -61 | 452 | 453 | 454 | 455.1000061035156 | 456.2 | {"format":"textfile"} | NULL | 130
textfile test | -56 | 457 | 458 | 459 | 460.1000061035156 | 461.2 | {"format":"textfile"} | true | 130
NULL | -54 | 459 | 460 | 461 | 462.1000061035156 | 463.2 | {"format":"textfile"} | false | 130
textfile test | -49 | 464 | 465 | 466 | 467.1000061035156 | 468.2 | {"format":"textfile"} | NULL | 130
textfile test | -13 | 500 | 501 | 502 | 503.1000061035156 | 504.2 | {"format":"textfile"} | NULL | 130
sequencefile test | -52 | 205 | 206 | 207 | 208.10000610351562 | 209.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -49 | 208 | 209 | 210 | 211.10000610351562 | 212.2 | {"format":"sequencefile"} | false | 130
sequencefile test | -21 | 236 | 237 | 238 | 239.10000610351562 | 240.2 | {"format":"sequencefile"} | true | NULL
sequencefile test | -5 | 252 | 253 | 254 | 255.10000610351562 | 256.2 | {"format":"sequencefile"} | NULL | 130
NULL | 21 | 278 | 279 | 280 | 281.1000061035156 | 282.2 | {"format":"sequencefile"} | true | 130
sequencefile test | 25 | 282 | 283 | 284 | 285.1000061035156 | 286.2 | {"format":"sequencefile"} | NULL | 130
sequencefile test | 37 | 294 | 295 | 296 | 297.1000061035156 | 298.2 | {"format":"sequencefile"} | NULL | 130
(25 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment