[jira] [Commented] (BEAM-10226) BeamSQL might fail on test_distinct_bytes after migrated to Sets transform

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17129778#comment-17129778 ] Rui Wang commented on BEAM-10226: - Should solve this JIRA before migrating BeamSQL to Sets transforms. >

[jira] [Created] (BEAM-10226) BeamSQL might be failed on test_distinct_bytes after migrated to Sets transform

2020-06-09 Thread Rui Wang (Jira)
Rui Wang created BEAM-10226: --- Summary: BeamSQL might be failed on test_distinct_bytes after migrated to Sets transform Key: BEAM-10226 URL: https://issues.apache.org/jira/browse/BEAM-10226 Project: Beam

[jira] [Updated] (BEAM-10226) BeamSQL might fail on test_distinct_bytes after migrated to Sets transform

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10226: Status: Open (was: Triage Needed) > BeamSQL might fail on test_distinct_bytes after migrated to Sets

[jira] [Updated] (BEAM-10226) BeamSQL might fail on test_distinct_bytes after migrated to Sets transform

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10226: Summary: BeamSQL might fail on test_distinct_bytes after migrated to Sets transform (was: BeamSQL might

[jira] [Commented] (BEAM-10198) IOException for distinct bytes SQL query

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17129773#comment-17129773 ] Rui Wang commented on BEAM-10198: - It turns out that this regression might come from #11610 where it

[jira] [Resolved] (BEAM-10198) IOException for distinct bytes SQL query

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang resolved BEAM-10198. - Fix Version/s: Not applicable Resolution: Fixed > IOException for distinct bytes SQL query >

[jira] [Commented] (BEAM-10216) SESSION TVF Optimizations

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17129722#comment-17129722 ] Rui Wang commented on BEAM-10216: - I expect this JIRA needs at least two PRs, one for aggregation

[jira] [Updated] (BEAM-10216) SESSION TVF Optimizations

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10216: Description: Current TVF Session has the following limitation: Use a "dummy" key to go through a GBK to

[jira] [Updated] (BEAM-10216) SESSION TVF Optimizations

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10216: Description: Current TVF Session has the following limitation: Use a "dummy" key to go through a GBK to

[jira] [Updated] (BEAM-10216) SESSION TVF Optimizations

2020-06-09 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10216: Description: Current TVF Session has the following limitation: Use a "dummy" key to go through a GBK to

[jira] [Resolved] (BEAM-10215) @Ignore: Concat now works with varargs

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang resolved BEAM-10215. - Fix Version/s: Not applicable Resolution: Fixed > @Ignore: Concat now works with varargs >

[jira] [Closed] (BEAM-10213) @Ignore: fix the test for testCastToDateWithCase

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-10213. --- Fix Version/s: Not applicable Resolution: Fixed > @Ignore: fix the test for testCastToDateWithCase >

[jira] [Updated] (BEAM-10216) SESSION TVF Optimizations

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10216: Status: Open (was: Triage Needed) > SESSION TVF Optimizations > - > >

[jira] [Created] (BEAM-10216) SESSION TVF Optimizations

2020-06-08 Thread Rui Wang (Jira)
Rui Wang created BEAM-10216: --- Summary: SESSION TVF Optimizations Key: BEAM-10216 URL: https://issues.apache.org/jira/browse/BEAM-10216 Project: Beam Issue Type: Improvement Components:

[jira] [Updated] (BEAM-9191) CAST does not work in some cases due to bugs in Calcite unparsing

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9191: --- Labels: beam-fixit (was: beam-fixit stale-assigned) > CAST does not work in some cases due to bugs in

[jira] [Updated] (BEAM-9191) CAST does not work in some cases due to bugs in Calcite unparsing

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9191: --- Labels: beam-fixit stale-assigned (was: stale-assigned) > CAST does not work in some cases due to bugs in

[jira] [Created] (BEAM-10215) @Ignore: Concat now works with varargs

2020-06-08 Thread Rui Wang (Jira)
Rui Wang created BEAM-10215: --- Summary: @Ignore: Concat now works with varargs Key: BEAM-10215 URL: https://issues.apache.org/jira/browse/BEAM-10215 Project: Beam Issue Type: Bug

[jira] [Work started] (BEAM-10213) @Ignore: fix the test for testCastToDateWithCase

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on BEAM-10213 started by Rui Wang. --- > @Ignore: fix the test for testCastToDateWithCase >

[jira] [Updated] (BEAM-10213) @Ignore: fix the test for testCastToDateWithCase

2020-06-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10213: Description: Fix this ignored test: testCastToDateWithCase() There are two improvements: 1. SUBSTR's

[jira] [Created] (BEAM-10213) @Ignore: fix the test for testCastToDateWithCase

2020-06-08 Thread Rui Wang (Jira)
Rui Wang created BEAM-10213: --- Summary: @Ignore: fix the test for testCastToDateWithCase Key: BEAM-10213 URL: https://issues.apache.org/jira/browse/BEAM-10213 Project: Beam Issue Type: Bug

[jira] [Closed] (BEAM-10204) @Ignore: re-enable LIKE operator related unit tests

2020-06-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-10204. --- Fix Version/s: Not applicable Resolution: Fixed > @Ignore: re-enable LIKE operator related unit tests

[jira] [Updated] (BEAM-9363) BeamSQL windowing as TVF

2020-06-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9363: --- Labels: (was: stale-assigned) > BeamSQL windowing as TVF > > >

[jira] [Closed] (BEAM-10205) @Ignore: BYTES can work with UNION ALL

2020-06-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-10205. --- Fix Version/s: Not applicable Resolution: Fixed > @Ignore: BYTES can work with UNION ALL >

[jira] [Updated] (BEAM-10204) @Ignore: re-enable LIKE operator related unit tests

2020-06-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10204: Description: The following @Ignore tests can be enabled: ZetaSQLDialectSpecTest.testLike1

[jira] [Work started] (BEAM-10204) @Ignore: re-enable LIKE operator related unit tests

2020-06-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on BEAM-10204 started by Rui Wang. --- > @Ignore: re-enable LIKE operator related unit tests >

[jira] [Work started] (BEAM-10205) @Ignore: BYTES can work with UNION ALL

2020-06-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on BEAM-10205 started by Rui Wang. --- > @Ignore: BYTES can work with UNION ALL > -- > >

[jira] [Updated] (BEAM-10205) @Ignore: BYTES can work with UNION ALL

2020-06-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10205: Summary: @Ignore: BYTES can work with UNION ALL (was: @Ignore:BYTES can work with UNION ALL) > @Ignore:

[jira] [Updated] (BEAM-10205) @Ignore:BYTES can work with UNION ALL

2020-06-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10205: Summary: @Ignore:BYTES can work with UNION ALL (was: @Ignore: re-enable BYTES can work with UNION ALL) >

[jira] [Created] (BEAM-10205) @Ignore: re-enable BYTES can work with UNION ALL

2020-06-05 Thread Rui Wang (Jira)
Rui Wang created BEAM-10205: --- Summary: @Ignore: re-enable BYTES can work with UNION ALL Key: BEAM-10205 URL: https://issues.apache.org/jira/browse/BEAM-10205 Project: Beam Issue Type: Bug

[jira] [Created] (BEAM-10204) @Ignore: re-enable LIKE operator related unit tests

2020-06-05 Thread Rui Wang (Jira)
Rui Wang created BEAM-10204: --- Summary: @Ignore: re-enable LIKE operator related unit tests Key: BEAM-10204 URL: https://issues.apache.org/jira/browse/BEAM-10204 Project: Beam Issue Type: Bug

[jira] [Updated] (BEAM-10198) IOException for distinct bytes SQL query

2020-06-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10198: Labels: beam-fixit (was: ) > IOException for distinct bytes SQL query >

[jira] [Updated] (BEAM-10198) IOException for distinct bytes SQL query

2020-06-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10198: Description: This query breaks Java code import. Need to diagnose the root cause and have a fix properly.

[jira] [Created] (BEAM-10198) Program crashes for distinct bytes SQL query

2020-06-04 Thread Rui Wang (Jira)
Rui Wang created BEAM-10198: --- Summary: Program crashes for distinct bytes SQL query Key: BEAM-10198 URL: https://issues.apache.org/jira/browse/BEAM-10198 Project: Beam Issue Type: Bug

[jira] [Updated] (BEAM-10198) IOException for distinct bytes SQL query

2020-06-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-10198: Summary: IOException for distinct bytes SQL query (was: Program crashes for distinct bytes SQL query) >

[jira] [Commented] (BEAM-9953) Beam ZetaSQL supports multiple statements in a query

2020-06-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17126232#comment-17126232 ] Rui Wang commented on BEAM-9953: Better to check the open sourced Java Analyzer:

[jira] [Created] (BEAM-10196) [beam_PostCommit_Java_ValidatesRunner_Spark] [TimerTests.testOutputTimestampDefault]

2020-06-04 Thread Rui Wang (Jira)
Rui Wang created BEAM-10196: --- Summary: [beam_PostCommit_Java_ValidatesRunner_Spark] [TimerTests.testOutputTimestampDefault] Key: BEAM-10196 URL: https://issues.apache.org/jira/browse/BEAM-10196 Project:

[jira] [Assigned] (BEAM-10195) [beam_PostCommit_Java_ValidatesRunner_Samza] [ org.apache.beam.sdk.transforms.ParDoTest$TimerTests.testOutputTimestampDefault]

2020-06-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-10195: --- Assignee: Xinyu Liu > [beam_PostCommit_Java_ValidatesRunner_Samza] [ >

[jira] [Created] (BEAM-10195) [beam_PostCommit_Java_ValidatesRunner_Samza] [ org.apache.beam.sdk.transforms.ParDoTest$TimerTests.testOutputTimestampDefault]

2020-06-04 Thread Rui Wang (Jira)
Rui Wang created BEAM-10195: --- Summary: [beam_PostCommit_Java_ValidatesRunner_Samza] [ org.apache.beam.sdk.transforms.ParDoTest$TimerTests.testOutputTimestampDefault] Key: BEAM-10195 URL:

[jira] [Updated] (BEAM-9198) BeamSQL aggregation analytics functionality

2020-06-01 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9198: --- Labels: gsoc gsoc2020 mentor (was: gsoc gsoc2020 mentor stale-assigned) > BeamSQL aggregation analytics

[jira] [Work started] (BEAM-9363) BeamSQL windowing as TVF

2020-06-01 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on BEAM-9363 started by Rui Wang. -- > BeamSQL windowing as TVF > > > Key: BEAM-9363 >

[jira] [Updated] (BEAM-9543) BeamSQL Pattern Recognization Functionality

2020-06-01 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9543: --- Labels: gsoc gsoc2020 mentor (was: gsoc gsoc2020 mentor stale-assigned) > BeamSQL Pattern Recognization

[jira] [Resolved] (BEAM-5843) Expand Grouped Window Functions to window_start and window_end in Aggregation

2020-06-01 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-5843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang resolved BEAM-5843. Fix Version/s: Not applicable Resolution: Won't Fix > Expand Grouped Window Functions to

[jira] [Commented] (BEAM-9953) Beam ZetaSQL supports multiple statements in a query

2020-06-01 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17121347#comment-17121347 ] Rui Wang commented on BEAM-9953: Agreed. Though hacker way can help us develop faster for SQL UDF, having

[jira] [Commented] (BEAM-9953) Beam ZetaSQL supports multiple statements in a query

2020-06-01 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17121237#comment-17121237 ] Rui Wang commented on BEAM-9953: Hello. I am wondering why you need `extractTableNamesFromNextStatement`

[jira] [Commented] (BEAM-10074) Hash Functions in BeamSQL

2020-05-26 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-10074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17116937#comment-17116937 ] Rui Wang commented on BEAM-10074: - Hello Darshan, Did you have any problem to use such hash functions

[jira] [Commented] (BEAM-10000) Support BIT_XOR aggregation function in BeamSQL

2020-05-14 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-1?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17107795#comment-17107795 ] Rui Wang commented on BEAM-1: - Yeah! > Support BIT_XOR aggregation function in BeamSQL >

[jira] [Updated] (BEAM-10000) Support BIT_XOR aggregation function in BeamSQL

2020-05-14 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-1?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-1: Description: See reference:

[jira] [Updated] (BEAM-10000) Support BIT_XOR aggregation function in BeamSQL

2020-05-14 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-1?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-1: Status: Open (was: Triage Needed) > Support BIT_XOR aggregation function in BeamSQL >

[jira] [Created] (BEAM-10000) Support BIT_XOR aggregation function in BeamSQL

2020-05-14 Thread Rui Wang (Jira)
Rui Wang created BEAM-1: --- Summary: Support BIT_XOR aggregation function in BeamSQL Key: BEAM-1 URL: https://issues.apache.org/jira/browse/BEAM-1 Project: Beam Issue Type: Task

[jira] [Updated] (BEAM-9992) Migrate BeamSQL's SET operators to SetFns transforms

2020-05-14 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9992: --- Status: Open (was: Triage Needed) > Migrate BeamSQL's SET operators to SetFns transforms >

[jira] [Resolved] (BEAM-9929) UNNEST(array_column)

2020-05-13 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang resolved BEAM-9929. Fix Version/s: Not applicable Resolution: Fixed > UNNEST(array_column) > > >

[jira] [Commented] (BEAM-9890) Support BIT_AND aggregation function in BeamSQL

2020-05-13 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17106565#comment-17106565 ] Rui Wang commented on BEAM-9890: Sorry [~brz] I should assign this to myself. Right now I am holding this

[jira] [Assigned] (BEAM-9890) Support BIT_AND aggregation function in BeamSQL

2020-05-13 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-9890: -- Assignee: Rui Wang (was: Borzoo Esmailloo) > Support BIT_AND aggregation function in BeamSQL >

[jira] [Updated] (BEAM-9864) Support ANY_VALUE in OVER/window clauses.

2020-05-13 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9864: --- Status: Open (was: Triage Needed) > Support ANY_VALUE in OVER/window clauses. >

[jira] [Updated] (BEAM-9969) Beam ZetaSQL supports pure SQL user-defined table functions

2020-05-12 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9969: --- Description: There are four types of implementation of table-valued function: 1. FixedSchemaOutput. The

[jira] [Created] (BEAM-9972) Test pure SQL UDF for all data types

2020-05-12 Thread Rui Wang (Jira)
Rui Wang created BEAM-9972: -- Summary: Test pure SQL UDF for all data types Key: BEAM-9972 URL: https://issues.apache.org/jira/browse/BEAM-9972 Project: Beam Issue Type: Task Components:

[jira] [Updated] (BEAM-9969) Beam ZetaSQL supports pure SQL user-defined table functions

2020-05-12 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9969: --- Status: Open (was: Triage Needed) > Beam ZetaSQL supports pure SQL user-defined table functions >

[jira] [Created] (BEAM-9969) Beam ZetaSQL supports pure SQL user-defined table functions

2020-05-12 Thread Rui Wang (Jira)
Rui Wang created BEAM-9969: -- Summary: Beam ZetaSQL supports pure SQL user-defined table functions Key: BEAM-9969 URL: https://issues.apache.org/jira/browse/BEAM-9969 Project: Beam Issue Type: Task

[jira] [Updated] (BEAM-9954) Beam ZetaSQL supports pure SQL user-defined aggregation functions

2020-05-12 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9954: --- Description: One naive example is {code:sql} CREATE AGGREGATE FUNCTION fun (a INT64) AS (SUM(a)); {code}

[jira] [Updated] (BEAM-9954) Beam ZetaSQL supports pure SQL user-defined aggregation functions

2020-05-12 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9954: --- Description: One naive example is {code:sql} CREATE AGGREGATE FUNCTION fun (a INT64, b INT64) AS

[jira] [Updated] (BEAM-9954) Beam ZetaSQL supports pure SQL user-defined aggregation functions

2020-05-11 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9954: --- Status: Open (was: Triage Needed) > Beam ZetaSQL supports pure SQL user-defined aggregation functions >

[jira] [Created] (BEAM-9954) Beam ZetaSQL supports pure SQL user-defined aggregation functions

2020-05-11 Thread Rui Wang (Jira)
Rui Wang created BEAM-9954: -- Summary: Beam ZetaSQL supports pure SQL user-defined aggregation functions Key: BEAM-9954 URL: https://issues.apache.org/jira/browse/BEAM-9954 Project: Beam Issue

[jira] [Updated] (BEAM-9953) Beam ZetaSQL supports multiple statements in a query

2020-05-11 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9953: --- Status: Open (was: Triage Needed) > Beam ZetaSQL supports multiple statements in a query >

[jira] [Created] (BEAM-9953) Beam ZetaSQL supports multiple statements in a query

2020-05-11 Thread Rui Wang (Jira)
Rui Wang created BEAM-9953: -- Summary: Beam ZetaSQL supports multiple statements in a query Key: BEAM-9953 URL: https://issues.apache.org/jira/browse/BEAM-9953 Project: Beam Issue Type: Task

[jira] [Updated] (BEAM-9953) Beam ZetaSQL supports multiple statements in a query

2020-05-11 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9953: --- Description: One example of multiple statements query: {code:java} CREATE FUNCTION fun_a (param_1 INT64);

[jira] [Updated] (BEAM-5073) Enable SortRemoveRule

2020-05-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5073: --- Status: Open (was: Triage Needed) > Enable SortRemoveRule > - > > Key:

[jira] [Reopened] (BEAM-5073) Enable SortRemoveRule

2020-05-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reopened BEAM-5073: Assignee: (was: Rui Wang) > Enable SortRemoveRule > - > > Key:

[jira] [Created] (BEAM-9929) UNNEST(array_column)

2020-05-07 Thread Rui Wang (Jira)
Rui Wang created BEAM-9929: -- Summary: UNNEST(array_column) Key: BEAM-9929 URL: https://issues.apache.org/jira/browse/BEAM-9929 Project: Beam Issue Type: Improvement Components:

[jira] [Assigned] (BEAM-9198) BeamSQL aggregation analytics functionality

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-9198: -- Assignee: John Mora > BeamSQL aggregation analytics functionality >

[jira] [Updated] (BEAM-9891) TPC benchmarks for BeamSQL

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9891: --- Status: Open (was: Triage Needed) > TPC benchmarks for BeamSQL > -- > >

[jira] [Created] (BEAM-9891) TPC benchmarks for BeamSQL

2020-05-05 Thread Rui Wang (Jira)
Rui Wang created BEAM-9891: -- Summary: TPC benchmarks for BeamSQL Key: BEAM-9891 URL: https://issues.apache.org/jira/browse/BEAM-9891 Project: Beam Issue Type: Task Components: dsl-sql

[jira] [Assigned] (BEAM-9879) Support STRING_AGG in BeamSQL

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-9879: -- Assignee: Qihang Zeng > Support STRING_AGG in BeamSQL > - > >

[jira] [Commented] (BEAM-9890) Support BIT_AND aggregation function in BeamSQL

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17100236#comment-17100236 ] Rui Wang commented on BEAM-9890: A good reference PR is: https://github.com/apache/beam/pull/11333 >

[jira] [Updated] (BEAM-9890) Support BIT_AND aggregation function in BeamSQL

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9890: --- Description: Performs a bitwise AND operation on expression and returns the result. Supported Argument

[jira] [Updated] (BEAM-9890) Support BIT_AND aggregation function in BeamSQL

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9890: --- Description: Performs a bitwise AND operation on expression and returns the result. Supported Argument

[jira] [Updated] (BEAM-9890) Support BIT_AND aggregation function in BeamSQL

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9890: --- Status: Open (was: Triage Needed) > Support BIT_AND aggregation function in BeamSQL >

[jira] [Updated] (BEAM-9890) Support BIT_AND aggregation function in BeamSQL

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9890: --- Description: Performs a bitwise AND operation on expression and returns the result. Supported Argument

[jira] [Created] (BEAM-9890) Support BIT_AND aggregation function in BeamSQL

2020-05-05 Thread Rui Wang (Jira)
Rui Wang created BEAM-9890: -- Summary: Support BIT_AND aggregation function in BeamSQL Key: BEAM-9890 URL: https://issues.apache.org/jira/browse/BEAM-9890 Project: Beam Issue Type: Task

[jira] [Commented] (BEAM-9825) Transforms for Intersect, IntersectAll, Except, ExceptAll, Union, UnionAll

2020-05-05 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17100101#comment-17100101 ] Rui Wang commented on BEAM-9825: Thank you Darshan. Will take a look. > Transforms for Intersect,

[jira] [Commented] (BEAM-9879) Support STRING_AGG in BeamSQL

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099255#comment-17099255 ] Rui Wang commented on BEAM-9879: A good reference of implementation is what is done in

[jira] [Updated] (BEAM-9879) Support STRING_AGG in BeamSQL

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9879: --- Status: Open (was: Triage Needed) > Support STRING_AGG in BeamSQL > - > >

[jira] [Created] (BEAM-9879) Support STRING_AGG in BeamSQL

2020-05-04 Thread Rui Wang (Jira)
Rui Wang created BEAM-9879: -- Summary: Support STRING_AGG in BeamSQL Key: BEAM-9879 URL: https://issues.apache.org/jira/browse/BEAM-9879 Project: Beam Issue Type: Task Components: dsl-sql,

[jira] [Resolved] (BEAM-9418) Support ANY_VALUE aggregation functions

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang resolved BEAM-9418. Fix Version/s: Not applicable Resolution: Fixed > Support ANY_VALUE aggregation functions >

[jira] [Commented] (BEAM-9418) Support ANY_VALUE aggregation functions

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099247#comment-17099247 ] Rui Wang commented on BEAM-9418: Thanks John for your contribution! The PR has merged. > Support

[jira] [Comment Edited] (BEAM-9825) Transforms for Intersect, Difference and Commons

2020-04-30 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17096943#comment-17096943 ] Rui Wang edited comment on BEAM-9825 at 4/30/20, 8:02 PM: -- Hello Darshan, Thanks

[jira] [Commented] (BEAM-9825) Transforms for Intersect, Difference and Commons

2020-04-30 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17096943#comment-17096943 ] Rui Wang commented on BEAM-9825: Hello Darshan, Thanks for opening this Jira. First of all, I think you

[jira] [Commented] (BEAM-9267) A BeamSQL UDF that returns a Map fails always with NullPointerException.

2020-04-24 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17091929#comment-17091929 ] Rui Wang commented on BEAM-9267: [~iemejia]thanks. I can take this. > A BeamSQL UDF that returns a Map

[jira] [Assigned] (BEAM-9267) A BeamSQL UDF that returns a Map fails always with NullPointerException.

2020-04-24 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-9267: -- Assignee: Rui Wang > A BeamSQL UDF that returns a Map fails always with NullPointerException. >

[jira] [Updated] (BEAM-9267) A BeamSQL UDF that returns a Map fails always with NullPointerException.

2020-04-24 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9267: --- Status: Open (was: Triage Needed) > A BeamSQL UDF that returns a Map fails always with NullPointerException.

[jira] [Commented] (BEAM-9486) Python 2 PostCommit Failures due to time-out in 2.20.0 release branch

2020-04-19 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17087370#comment-17087370 ] Rui Wang commented on BEAM-9486: cc [~ibzib] it might still exist in 2.21.0 release branch. The root

[jira] [Resolved] (BEAM-9751) Upgrade ZetaSQL to 2020.04.1

2020-04-19 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang resolved BEAM-9751. Fix Version/s: Not applicable Resolution: Fixed > Upgrade ZetaSQL to 2020.04.1 >

[jira] [Commented] (BEAM-9765) :vendor:calcite-1_20_0:validateVendoring fails

2020-04-15 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9765?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084331#comment-17084331 ] Rui Wang commented on BEAM-9765: unassign myself since I don't have a plan to check this JIRA. My plan is

[jira] [Assigned] (BEAM-9765) :vendor:calcite-1_20_0:validateVendoring fails

2020-04-15 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-9765: -- Assignee: (was: Rui Wang) > :vendor:calcite-1_20_0:validateVendoring fails >

[jira] [Created] (BEAM-9751) Upgrade ZetaSQL to 2020.04.1

2020-04-13 Thread Rui Wang (Jira)
Rui Wang created BEAM-9751: -- Summary: Upgrade ZetaSQL to 2020.04.1 Key: BEAM-9751 URL: https://issues.apache.org/jira/browse/BEAM-9751 Project: Beam Issue Type: Task Components:

[jira] [Commented] (BEAM-9725) Perfomance regression in reshuffle

2020-04-08 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17078672#comment-17078672 ] Rui Wang commented on BEAM-9725: Thank you Ankur! > Perfomance regression in reshuffle >

[jira] [Commented] (BEAM-9412) Fix linkage errors in vendored calcite

2020-04-03 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17074965#comment-17074965 ] Rui Wang commented on BEAM-9412: [~lcwik] how to check linkage error for a specific module. E.g.

[jira] [Resolved] (BEAM-9557) Error setting processing time timers near end-of-window

2020-03-30 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang resolved BEAM-9557. Resolution: Fixed Have cherry-picked the change to release branch. > Error setting processing time timers

[jira] [Updated] (BEAM-9198) BeamSQL aggregation analytics functionality

2020-03-27 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9198: --- Description: Mentor email: ruw...@google.com. Feel free to send emails for your questions. Project

[jira] [Commented] (BEAM-4161) Nested Rows flattening doesn't work

2020-03-25 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-4161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17067082#comment-17067082 ] Rui Wang commented on BEAM-4161: Need to upgrade calcite and take another check. > Nested Rows flattening

[jira] [Updated] (BEAM-9198) BeamSQL aggregation analytics functionality

2020-03-24 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/BEAM-9198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-9198: --- Issue Type: New Feature (was: Task) > BeamSQL aggregation analytics functionality >

  1   2   3   4   5   6   7   >