This is super interesting, great work Kai! Just for curiosity, How are you validating this? It would be really interesting to have this also as part of some kind of IT for the future.
On Fri, Jun 1, 2018 at 7:43 PM Kai Jiang <jiang...@gmail.com> wrote: > Sounds a good idea! I will file the major problems later and use a task > issue to track. > > Best, > Kai > ᐧ > > On Fri, Jun 1, 2018 at 10:10 AM Anton Kedin <ke...@google.com> wrote: > >> This looks very helpful, thank you. >> >> Can you file Jiras for the major problems? Or maybe a single jira for the >> whole thing with sub-tasks for specific problems. >> >> Regards, >> Anton >> >> On Wed, May 30, 2018 at 9:12 AM Kenneth Knowles <k...@google.com> wrote: >> >>> This is extremely useful. Thanks for putting so much information >>> together! >>> >>> Kenn >>> >>> On Wed, May 30, 2018 at 8:19 AM Kai Jiang <jiang...@gmail.com> wrote: >>> >>>> Hi all, >>>> >>>> Based on pull/5481 <https://github.com/apache/beam/pull/5481>, I >>>> manually did a coverage test with TPC-ds queries (65%) and TPC-h queries >>>> (100%) and want to see what features Beam SQL is currently not supporting. >>>> Test was running on DirectRunner. >>>> >>>> I want to share the result. >>>> TPC-DS queries on Beam >>>> <https://docs.google.com/spreadsheets/d/12iO0vnPWJC-SFp1dBXd_iClf2ERjewl6IRAC2Z0AzdY/edit?usp=drive_web> >>>> >>>> TL;DR: >>>> >>>> 1. aggregation function (stddev) missing or calculation of >>>> aggregation functions combination. >>>> 2. nested beamjoinrel(condition=[true], joinType=[inner]) / cross >>>> join error >>>> 3. date type casting/ calculation and other types casting. >>>> 4. LIKE operator in String / alias for substring function >>>> 5. order by w/o limit clause. >>>> 6. OR operator is supported in join condition >>>> 7. Syntax: exist/ not exist (errors) . rank() over (partition >>>> by) / view (unsupported) >>>> >>>> >>>> Best, >>>> Kai >>>> ᐧ >>>> >>>
