[jira] [Updated] (BEAM-4194) [SQL] Support LIMIT on Unbounded Data

2018-06-18 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4194: --- Summary: [SQL] Support LIMIT on Unbounded Data (was: [SQL] Support LIMIT) > [SQL] Support LIMIT on Unbounded

[jira] [Commented] (BEAM-4194) [SQL] Support LIMIT on Unbounded Data

2018-06-19 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16517580#comment-16517580 ] Rui Wang commented on BEAM-4194:

[jira] [Commented] (BEAM-4194) [SQL] Support LIMIT on Unbounded Data

2018-06-19 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16517581#comment-16517581 ] Rui Wang commented on BEAM-4194:

[jira] [Comment Edited] (BEAM-4194) [SQL] Support LIMIT on Unbounded Data

2018-06-19 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16517581#comment-16517581 ] Rui Wang edited comment on BEAM-4194 at 6/19/18 10:06 PM: --

[jira] [Commented] (BEAM-4385) Support LIKE operator

2018-05-29 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16494238#comment-16494238 ] Rui Wang commented on BEAM-4385: [~kenn]   Hi Kennth! Can I take this task? > Support LIKE operator >

[jira] [Updated] (BEAM-4646) Improve SQL's BigQuery write integration test

2018-06-26 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4646: --- Summary: Improve SQL's BigQuery write integration test (was: Improve BigQuery write integration test) >

[jira] [Updated] (BEAM-4646) Improve BigQuery write integration test

2018-06-26 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4646: --- Description: Right now SQL's BigQuery write integration test only tests VARCHAR, ARRAY and  BIGINT, it might

[jira] [Assigned] (BEAM-4647) Support String type in Create Table statement

2018-06-26 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4647: -- Assignee: Xu Mingmin (was: Rui Wang) > Support String type in Create Table statement >

[jira] [Assigned] (BEAM-4647) Support String type in Create Table statement

2018-06-26 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4647: -- Assignee: Rui Wang (was: Xu Mingmin) > Support String type in Create Table statement >

[jira] [Created] (BEAM-4646) Improve BigQuery write integration test

2018-06-26 Thread Rui Wang (JIRA)
Rui Wang created BEAM-4646: -- Summary: Improve BigQuery write integration test Key: BEAM-4646 URL: https://issues.apache.org/jira/browse/BEAM-4646 Project: Beam Issue Type: Improvement

[jira] [Assigned] (BEAM-4647) Support String type in Create Table statement

2018-06-26 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4647: -- Assignee: Rui Wang (was: Xu Mingmin) > Support String type in Create Table statement >

[jira] [Created] (BEAM-4647) Support String type in Create Table statement

2018-06-26 Thread Rui Wang (JIRA)
Rui Wang created BEAM-4647: -- Summary: Support String type in Create Table statement Key: BEAM-4647 URL: https://issues.apache.org/jira/browse/BEAM-4647 Project: Beam Issue Type: Bug

[jira] [Assigned] (BEAM-4625) Support ALL and SOME kind of comparison operator

2018-06-22 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4625: -- Assignee: Rui Wang (was: Xu Mingmin) > Support ALL and SOME kind of comparison operator >

[jira] [Commented] (BEAM-4624) Test comparison operator at DSL level

2018-06-22 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16520757#comment-16520757 ] Rui Wang commented on BEAM-4624: Not including ALL and SOME > Test comparison operator at DSL level >

[jira] [Created] (BEAM-4625) Support ALL and SOME kind of comparison operator

2018-06-22 Thread Rui Wang (JIRA)
Rui Wang created BEAM-4625: -- Summary: Support ALL and SOME kind of comparison operator Key: BEAM-4625 URL: https://issues.apache.org/jira/browse/BEAM-4625 Project: Beam Issue Type: Sub-task

[jira] [Updated] (BEAM-4194) [SQL] Support LIMIT on Unbounded Data

2018-06-22 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4194: --- Fix Version/s: (was: Not applicable) 2.6.0 > [SQL] Support LIMIT on Unbounded Data >

[jira] [Closed] (BEAM-4624) Test comparison operator at DSL level

