aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/action/eval_folder_via_file.sql
blob: 2121ea69c28904b5b8287bb97a54eca1127faa0d (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
/* syntax version 1 */
/* postgres can not */
use plato;

pragma yt.FolderInlineItemsLimit="0";

$list = (
    select aggregate_list(Path) from (
    select Path from folder("")
    where Type = "table"
    limit 30
    )
);

select 
    count(*)
from 
    each($list)