[
https://issues.apache.org/jira/browse/BEAM-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Xu closed BEAM-3161.
--------------------------
Resolution: Fixed
> Cannot output with timestamp XXXX
> ---------------------------------
>
> Key: BEAM-3161
> URL: https://issues.apache.org/jira/browse/BEAM-3161
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql
> Reporter: Xu Mingmin
> Assignee: Xu Mingmin
> Fix For: 2.3.0
>
>
> BeamSQL throws exception when running query
> {code}
> select siteId, count(*), TUMBLE_START(unix_timestamp_to_date(eventTimestamp),
> INTERVAL '1' HOUR) from RHEOS_SOJEVENT_TOTAL GROUP BY siteId,
> TUMBLE(unix_timestamp_to_date(eventTimestamp), INTERVAL '1' HOUR)
> {code}
> Exception details:
> {code}
> Caused by: java.lang.IllegalArgumentException: Cannot output with timestamp
> 2017-11-08T21:37:46.000Z. Output timestamps must be no earlier than the
> timestamp of the current input (2017-11-08T21:37:49.322Z) minus the allowed
> skew (0 milliseconds). See the DoFn#getAllowedTimestampSkew() Javadoc for
> details on changing the allowed skew.
> at
> org.apache.beam.runners.core.SimpleDoFnRunner$DoFnProcessContext.checkTimestamp(SimpleDoFnRunner.java:463)
> at
> org.apache.beam.runners.core.SimpleDoFnRunner$DoFnProcessContext.outputWithTimestamp(SimpleDoFnRunner.java:429)
> at org.apache.Caused by: java.lang.IllegalArgumentException: Cannot
> output with timestamp 2017-11-08T21:37:46.000Z. Output timestamps must be no
> earlier than the timestamp of the current input (2017-11-08T21:37:49.322Z)
> minus the allowed skew (0 milliseconds). See the
> DoFn#getAllowedTimestampSkew() Javadoc for details on changing the allowed
> skew.
> at
> org.apache.beam.runners.core.SimpleDoFnRunner$DoFnProcessContext.checkTimestamp(SimpleDoFnRunner.java:463)
> at
> org.apache.beam.runners.core.SimpleDoFnRunner$DoFnProcessContext.outputWithTimestamp(SimpleDoFnRunner.java:429)
> at
> org.apache.beam.sdk.transforms.WithTimestamps$AddTimestampsDoFn.processElement(WithTimestamps.java:138)beam.sdk.transforms.WithTimestamps$AddTimestampsDoFn.processElement(WithTimestamps.java:138)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