2018-06-25 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-4624. -- Resolution: Done Fix Version/s: Not applicable > Test comparison operator at DSL level >

[jira] [Assigned] (BEAM-4599) Test arithmetic operators at the DSL level

2018-06-25 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4599: -- Assignee: Rui Wang > Test arithmetic operators at the DSL level >

[jira] [Closed] (BEAM-4600) Test logical operators at the DSL level

2018-06-25 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-4600. -- Resolution: Done Fix Version/s: Not applicable > Test logical operators at the DSL level >

[jira] [Created] (BEAM-4624) Test comparison operator at DSL level

2018-06-22 Thread Rui Wang (JIRA)
Rui Wang created BEAM-4624: -- Summary: Test comparison operator at DSL level Key: BEAM-4624 URL: https://issues.apache.org/jira/browse/BEAM-4624 Project: Beam Issue Type: Sub-task

[jira] [Assigned] (BEAM-4624) Test comparison operator at DSL level

2018-06-22 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4624: -- Assignee: Rui Wang (was: Xu Mingmin) > Test comparison operator at DSL level >

[jira] [Assigned] (BEAM-4601) BigQuery reads from pure SQL

2018-06-20 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4601: -- Assignee: Xu Mingmin (was: Rui Wang) > BigQuery reads from pure SQL > >

[jira] [Assigned] (BEAM-4601) BigQuery reads from pure SQL

2018-06-20 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4601: -- Assignee: Rui Wang (was: Xu Mingmin) > BigQuery reads from pure SQL > >

[jira] [Assigned] (BEAM-4600) Test logical operators at the DSL level

2018-06-20 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4600: -- Assignee: Rui Wang > Test logical operators at the DSL level > ---

[jira] [Commented] (BEAM-4601) BigQuery reads from pure SQL

2018-06-20 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16518732#comment-16518732 ] Rui Wang commented on BEAM-4601: Given this API:

[jira] [Created] (BEAM-4601) BigQuery reads from pure SQL

2018-06-20 Thread Rui Wang (JIRA)
Rui Wang created BEAM-4601: -- Summary: BigQuery reads from pure SQL Key: BEAM-4601 URL: https://issues.apache.org/jira/browse/BEAM-4601 Project: Beam Issue Type: New Feature Components:

[jira] [Updated] (BEAM-4647) Support String type in Create Table statement

2018-06-26 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4647: --- Issue Type: Improvement (was: Bug) > Support String type in Create Table statement >

[jira] [Updated] (BEAM-4710) Read complex types of data by SQL

2018-07-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4710: --- Description: Support reading complex types of data by SQL. Typical complex types include nested ROW, nested

[jira] [Created] (BEAM-4717) Improve SQL's PubSub integration test

2018-07-02 Thread Rui Wang (JIRA)
Rui Wang created BEAM-4717: -- Summary: Improve SQL's PubSub integration test Key: BEAM-4717 URL: https://issues.apache.org/jira/browse/BEAM-4717 Project: Beam Issue Type: Improvement

[jira] [Updated] (BEAM-4601) BigQuery reads from pure SQL

2018-07-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4601: --- Description: Right now Beam SQL can created a BigQuery table, however, read from BigQuery table is not

[jira] [Created] (BEAM-4710) Read complex types of data by SQL

2018-07-02 Thread Rui Wang (JIRA)
Rui Wang created BEAM-4710: -- Summary: Read complex types of data by SQL Key: BEAM-4710 URL: https://issues.apache.org/jira/browse/BEAM-4710 Project: Beam Issue Type: Bug Components:

[jira] [Updated] (BEAM-4601) BigQuery reads basic types from pure SQL

2018-07-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4601: --- Description: Right now Beam SQL can created a BigQuery table, however, read from BigQuery table is not

[jira] [Updated] (BEAM-4601) BigQuery reads basic types from pure SQL

2018-07-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4601: --- Summary: BigQuery reads basic types from pure SQL (was: BigQuery reads from pure SQL) > BigQuery reads

[jira] [Updated] (BEAM-4710) Read complex types of data by SQL

2018-07-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4710: --- Issue Type: Improvement (was: Bug) > Read complex types of data by SQL > - >

