Fwd: Recursive CTE Support in Drill

[Alexander Zarei <al...@gmail.com>]

+ user@drill

Hi All,

I am trying to come up with a query which returns a given number of rows
without having a real table on Storage.

I am hoping to achieve something like this:

http://stackoverflow.com/questions/6533524/sql-select-n-records-without-a-table

DECLARE @start INT = 1;DECLARE @end INT = 1000000;
WITH numbers AS (
    SELECT @start AS number
    UNION ALL
    SELECT number + 1
    FROM  numbers
    WHERE number < @end)SELECT *FROM numbersOPTION (MAXRECURSION 0);

I do not actually need to create different values and returning identical
rows would work too.I just need to bypass the "from clause" in the query.

Thanks,
Alex