Xu Mingmin created BEAM-3161:
--------------------------------
Summary: 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)