[jira] [Closed] (BEAM-4601) BigQuery reads basic types from pure SQL

2018-07-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-4601. -- Resolution: Done Fix Version/s: Not applicable > BigQuery reads basic types from pure SQL >

[jira] [Commented] (BEAM-4601) BigQuery reads from pure SQL

2018-06-21 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16519824#comment-16519824 ] Rui Wang commented on BEAM-4601: Another potential blocker is how we deal with MAP type.    Right now we

[jira] [Closed] (BEAM-4194) [SQL] Support LIMIT on Unbounded Data

2018-06-21 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-4194. -- Resolution: Done Fix Version/s: Not applicable > [SQL] Support LIMIT on Unbounded Data >

[jira] [Created] (BEAM-5065) Support DESC and ASC

2018-08-02 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5065: -- Summary: Support DESC and ASC Key: BEAM-5065 URL: https://issues.apache.org/jira/browse/BEAM-5065 Project: Beam Issue Type: Sub-task Components: dsl-sql

[jira] [Created] (BEAM-5064) Support ORDER BY in Global window

2018-08-02 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5064: -- Summary: Support ORDER BY in Global window Key: BEAM-5064 URL: https://issues.apache.org/jira/browse/BEAM-5064 Project: Beam Issue Type: Sub-task Components:

[jira] [Updated] (BEAM-5046) Implement Missing Standard SQL functions in BeamSQL

2018-07-30 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5046: --- Issue Type: Task (was: Improvement) > Implement Missing Standard SQL functions in BeamSQL >

[jira] [Created] (BEAM-5046) Implement Missing Standard SQL functions in BeamSQL

2018-07-30 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5046: -- Summary: Implement Missing Standard SQL functions in BeamSQL Key: BEAM-5046 URL: https://issues.apache.org/jira/browse/BEAM-5046 Project: Beam Issue Type: Improvement

[jira] [Updated] (BEAM-4736) Support reading decimal from BigQuery in Beam SQL

2018-07-27 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4736: --- Issue Type: Bug (was: Improvement) > Support reading decimal from BigQuery in Beam SQL >

[jira] [Updated] (BEAM-4808) Add an integration test for BeamSqlLine

2018-07-31 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-4808: --- Description: Test non group by window queries in Beam SQL Shell tutorial. > Add an integration test for

[jira] [Created] (BEAM-5054) e2e tests for BeamSQL line to test group by window

2018-07-31 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5054: -- Summary: e2e tests for BeamSQL line to test group by window Key: BEAM-5054 URL: https://issues.apache.org/jira/browse/BEAM-5054 Project: Beam Issue Type: Improvement

[jira] [Created] (BEAM-5072) SortRelNode is wrongly removed

2018-08-03 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5072: -- Summary: SortRelNode is wrongly removed Key: BEAM-5072 URL: https://issues.apache.org/jira/browse/BEAM-5072 Project: Beam Issue Type: Bug Components: dsl-sql

[jira] [Closed] (BEAM-5065) Support DESC and ASC

2018-08-03 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-5065. -- Resolution: Not A Problem Fix Version/s: Not applicable It turns out BeamSQL supports ASC and DESC for

[jira] [Created] (BEAM-5113) Test NOT LIKE

2018-08-08 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5113: -- Summary: Test NOT LIKE Key: BEAM-5113 URL: https://issues.apache.org/jira/browse/BEAM-5113 Project: Beam Issue Type: Sub-task Components: dsl-sql

[jira] [Assigned] (BEAM-5111) SUM0/SUM

2018-08-08 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-5111: -- Assignee: Rui Wang (was: Xu Mingmin) > SUM0/SUM > > > Key: BEAM-5111 >

[jira] [Created] (BEAM-5111) SUM0/SUM

2018-08-08 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5111: -- Summary: SUM0/SUM Key: BEAM-5111 URL: https://issues.apache.org/jira/browse/BEAM-5111 Project: Beam Issue Type: Sub-task Components: dsl-sql

[jira] [Assigned] (BEAM-4573) Test all SQL standard operators at the DSL level

2018-08-08 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-4573: -- Assignee: Rui Wang > Test all SQL standard operators at the DSL level >

