subquery_mapjoin.sql 339 B

1234567891011121314
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. /* hybridfile can not YQL-17764 */
  4. /* custom check: len(yt_res_yson[0][b'Write'][0][b'Data']) < 10 */
  5. use plato;
  6. pragma DisableSimpleColumns;
  7. pragma yt.MapJoinLimit="1m";
  8. select * from(
  9. select * from plato.Input as a
  10. inner join plato.Input as b
  11. on a.key = b.key
  12. ) tablesample bernoulli(30);