See
<https://builds.apache.org/job/beam_PostCommit_Java_Nexmark_Direct/2605/display/redirect?page=changes>
Changes:
[github] Merge pull request #8385: Fix broken parsing of uuid
------------------------------------------
[...truncated 287.16 KB...]
0014 *** not run ***
==========================================================================================
2019-04-25T19:35:49.586Z Generating 100000 events in batch mode
Apr 25, 2019 7:35:49 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `AuctionBids`.`auction`, `AuctionBids`.`num`
FROM (SELECT `B1`.`auction`, COUNT(*) AS `num`, HOP_START(`B1`.`dateTime`,
INTERVAL '5' SECOND, INTERVAL '10' SECOND) AS `starttime`
FROM `beam`.`Bid` AS `B1`
GROUP BY `B1`.`auction`, HOP(`B1`.`dateTime`, INTERVAL '5' SECOND, INTERVAL
'10' SECOND)) AS `AuctionBids`
INNER JOIN (SELECT MAX(`CountBids`.`num`) AS `maxnum`, `CountBids`.`starttime`
FROM (SELECT COUNT(*) AS `num`, HOP_START(`B2`.`dateTime`, INTERVAL '5' SECOND,
INTERVAL '10' SECOND) AS `starttime`
FROM `beam`.`Bid` AS `B2`
GROUP BY `B2`.`auction`, HOP(`B2`.`dateTime`, INTERVAL '5' SECOND, INTERVAL
'10' SECOND)) AS `CountBids`
GROUP BY `CountBids`.`starttime`) AS `MaxBids` ON `AuctionBids`.`starttime` =
`MaxBids`.`starttime` AND `AuctionBids`.`num` >= `MaxBids`.`maxnum`
Apr 25, 2019 7:35:49 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(auction=[$0], num=[$1])
LogicalJoin(condition=[AND(=($2, $4), >=($1, $3))], joinType=[inner])
LogicalProject(auction=[$0], num=[$2], starttime=[$1])
LogicalAggregate(group=[{0, 1}], num=[COUNT()])
LogicalProject(auction=[$0], $f1=[HOP($3, 5000:INTERVAL SECOND,
10000:INTERVAL SECOND)])
BeamIOSourceRel(table=[[beam, Bid]])
LogicalProject(maxnum=[$1], starttime=[$0])
LogicalAggregate(group=[{0}], maxnum=[MAX($1)])
LogicalProject(starttime=[$1], num=[$2])
LogicalAggregate(group=[{0, 1}], num=[COUNT()])
LogicalProject(auction=[$0], $f1=[HOP($3, 5000:INTERVAL SECOND,
10000:INTERVAL SECOND)])
BeamIOSourceRel(table=[[beam, Bid]])
Apr 25, 2019 7:35:49 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], proj#0..1=[{exprs}])
BeamJoinRel(condition=[AND(=($2, $4), >=($1, $3))], joinType=[inner])
BeamCalcRel(expr#0..2=[{inputs}], auction=[$t0], num=[$t2], starttime=[$t1])
BeamAggregationRel(group=[{0, 1}], num=[COUNT()],
window=[SlidingWindows($1, PT5S, PT10S, PT0S)])
BeamCalcRel(expr#0..4=[{inputs}], auction=[$t0], $f1=[$t3])
BeamIOSourceRel(table=[[beam, Bid]])
BeamCalcRel(expr#0..1=[{inputs}], maxnum=[$t1], starttime=[$t0])
BeamAggregationRel(group=[{0}], maxnum=[MAX($1)])
BeamCalcRel(expr#0..2=[{inputs}], starttime=[$t1], num=[$t2])
BeamAggregationRel(group=[{0, 1}], num=[COUNT()],
window=[SlidingWindows($1, PT5S, PT10S, PT0S)])
BeamCalcRel(expr#0..4=[{inputs}], auction=[$t0], $f1=[$t3])
BeamIOSourceRel(table=[[beam, Bid]])
2019-04-25T19:35:49.954Z Running query:AVERAGE_SELLING_PRICE_BY_SELLER;
exportSummaryToBigQuery:true; numEvents:10000
2019-04-25T19:35:49.954Z skipping since configuration is not implemented
2019-04-25T19:35:49.954Z Running query:HIGHEST_BID; exportSummaryToBigQuery:true
==========================================================================================
Run started 2019-04-25T19:35:17.471Z and ran for PT32.483S
Default configuration:
{"debug":true,"query":null,"sourceType":"DIRECT","sinkType":"DEVNULL","exportSummaryToBigQuery":false,"pubSubMode":"COMBINED","sideInputType":"DIRECT","sideInputRowCount":500,"sideInputNumShards":3,"sideInputUrl":null,"sessionGap":{"standardDays":0,"standardHours":0,"standardMinutes":10,"standardSeconds":600,"millis":600000},"numEvents":100000,"numEventGenerators":100,"rateShape":"SINE","firstEventRate":10000,"nextEventRate":10000,"rateUnit":"PER_SECOND","ratePeriodSec":600,"preloadSeconds":0,"streamTimeout":240,"isRateLimited":false,"useWallclockEventTime":false,"avgPersonByteSize":200,"avgAuctionByteSize":500,"avgBidByteSize":100,"hotAuctionRatio":2,"hotSellersRatio":4,"hotBiddersRatio":4,"windowSizeSec":10,"windowPeriodSec":5,"watermarkHoldbackSec":0,"numInFlightAuctions":100,"numActivePeople":1000,"coderStrategy":"HAND","cpuDelayMs":0,"diskBusyBytes":0,"auctionSkip":123,"fanout":5,"maxAuctionsWaitingTime":600,"occasionalDelaySec":3,"probDelayedEvent":0.1,"maxLogEvents":100000,"usePubsubPublishTime":false,"outOfOrderGroupSize":1}
Configurations:
Conf Description
0000 query:PASSTHROUGH; exportSummaryToBigQuery:true
0001 query:CURRENCY_CONVERSION; exportSummaryToBigQuery:true
Exception in thread "main" 0002 query:SELECTION; exportSummaryToBigQuery:true
0003 query:LOCAL_ITEM_SUGGESTION; exportSummaryToBigQuery:true
0004 query:AVERAGE_PRICE_FOR_CATEGORY; exportSummaryToBigQuery:true;
numEvents:10000
0005 query:HOT_ITEMS; exportSummaryToBigQuery:true
0006 query:AVERAGE_SELLING_PRICE_BY_SELLER; exportSummaryToBigQuery:true;
numEvents:10000
0007 query:HIGHEST_BID; exportSummaryToBigQuery:true
0008 query:MONITOR_NEW_USERS; exportSummaryToBigQuery:true
0009 query:WINNING_BIDS; exportSummaryToBigQuery:true; numEvents:10000
java.lang.RuntimeException: java.lang.UnsupportedOperationException: Non
equi-join is not supported!
0010 query:LOG_TO_SHARDED_FILES; exportSummaryToBigQuery:true
at org.apache.beam.sdk.nexmark.Main.runAll(Main.java:128)
0011 query:USER_SESSIONS; exportSummaryToBigQuery:true
at org.apache.beam.sdk.nexmark.Main.main(Main.java:415)
0012 query:PROCESSING_TIME_WINDOWS; exportSummaryToBigQuery:true
0013 query:BOUNDED_SIDE_INPUT_JOIN; exportSummaryToBigQuery:true
0014 query:SESSION_SIDE_INPUT_JOIN; exportSummaryToBigQuery:true
Performance:
Conf Runtime(sec) (Baseline) Events(/sec) (Baseline) Results
(Baseline)
Caused by: java.lang.UnsupportedOperationException: Non equi-join is not
supported!
0000 10.0 10036.1 92000
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamJoinRel.extractJoinPairOfRexNodes(BeamJoinRel.java:569)
0001 6.1 16270.7 92000
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamJoinRel.extractJoinRexNodes(BeamJoinRel.java:554)
0002 2.6 38255.5 351
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamJoinRel.access$900(BeamJoinRel.java:101)
0003 5.0 19996.0 580
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamJoinRel$ExtractJoinKeys.expand(BeamJoinRel.java:257)
0004 *** not run ***
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamJoinRel$ExtractJoinKeys.expand(BeamJoinRel.java:240)
0005 *** not run ***
at org.apache.beam.sdk.Pipeline.applyInternal(Pipeline.java:537)
0006 *** not run ***
at org.apache.beam.sdk.Pipeline.applyTransform(Pipeline.java:471)
0007 *** not run ***
at
org.apache.beam.sdk.values.PCollectionList.apply(PCollectionList.java:176)
0008 *** not run ***
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamJoinRel$StandardJoin.expand(BeamJoinRel.java:324)
0009 *** not run ***
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamJoinRel$StandardJoin.expand(BeamJoinRel.java:317)
0010 *** not run ***
at org.apache.beam.sdk.Pipeline.applyInternal(Pipeline.java:537)
0011 *** not run ***
at org.apache.beam.sdk.Pipeline.applyTransform(Pipeline.java:488)
0012 *** not run ***
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamSqlRelUtils.toPCollection(BeamSqlRelUtils.java:66)
0013 *** not run ***
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamSqlRelUtils.lambda$buildPCollectionList$0(BeamSqlRelUtils.java:47)
0014 *** not run ***
at
java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
==========================================================================================
at java.util.Iterator.forEachRemaining(Iterator.java:116)
at
java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
2019-04-25T19:35:49.956Z Generating 100000 events in batch mode
at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
at
java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
at
java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at
java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamSqlRelUtils.buildPCollectionList(BeamSqlRelUtils.java:48)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamSqlRelUtils.toPCollection(BeamSqlRelUtils.java:64)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamSqlRelUtils.toPCollection(BeamSqlRelUtils.java:36)
at
org.apache.beam.sdk.extensions.sql.SqlTransform.expand(SqlTransform.java:111)
at
org.apache.beam.sdk.extensions.sql.SqlTransform.expand(SqlTransform.java:79)
at org.apache.beam.sdk.Pipeline.applyInternal(Pipeline.java:537)
at org.apache.beam.sdk.Pipeline.applyTransform(Pipeline.java:471)
at
org.apache.beam.sdk.values.PCollectionTuple.apply(PCollectionTuple.java:248)
at
org.apache.beam.sdk.nexmark.queries.sql.SqlQuery5.expand(SqlQuery5.java:106)
at
org.apache.beam.sdk.nexmark.queries.sql.SqlQuery5.expand(SqlQuery5.java:55)
at org.apache.beam.sdk.Pipeline.applyInternal(Pipeline.java:537)
at org.apache.beam.sdk.Pipeline.applyTransform(Pipeline.java:471)
at org.apache.beam.sdk.values.PCollection.apply(PCollection.java:357)
at
org.apache.beam.sdk.nexmark.queries.NexmarkQuery.expand(NexmarkQuery.java:89)
at
org.apache.beam.sdk.nexmark.queries.NexmarkQuery.expand(NexmarkQuery.java:33)
at org.apache.beam.sdk.Pipeline.applyInternal(Pipeline.java:537)
at org.apache.beam.sdk.Pipeline.applyTransform(Pipeline.java:471)
at org.apache.beam.sdk.values.PCollection.apply(PCollection.java:357)
at
org.apache.beam.sdk.nexmark.NexmarkLauncher.run(NexmarkLauncher.java:1161)
at org.apache.beam.sdk.nexmark.Main$Run.call(Main.java:90)
at org.apache.beam.sdk.nexmark.Main$Run.call(Main.java:79)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Apr 25, 2019 7:35:49 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `B`.`auction`, `B`.`price`, `B`.`bidder`, `B`.`dateTime`, `B`.`extra`
FROM (SELECT `B`.`auction`, `B`.`price`, `B`.`bidder`, `B`.`dateTime`,
`B`.`extra`, TUMBLE_START(`B`.`dateTime`, INTERVAL '10' SECOND) AS `starttime`
FROM `beam`.`Bid` AS `B`
GROUP BY `B`.`auction`, `B`.`price`, `B`.`bidder`, `B`.`dateTime`, `B`.`extra`,
TUMBLE(`B`.`dateTime`, INTERVAL '10' SECOND)) AS `B`
INNER JOIN (SELECT MAX(`B1`.`price`) AS `maxprice`,
TUMBLE_START(`B1`.`dateTime`, INTERVAL '10' SECOND) AS `starttime`
FROM `beam`.`Bid` AS `B1`
GROUP BY TUMBLE(`B1`.`dateTime`, INTERVAL '10' SECOND)) AS `B1` ON
`B`.`starttime` = `B1`.`starttime` AND `B`.`price` = `B1`.`maxprice`
Apr 25, 2019 7:35:49 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(auction=[$0], price=[$1], bidder=[$2], dateTime=[$3], extra=[$4])
LogicalJoin(condition=[AND(=($5, $7), =($1, $6))], joinType=[inner])
LogicalProject(auction=[$0], price=[$1], bidder=[$2], dateTime=[$3],
extra=[$4], starttime=[$5])
LogicalAggregate(group=[{0, 1, 2, 3, 4, 5}])
LogicalProject(auction=[$0], price=[$2], bidder=[$1], dateTime=[$3],
extra=[$4], $f5=[TUMBLE($3, 10000:INTERVAL SECOND)])
BeamIOSourceRel(table=[[beam, Bid]])
LogicalProject(maxprice=[$1], starttime=[$0])
LogicalAggregate(group=[{0}], maxprice=[MAX($1)])
LogicalProject($f0=[TUMBLE($3, 10000:INTERVAL SECOND)], price=[$2])
BeamIOSourceRel(table=[[beam, Bid]])
Apr 25, 2019 7:35:50 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..7=[{inputs}], proj#0..4=[{exprs}])
BeamJoinRel(condition=[AND(=($5, $7), =($1, $6))], joinType=[inner])
BeamCalcRel(expr#0..5=[{inputs}], proj#0..5=[{exprs}])
BeamAggregationRel(group=[{0, 1, 2, 3, 4, 5}], window=[FixedWindows($5,
PT10S, PT0S)])
BeamCalcRel(expr#0..4=[{inputs}], auction=[$t0], price=[$t2],
bidder=[$t1], dateTime=[$t3], extra=[$t4], $f5=[$t3])
BeamIOSourceRel(table=[[beam, Bid]])
BeamCalcRel(expr#0..1=[{inputs}], maxprice=[$t1], starttime=[$t0])
BeamAggregationRel(group=[{0}], maxprice=[MAX($1)],
window=[FixedWindows($0, PT10S, PT0S)])
BeamCalcRel(expr#0..4=[{inputs}], $f0=[$t3], price=[$t2])
BeamIOSourceRel(table=[[beam, Bid]])
2019-04-25T19:37:13.996Z Waiting for main pipeline to 'finish'
2019-04-25T19:37:13.996Z DONE SqlQuery7
2019-04-25T19:37:13.997Z Running query:MONITOR_NEW_USERS;
exportSummaryToBigQuery:true
2019-04-25T19:37:13.998Z skipping since configuration is not implemented
2019-04-25T19:37:13.998Z Running query:WINNING_BIDS;
exportSummaryToBigQuery:true; numEvents:10000
2019-04-25T19:37:13.998Z skipping since configuration is not implemented
2019-04-25T19:37:13.998Z Running query:LOG_TO_SHARDED_FILES;
exportSummaryToBigQuery:true
2019-04-25T19:37:13.998Z skipping since configuration is not implemented
2019-04-25T19:37:13.998Z Running query:USER_SESSIONS;
exportSummaryToBigQuery:true
2019-04-25T19:37:13.999Z skipping since configuration is not implemented
2019-04-25T19:37:13.999Z Running query:PROCESSING_TIME_WINDOWS;
exportSummaryToBigQuery:true
2019-04-25T19:37:13.999Z skipping since configuration is not implemented
2019-04-25T19:37:13.999Z Running query:BOUNDED_SIDE_INPUT_JOIN;
exportSummaryToBigQuery:true
2019-04-25T19:37:14.001Z Generating 100000 events in batch mode
Apr 25, 2019 7:37:14 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQL:
WITH `bid_with_side` (`auction`, `bidder`, `price`, `dateTime`, `extra`,
`side_id`) AS (SELECT `bid`.`auction`, `bid`.`bidder`, `bid`.`price`,
`bid`.`dateTime`, `bid`.`extra`, CAST(MOD(`bid`.`bidder`, 500) AS BIGINT) AS
`side_id`
FROM `beam`.`bid` AS `bid`) (SELECT `bid_with_side`.`auction`,
`bid_with_side`.`bidder`, `bid_with_side`.`price`, `bid_with_side`.`dateTime`,
`side`.`extra`
FROM `bid_with_side` AS `bid_with_side`,
`beam`.`side` AS `side`
WHERE `bid_with_side`.`side_id` = `side`.`id`)
Apr 25, 2019 7:37:14 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(auction=[$0], bidder=[$1], price=[$2], dateTime=[$3], extra=[$7])
LogicalFilter(condition=[=($5, $6)])
LogicalJoin(condition=[true], joinType=[inner])
LogicalProject(auction=[$0], bidder=[$1], price=[$2], dateTime=[$3],
extra=[$4], side_id=[CAST(MOD($1, 500)):BIGINT NOT NULL])
BeamIOSourceRel(table=[[beam, bid]])
BeamIOSourceRel(table=[[beam, side]])
Apr 25, 2019 7:37:14 PM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..7=[{inputs}], proj#0..3=[{exprs}], extra=[$t7])
BeamJoinRel(condition=[=($5, $6)], joinType=[inner])
BeamCalcRel(expr#0..4=[{inputs}], expr#5=[500], expr#6=[MOD($t1, $t5)],
expr#7=[CAST($t6):BIGINT NOT NULL], proj#0..4=[{exprs}], side_id=[$t7])
BeamIOSourceRel(table=[[beam, bid]])
BeamIOSourceRel(table=[[beam, side]])
2019-04-25T19:37:26.965Z Waiting for main pipeline to 'finish'
2019-04-25T19:37:26.965Z DONE SqlBoundedSideInputJoin
2019-04-25T19:37:26.966Z Running query:SESSION_SIDE_INPUT_JOIN;
exportSummaryToBigQuery:true
2019-04-25T19:37:26.967Z skipping since configuration is not implemented
> Task :beam-sdks-java-nexmark:run FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':beam-sdks-java-nexmark:run'.
> Process 'command '/usr/local/asfpackages/java/jdk1.8.0_191/bin/java''
> finished with non-zero exit value 1
* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug
option to get more log output. Run with --scan to get full insights.
* Get more help at https://help.gradle.org
Deprecated Gradle features were used in this build, making it incompatible with
Gradle 6.0.
Use '--warning-mode all' to show the individual deprecation warnings.
See
https://docs.gradle.org/5.2.1/userguide/command_line_interface.html#sec:command_line_warnings
BUILD FAILED in 2m 25s
65 actionable tasks: 2 executed, 63 up-to-date
Publishing build scan...
https://gradle.com/s/ydcji2g6ugx7y
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
