[ 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)