[jira] [Updated] (FLINK-33010) NPE when using GREATEST() in Flink SQL
[ https://issues.apache.org/jira/browse/FLINK-33010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hector Rios updated FLINK-33010: Description: Hi, I see NPEs in flink 1.14 and flink 1.16 when running queries with GREATEST() and timestamps. Below is an example to help in reproducing the issue. {code:java} CREATE TEMPORARY VIEW Positions AS SELECT SecurityId, ccy1, CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestamp FROM (VALUES (1, 'USD', '2022-01-01'), (2, 'GBP', '2022-02-02'), (3, 'GBX', '2022-03-03'), (4, 'GBX', '2022-04-4')) AS ccy(SecurityId, ccy1, publishTimestamp); CREATE TEMPORARY VIEW Benchmarks AS SELECT SecurityId, ccy1, CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestamp FROM (VALUES (3, 'USD', '2023-01-01'), (4, 'GBP', '2023-02-02'), (5, 'GBX', '2023-03-03'), (6, 'GBX', '2023-04-4')) AS ccy(SecurityId, ccy1, publishTimestamp); SELECT *, GREATEST( IFNULL(Positions.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))), IFNULL(Benchmarks.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))) ) FROM Positions FULL JOIN Benchmarks ON Positions.SecurityId = Benchmarks.SecurityId {code} Using "IF" is a workaround at the moment instead of using "GREATEST" was: Hi, I see NPEs in flink 1.14 and flink 1.16 when running queries with GREATEST() and timestamps. Below is an example to help in reproducing the issue. {code:java} CREATE TEMPORARY VIEW Positions AS SELECT SecurityId, ccy1, CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestampFROM (VALUES (1, 'USD', '2022-01-01'), (2, 'GBP', '2022-02-02'), (3, 'GBX', '2022-03-03'), (4, 'GBX', '2022-04-4')) AS ccy(SecurityId, ccy1, publishTimestamp); CREATE TEMPORARY VIEW Benchmarks AS SELECT SecurityId, ccy1, CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestampFROM (VALUES (3, 'USD', '2023-01-01'), (4, 'GBP', '2023-02-02'), (5, 'GBX', '2023-03-03'), (6, 'GBX', '2023-04-4')) AS ccy(SecurityId, ccy1, publishTimestamp); SELECT *, GREATEST( IFNULL(Positions.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))), IFNULL(Benchmarks.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))) ) FROM Positions FULL JOIN Benchmarks ON Positions.SecurityId = Benchmarks.SecurityId {code} Using "IF" is a workaround at the moment instead of using "GREATEST" > NPE when using GREATEST() in Flink SQL > -- > > Key: FLINK-33010 > URL: https://issues.apache.org/jira/browse/FLINK-33010 > Project: Flink > Issue Type: Bug > Components: Table SQL / API, Table SQL / Planner >Affects Versions: 1.16.1, 1.16.2 >Reporter: Hector Rios >Priority: Minor > > Hi, > I see NPEs in flink 1.14 and flink 1.16 when running queries with GREATEST() > and timestamps. Below is an example to help in reproducing the issue. > {code:java} > CREATE TEMPORARY VIEW Positions AS > SELECT > SecurityId, > ccy1, > CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestamp > FROM (VALUES > (1, 'USD', '2022-01-01'), > (2, 'GBP', '2022-02-02'), > (3, 'GBX', '2022-03-03'), > (4, 'GBX', '2022-04-4')) > AS ccy(SecurityId, ccy1, publishTimestamp); > CREATE TEMPORARY VIEW Benchmarks AS > SELECT > SecurityId, > ccy1, > CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestamp > FROM (VALUES > (3, 'USD', '2023-01-01'), > (4, 'GBP', '2023-02-02'), > (5, 'GBX', '2023-03-03'), > (6, 'GBX', '2023-04-4')) > AS ccy(SecurityId, ccy1, publishTimestamp); > SELECT *, > GREATEST( > IFNULL(Positions.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))), > IFNULL(Benchmarks.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))) > ) > FROM Positions > FULL JOIN Benchmarks ON Positions.SecurityId = Benchmarks.SecurityId {code} > > Using "IF" is a workaround at the moment instead of using "GREATEST" > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (FLINK-33010) NPE when using GREATEST() in Flink SQL
Hector Rios created FLINK-33010: --- Summary: NPE when using GREATEST() in Flink SQL Key: FLINK-33010 URL: https://issues.apache.org/jira/browse/FLINK-33010 Project: Flink Issue Type: Bug Components: Table SQL / API, Table SQL / Planner Affects Versions: 1.16.2, 1.16.1 Reporter: Hector Rios Hi, I see NPEs in flink 1.14 and flink 1.16 when running queries with GREATEST() and timestamps. Below is an example to help in reproducing the issue. {code:java} CREATE TEMPORARY VIEW Positions AS SELECT SecurityId, ccy1, CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestampFROM (VALUES (1, 'USD', '2022-01-01'), (2, 'GBP', '2022-02-02'), (3, 'GBX', '2022-03-03'), (4, 'GBX', '2022-04-4')) AS ccy(SecurityId, ccy1, publishTimestamp); CREATE TEMPORARY VIEW Benchmarks AS SELECT SecurityId, ccy1, CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestampFROM (VALUES (3, 'USD', '2023-01-01'), (4, 'GBP', '2023-02-02'), (5, 'GBX', '2023-03-03'), (6, 'GBX', '2023-04-4')) AS ccy(SecurityId, ccy1, publishTimestamp); SELECT *, GREATEST( IFNULL(Positions.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))), IFNULL(Benchmarks.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))) ) FROM Positions FULL JOIN Benchmarks ON Positions.SecurityId = Benchmarks.SecurityId {code} Using "IF" is a workaround at the moment instead of using "GREATEST" -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (FLINK-33010) NPE when using GREATEST() in Flink SQL
Hector Rios created FLINK-33010: --- Summary: NPE when using GREATEST() in Flink SQL Key: FLINK-33010 URL: https://issues.apache.org/jira/browse/FLINK-33010 Project: Flink Issue Type: Bug Components: Table SQL / API, Table SQL / Planner Affects Versions: 1.16.2, 1.16.1 Reporter: Hector Rios Hi, I see NPEs in flink 1.14 and flink 1.16 when running queries with GREATEST() and timestamps. Below is an example to help in reproducing the issue. {code:java} CREATE TEMPORARY VIEW Positions AS SELECT SecurityId, ccy1, CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestampFROM (VALUES (1, 'USD', '2022-01-01'), (2, 'GBP', '2022-02-02'), (3, 'GBX', '2022-03-03'), (4, 'GBX', '2022-04-4')) AS ccy(SecurityId, ccy1, publishTimestamp); CREATE TEMPORARY VIEW Benchmarks AS SELECT SecurityId, ccy1, CAST(publishTimestamp AS TIMESTAMP(3)) as publishTimestampFROM (VALUES (3, 'USD', '2023-01-01'), (4, 'GBP', '2023-02-02'), (5, 'GBX', '2023-03-03'), (6, 'GBX', '2023-04-4')) AS ccy(SecurityId, ccy1, publishTimestamp); SELECT *, GREATEST( IFNULL(Positions.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))), IFNULL(Benchmarks.publishTimestamp,CAST('1970-1-1' AS TIMESTAMP(3))) ) FROM Positions FULL JOIN Benchmarks ON Positions.SecurityId = Benchmarks.SecurityId {code} Using "IF" is a workaround at the moment instead of using "GREATEST" -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (FLINK-25920) Allow receiving updates of CommittableSummary
[ https://issues.apache.org/jira/browse/FLINK-25920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17729290#comment-17729290 ] Hector Rios commented on FLINK-25920: - Hello all. To add more context to this issue, I was working with a customer who was experiencing this error. I found the content in the following issue really helpful. https://issues.apache.org/jira/browse/FLINK-30238 In the specific case of this customer, the issue was being caused by including --drain on their call to stop-with-savepoint. I was able to recreate the issue using a very simple job reading from a Kafka source and sinking back to Kafka. Unfortunately, it was not consistent across versions. I was able to reproduce it on 1.15.3 but not on 1.15.4. Granted, it was a quick test, and I wanted to do a more thorough test to reproduce the issue consistently. One interesting wrinkle on this one is that it occurs in 1.15.x, but the same job deployed into 1.14.x does not produce the issue. Thanks. > Allow receiving updates of CommittableSummary > - > > Key: FLINK-25920 > URL: https://issues.apache.org/jira/browse/FLINK-25920 > Project: Flink > Issue Type: Sub-task > Components: API / DataStream, Connectors / Common >Affects Versions: 1.15.0, 1.16.0 >Reporter: Fabian Paul >Priority: Major > > In the case of unaligned checkpoints, it might happen that the checkpoint > barrier overtakes the records and an empty committable summary is emitted > that needs to be correct at a later point when the records arrive. -- This message was sent by Atlassian Jira (v8.20.10#820010)