[jira] [Commented] (BEAM-5064) Support ORDER BY in Global window

2018-08-08 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16573892#comment-16573892 ] Rui Wang commented on BEAM-5064: Right now it is not clear how we should sort with schema. Runners operate

[jira] [Comment Edited] (BEAM-5065) Support DESC and ASC

2018-08-08 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16568615#comment-16568615 ] Rui Wang edited comment on BEAM-5065 at 8/8/18 9:12 PM: It turns out BeamSQL

[jira] [Comment Edited] (BEAM-5064) Support ORDER BY in Global window

2018-08-08 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16573892#comment-16573892 ] Rui Wang edited comment on BEAM-5064 at 8/8/18 9:12 PM: Right now it is not clear

[jira] [Updated] (BEAM-5112) Investigate if Calcite can generate functions we need

2018-08-08 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5112: --- Summary: Investigate if Calcite can generate functions we need (was: Investigate if Calcite can auto

[jira] [Created] (BEAM-5112) Investigate if Calcite can auto generate functions we need

2018-08-08 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5112: -- Summary: Investigate if Calcite can auto generate functions we need Key: BEAM-5112 URL: https://issues.apache.org/jira/browse/BEAM-5112 Project: Beam Issue Type:

[jira] [Commented] (BEAM-5064) Support ORDER BY in Global window

2018-08-08 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16573818#comment-16573818 ] Rui Wang commented on BEAM-5064: TPC-DS queries require this: 

[jira] [Updated] (BEAM-5111) SUM0/SUM

2018-08-08 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5111: --- Description: SUM and SUM0 share the same code, either one could be wrong.  Should fix it. (was: SUM and SUM0

[jira] [Assigned] (BEAM-5128) Fix Floor and Ceil functions

2018-08-10 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reassigned BEAM-5128: -- Assignee: (was: Xu Mingmin) > Fix Floor and Ceil functions > > >

[jira] [Closed] (BEAM-5103) Test aggregation functions at DSL levels

2018-08-10 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-5103. -- Resolution: Fixed Fix Version/s: Not applicable > Test aggregation functions at DSL levels >

[jira] [Closed] (BEAM-5106) Test conditional functions at DSL level

2018-08-10 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-5106. -- Resolution: Fixed Fix Version/s: Not applicable > Test conditional functions at DSL level >

[jira] [Created] (BEAM-5131) Support ANY (sub query)

2018-08-10 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5131: -- Summary: Support ANY (sub query) Key: BEAM-5131 URL: https://issues.apache.org/jira/browse/BEAM-5131 Project: Beam Issue Type: Sub-task Components: dsl-sql

[jira] [Created] (BEAM-5130) Support ALL (sub query)

2018-08-10 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5130: -- Summary: Support ALL (sub query) Key: BEAM-5130 URL: https://issues.apache.org/jira/browse/BEAM-5130 Project: Beam Issue Type: Sub-task Components: dsl-sql

[jira] [Updated] (BEAM-5130) Support ALL (sub query)

2018-08-10 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5130: --- Description: Example:   SELECT order_id FROM order WHERE item_id = ALL (SELECT item_id FROM

[jira] [Created] (BEAM-5128) Fix Floor and Ceil functions

2018-08-10 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5128: -- Summary: Fix Floor and Ceil functions Key: BEAM-5128 URL: https://issues.apache.org/jira/browse/BEAM-5128 Project: Beam Issue Type: Sub-task Components:

[jira] [Created] (BEAM-5129) Support Rank() OVER

2018-08-10 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5129: -- Summary: Support Rank() OVER Key: BEAM-5129 URL: https://issues.apache.org/jira/browse/BEAM-5129 Project: Beam Issue Type: Sub-task Components: dsl-sql

[jira] [Closed] (BEAM-5074) Make BeamSqlRowComparator more general

2018-08-06 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-5074. -- Resolution: Duplicate Fix Version/s: Not applicable Consolidate this Jira with BEAM-5064 > Make

[jira] [Closed] (BEAM-5072) SortRelNode is wrongly removed

2018-08-06 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-5072. -- Resolution: Fixed Fix Version/s: Not applicable > SortRelNode is wrongly removed >

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

2018-08-03 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5073: -- Summary: Enable SortRemoveRule Key: BEAM-5073 URL: https://issues.apache.org/jira/browse/BEAM-5073 Project: Beam Issue Type: Improvement Components: dsl-sql

[jira] [Created] (BEAM-5074) Make BeamSqlRowComparator more general

2018-08-04 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5074: -- Summary: Make BeamSqlRowComparator more general Key: BEAM-5074 URL: https://issues.apache.org/jira/browse/BEAM-5074 Project: Beam Issue Type: Improvement

[jira] [Commented] (BEAM-5065) Support DESC and ASC

2018-08-04 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16569105#comment-16569105 ] Rui Wang commented on BEAM-5065: BeamSQL does not support ORDER BY DESC/ASC, which requires 

[jira] [Updated] (BEAM-5100) Test math functions at the DSL level

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5100: --- Summary: Test math functions at the DSL level (was: Test math functions) > Test math functions at the DSL

[jira] [Created] (BEAM-5106) Test conditional functions at DSL level

2018-08-07 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5106: -- Summary: Test conditional functions at DSL level Key: BEAM-5106 URL: https://issues.apache.org/jira/browse/BEAM-5106 Project: Beam Issue Type: Sub-task

[jira] [Updated] (BEAM-5100) Test arithmetic functions at the DSL level

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5100: --- Summary: Test arithmetic functions at the DSL level (was: Test math functions at the DSL level) > Test

[jira] [Created] (BEAM-5103) Test aggregation functions at DSL levels

2018-08-07 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5103: -- Summary: Test aggregation functions at DSL levels Key: BEAM-5103 URL: https://issues.apache.org/jira/browse/BEAM-5103 Project: Beam Issue Type: Sub-task

[jira] [Created] (BEAM-5102) Test Grouped window functions at DSL level

2018-08-07 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5102: -- Summary: Test Grouped window functions at DSL level Key: BEAM-5102 URL: https://issues.apache.org/jira/browse/BEAM-5102 Project: Beam Issue Type: Sub-task

[jira] [Created] (BEAM-5101) Improve Floor and Ceil tests at DSL level

2018-08-07 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5101: -- Summary: Improve Floor and Ceil tests at DSL level Key: BEAM-5101 URL: https://issues.apache.org/jira/browse/BEAM-5101 Project: Beam Issue Type: Sub-task

[jira] [Reopened] (BEAM-5074) Make BeamSqlRowComparator more general

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang reopened BEAM-5074: > Make BeamSqlRowComparator more general > -- > > Key:

[jira] [Closed] (BEAM-5074) Make BeamSqlRowComparator more general

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-5074. -- Resolution: Fixed > Make BeamSqlRowComparator more general > -- > >

[jira] [Commented] (BEAM-5074) Make BeamSqlRowComparator more general

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16572360#comment-16572360 ] Rui Wang commented on BEAM-5074: This issue was finally fixed. > Make BeamSqlRowComparator more general >

[jira] [Created] (BEAM-5100) Test math functions

2018-08-07 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5100: -- Summary: Test math functions Key: BEAM-5100 URL: https://issues.apache.org/jira/browse/BEAM-5100 Project: Beam Issue Type: Sub-task Components: dsl-sql

[jira] [Closed] (BEAM-4598) Test datetime operators at the DSL level

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-4598. -- Resolution: Fixed Fix Version/s: Not applicable This task might have already done by [~kenn] > Test

[jira] [Issue Comment Deleted] (BEAM-5074) Make BeamSqlRowComparator more general

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5074: --- Comment: was deleted (was: Consolidate this Jira with BEAM-5064) > Make BeamSqlRowComparator more general >

[jira] [Updated] (BEAM-5074) Make BeamSqlRowComparator more general

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5074: --- Description: BeamSqlRowComparator returns reversed comparison results (if a < b in terms of value, 

[jira] [Closed] (BEAM-4808) Add an integration test for BeamSqlLine

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed BEAM-4808. -- Resolution: Fixed Fix Version/s: Not applicable > Add an integration test for BeamSqlLine >

[jira] [Commented] (BEAM-4598) Test datetime operators at the DSL level

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-4598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16572388#comment-16572388 ] Rui Wang commented on BEAM-4598: https://github.com/apache/beam/pull/5743 > Test datetime operators at

[jira] [Updated] (BEAM-5102) Test Grouped window functions at DSL level

2018-08-07 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5102: --- Description: Test TUMBLE, HOP, SESSION and their starts and ends. > Test Grouped window functions at DSL

[jira] [Created] (BEAM-5142) Improve Pubsub e2e test

2018-08-13 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5142: -- Summary: Improve Pubsub e2e test Key: BEAM-5142 URL: https://issues.apache.org/jira/browse/BEAM-5142 Project: Beam Issue Type: Improvement Components: dsl-sql

[jira] [Created] (BEAM-5140) Add EXTERNAL to CREATE TABLE statement

2018-08-13 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5140: -- Summary: Add EXTERNAL to CREATE TABLE statement Key: BEAM-5140 URL: https://issues.apache.org/jira/browse/BEAM-5140 Project: Beam Issue Type: Improvement

[jira] [Created] (BEAM-5141) Improve error message when SET a undefined property

2018-08-13 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5141: -- Summary: Improve error message when SET a undefined property Key: BEAM-5141 URL: https://issues.apache.org/jira/browse/BEAM-5141 Project: Beam Issue Type: Improvement

[jira] [Created] (BEAM-5157) Improve user friendliness of using SET

2018-08-15 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5157: -- Summary: Improve user friendliness of using SET Key: BEAM-5157 URL: https://issues.apache.org/jira/browse/BEAM-5157 Project: Beam Issue Type: Improvement

[jira] [Updated] (BEAM-5159) Too many retries when failed to write to BigQuery table

2018-08-15 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5159: --- Summary: Too many retries when failed to write to BigQuery table (was: Too many retries when cannot write

[jira] [Updated] (BEAM-5159) Too many retries when cannot write to BigQuery table

2018-08-15 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5159: --- Description: BeamSQL retries multiple times when inserting illegal values to BigQuery. It might worth

[jira] [Updated] (BEAM-5159) Too many retries when cannot write to BigQuery table

2018-08-15 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5159: --- Description: BeamSQL retries multiple times when inserting illegal values to BigQuery. It might worth

[jira] [Created] (BEAM-5158) SQL Shell Improvement

2018-08-15 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5158: -- Summary: SQL Shell Improvement Key: BEAM-5158 URL: https://issues.apache.org/jira/browse/BEAM-5158 Project: Beam Issue Type: Improvement Components: dsl-sql

[jira] [Updated] (BEAM-5157) Improve user friendliness of using SET

2018-08-15 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5157: --- Issue Type: Sub-task (was: Improvement) Parent: BEAM-5158 > Improve user friendliness of using SET >

[jira] [Created] (BEAM-5159) Too many/infinity retries when cannot write to BigQuery table

2018-08-15 Thread Rui Wang (JIRA)
Rui Wang created BEAM-5159: -- Summary: Too many/infinity retries when cannot write to BigQuery table Key: BEAM-5159 URL: https://issues.apache.org/jira/browse/BEAM-5159 Project: Beam Issue Type:

[jira] [Updated] (BEAM-5159) Too many retries when cannot write to BigQuery table

2018-08-15 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5159: --- Summary: Too many retries when cannot write to BigQuery table (was: Too many/infinity retries when cannot

[jira] [Updated] (BEAM-5158) BeamSQL and SQL Shell Improvement

2018-08-15 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5158: --- Summary: BeamSQL and SQL Shell Improvement (was: SQL Shell Improvement) > BeamSQL and SQL Shell Improvement

[jira] [Updated] (BEAM-5157) Improve user friendliness of using SET

2018-08-15 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5157: --- Description: Right now, SET only supports a few defined property in Beam. However, when users have some

[jira] [Updated] (BEAM-5141) Improve error message when SET unregistered options

2018-08-13 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/BEAM-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated BEAM-5141: --- Summary: Improve error message when SET unregistered options (was: Improve error message when SET a

  1   2   3   >