drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: Recursive CTE Support in Drill
Date Fri, 10 Jul 2015 16:10:10 GMT
Hakim,

Not yet.  Still very much in the stage of gathering feedback.

I would think it very simple.  The biggest obstacles are

1) no documentation on how to write a data format

2) I need to release a jar for log-synth to Maven Central.




On Fri, Jul 10, 2015 at 8:17 AM, Abdel Hakim Deneche <adeneche@maprtech.com>
wrote:

> @Ted, the log-synth storage format would be really useful. I'm already
> seeing many unit tests that could benefit from this. Do you have a github
> repo for your ongoing work ?
>
> Thanks!
>
> On Thu, Jul 9, 2015 at 10:56 PM, Ted Dunning <ted.dunning@gmail.com>
> wrote:
>
> > Are you hard set on using common table expressions?
> >
> > I have discussed a bit off-list creating a data format that would allow
> > tables to be read from a log-synth [1] schema.  That would let you read
> as
> > much data as you might like with an arbitrarily complex (or simple)
> query.
> >
> > Operationally, you would create a file containing a log-synth schema that
> > has the extension .synth.  Your data source would have to be configured
> to
> > connect that extension with the log-synth format.  At that point, you
> could
> > select as much or little data as you like from the file and you would see
> > generated data rather than the schema.
> >
> >
> >
> > [1] https://github.com/tdunning/log-synth
> >
> > On Thu, Jul 9, 2015 at 11:31 AM, Alexander Zarei <
> > alexanderz.simba@gmail.com
> > > wrote:
> >
> > > 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
> > >
> >
>
>
>
> --
>
> Abdelhakim Deneche
>
> Software Engineer
>
>   <http://www.mapr.com/>
>
>
> Now Available - Free Hadoop On-Demand Training
> <
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message