[ https://issues.apache.org/jira/browse/BEAM-5690?focusedWorklogId=331253&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-331253 ]
ASF GitHub Bot logged work on BEAM-5690: ---------------------------------------- Author: ASF GitHub Bot Created on: 21/Oct/19 08:03 Start Date: 21/Oct/19 08:03 Worklog Time Spent: 10m Work Description: echauchot commented on issue #9567: [BEAM-5690] Fix Zero value issue with GroupByKey/CountByKey in SparkRunner URL: https://github.com/apache/beam/pull/9567#issuecomment-544397376 Run Spark ValidatesRunner ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 331253) Time Spent: 3.5h (was: 3h 20m) > Issue with GroupByKey in BeamSql using SparkRunner > -------------------------------------------------- > > Key: BEAM-5690 > URL: https://issues.apache.org/jira/browse/BEAM-5690 > Project: Beam > Issue Type: Task > Components: runner-spark > Reporter: Kenneth Knowles > Priority: Major > Time Spent: 3.5h > Remaining Estimate: 0h > > Reported on user@ > {quote}We are trying to setup a pipeline with using BeamSql and the trigger > used is default (AfterWatermark crosses the window). > Below is the pipeline: > > KafkaSource (KafkaIO) > ---> Windowing (FixedWindow 1min) > ---> BeamSql > ---> KafkaSink (KafkaIO) > > We are using Spark Runner for this. > The BeamSql query is: > {code}select Col3, count(*) as count_col1 from PCOLLECTION GROUP BY Col3{code} > We are grouping by Col3 which is a string. It can hold values string[0-9]. > > The records are getting emitted out at 1 min to kafka sink, but the output > record in kafka is not as expected. > Below is the output observed: (WST and WET are indicators for window start > time and window end time) > {code} > {"count_col1":1,"Col3":"string5","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":3,"Col3":"string7","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":2,"Col3":"string8","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":1,"Col3":"string2","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":1,"Col3":"string6","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":0,"Col3":"string6","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":0,"Col3":"string6","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":0,"Col3":"string6","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":0,"Col3":"string6","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":0,"Col3":"string6","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0000 +0000"} > {"count_col1":0,"Col3":"string6","WST":"2018-10-09 09-55-00 0000 > +0000","WET":"2018-10-09 09-56-00 0} > {code} > {quote} -- This message was sent by Atlassian Jira (v8.3.4#803005)