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 > ᐧ >