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 <[email protected]> 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 <[email protected]> wrote: > >> This is extremely useful. Thanks for putting so much information together! >> >> Kenn >> >> On Wed, May 30, 2018 at 8:19 AM Kai Jiang <[email protected]> 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 >>> ᐧ >>> >>
