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 <adene...@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.dunn...@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.si...@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 > > >