[GitHub] [beam] amaliujia commented on pull request #12110: [BEAM-9890] Try fixing BIT_AND(NULL) issue

2020-06-26 Thread GitBox
amaliujia commented on pull request #12110: URL: https://github.com/apache/beam/pull/12110#issuecomment-650489631 Run SQL_Java11 PreCommit This is an automated message from the Apache Git Service. To respond to the message, p

[GitHub] [beam] amaliujia commented on pull request #12110: [BEAM-9890] Try fixing BIT_AND(NULL) issue

2020-06-26 Thread GitBox
amaliujia commented on pull request #12110: URL: https://github.com/apache/beam/pull/12110#issuecomment-650490127 @Imfuyuwei Can you add a unit test to test `NULL` value? This is an automated message from the Apache G

[GitHub] [beam] amaliujia commented on pull request #12110: [BEAM-9890] Try fixing BIT_AND(NULL) issue

2020-06-27 Thread GitBox
amaliujia commented on pull request #12110: URL: https://github.com/apache/beam/pull/12110#issuecomment-650588727 NULL value can be tested: https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/zetasql/src/test/java/org/apache/beam/sdk/extensions/sql/zetasql/ZetaSQLDialectSpec

[GitHub] [beam] amaliujia commented on pull request #12110: [BEAM-9890] Try fixing BIT_AND(NULL) issue

2020-06-27 Thread GitBox
amaliujia commented on pull request #12110: URL: https://github.com/apache/beam/pull/12110#issuecomment-650592810 Sometimes you might need a CAST though: https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/zetasql/src/test/java/org/apache/beam/sdk/extensions/sql/zetasql/Zeta

[GitHub] [beam] amaliujia commented on pull request #12110: [BEAM-9890] Try fixing BIT_AND(NULL) issue

2020-06-27 Thread GitBox
amaliujia commented on pull request #12110: URL: https://github.com/apache/beam/pull/12110#issuecomment-650624450 The easiest way I know is to write a ParDo by your own, which 1. pass through elements. 2. but also save elements in a List. So you can append this ParDo to the PCo

[GitHub] [beam] amaliujia commented on pull request #12110: [BEAM-9890] Try fixing BIT_AND(NULL) issue

2020-06-29 Thread GitBox
amaliujia commented on pull request #12110: URL: https://github.com/apache/beam/pull/12110#issuecomment-651418090 @Imfuyuwei can you revert changes in `BeamBuiltinAggregations.java ` and `BeamSqlDslAggregationTest.java` -