[
https://issues.apache.org/jira/browse/BEAM-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrew Pilloud updated BEAM-9518:
---------------------------------
Description:
eight failures in shard 6, eight failures in shard 7, eight failures in shard
8, ten failures in shard 9
{code}
org.apache.beam.sdk.Pipeline$PipelineExecutionException:
java.lang.UnsupportedOperationException: Unsupported Beam fieldType:
LOGICAL_TYPE
at
org.apache.beam.runners.direct.DirectRunner$DirectPipelineResult.waitUntilFinish(DirectRunner.java:348)
at
org.apache.beam.runners.direct.DirectRunner$DirectPipelineResult.waitUntilFinish(DirectRunner.java:318)
at
org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:213)
at org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:67)
at org.apache.beam.sdk.Pipeline.run(Pipeline.java:317)
at org.apache.beam.sdk.Pipeline.run(Pipeline.java:303)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.runCollector(BeamEnumerableConverter.java:201)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.collectRows(BeamEnumerableConverter.java:218)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.toRowList(BeamEnumerableConverter.java:150)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.toRowList(BeamEnumerableConverter.java:127)
at
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl.executeQuery(ExecuteQueryServiceServer.java:329)
at
com.google.zetasql.testing.SqlComplianceServiceGrpc$MethodHandlers.invoke(SqlComplianceServiceGrpc.java:423)
at
com.google.zetasql.io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:171)
at
com.google.zetasql.io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:283)
at
com.google.zetasql.io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(ServerImpl.java:711)
at
com.google.zetasql.io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37)
at
com.google.zetasql.io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123)
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)
Caused by: java.lang.UnsupportedOperationException: Unsupported Beam fieldType:
LOGICAL_TYPE
at
org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlUtils.zetaSqlValueToJavaObject(ZetaSqlUtils.java:221)
at
org.apache.beam.sdk.extensions.sql.zetasql.BeamZetaSqlCalcRel$CalcFn.processElement(BeamZetaSqlCalcRel.java:193)
{code}
{code}
Apr 01, 2020 6:00:21 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT CAST(@p0 AS DATE) AS ColA
Apr 01, 2020 6:03:59 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT DISTINCT val.DATE
from (select DATE"2014-01-01" DATE union all
select cast(NULL as date) union all
select DATE"2014-01-02" union all
select DATE"2014-01-01" union all
select cast(NULL as date)) val
Apr 01, 2020 6:10:09 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT COALESCE(NULL, DATE '2014-12-18')
Apr 01, 2020 6:03:26 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT CAST(null AS TIME),
CAST('12:34:56.123456' AS TIME),
CAST(CAST(null AS TIME) AS STRING),
CAST(CAST('12:34:56.123456' AS TIME) AS STRING),
CAST(TIME '12:34:56.123456' AS STRING),
CAST(CAST(TIME '12:34:56.123456' AS STRING) AS TIME)
Apr 01, 2020 5:59:59 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT SAFE_CAST(@p0 AS DATE) AS ColA
Apr 01, 2020 6:07:07 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT
CAST(CAST(TIME "00:00:00" as STRING) as TIME),
CAST(CAST(TIME "23:59:59.999999" as STRING) as TIME),
CAST(CAST(TIME "01:02:03.123456" as STRING) as TIME),
CAST(CAST(TIME "01:02:03.12345" as STRING) as TIME),
CAST(CAST(TIME "01:02:03.120000" as STRING) as TIME),
CAST(CAST(TIME "01:02:3" as STRING) as TIME),
CAST(CAST(TIME "01:2:03" as STRING) as TIME),
CAST(CAST(TIME "1:02:03" as STRING) as TIME),
#Leap second cases
CAST(CAST(TIME "23:59:60" as STRING) as TIME),
CAST(CAST(TIME "12:59:60" as STRING) as TIME),
CAST(CAST(TIME "12:59:60.123456" as STRING) as TIME),
CAST(CAST("00:00:00" as TIME) as STRING),
CAST(CAST("23:59:59.999999" as TIME) as STRING),
CAST(CAST("01:02:03.123456" as TIME) as STRING),
CAST(CAST("01:02:03.12345" as TIME) as STRING),
CAST(CAST("01:02:03.120000" as TIME) as STRING),
CAST(CAST("01:02:3" as TIME) as STRING),
CAST(CAST("01:2:03" as TIME) as STRING),
CAST(CAST("1:02:03" as TIME) as STRING),
#Leap second cases
CAST(CAST("23:59:60" as TIME) as STRING),
CAST(CAST("12:59:60" as TIME) as STRING),
CAST(CAST("12:59:60.123456" as TIME) as STRING)
Apr 01, 2020 6:07:11 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT
CAST(TIMESTAMP "0001-01-01 00:00:00" as TIME),
CAST(TIMESTAMP "9999-12-31 15:59:59.999999" as TIME),
CAST(TIMESTAMP "2006-01-02" as TIME),
# Leap second cases
CAST(TIMESTAMP "2015-11-06 23:59:60" as TIME),
CAST(TIMESTAMP "2015-11-06 12:59:60" as TIME),
CAST(TIMESTAMP "2015-11-06 12:59:60.123456" as TIME)
Apr 01, 2020 6:07:12 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT
CAST(str_time_col_2 as TIME) as time_col_3,
CAST(time_col_2 as STRING) as str_time_col_3
FROM (
SELECT
CAST(str_time_col as TIME) as time_col_2,
CAST(time_col as STRING) as str_time_col_2
FROM (
SELECT
"12:34:56.123456" as str_time_col,
TIME "12:34:56.123456" as time_col
))
Apr 01, 2020 6:07:14 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT
CAST(DATETIME "0001-01-01 08:00:00" as TIME),
CAST(DATETIME "0001-01-01 11:22:33.123456" as TIME),
CAST(DATETIME "9999-12-31 13:59:59.999999" as TIME),
CAST(DATETIME "2006-01-02" as TIME),
# Leap second cases
CAST(DATETIME "2015-11-06 23:59:60" as TIME),
CAST(DATETIME "2015-11-06 12:59:60" as TIME),
CAST(DATETIME "2015-11-06 12:59:60.123456" as TIME)
{code}
was:
eight failures in shard 6, eight failures in shard 7, eight failures in shard 8
{code}
org.apache.beam.sdk.Pipeline$PipelineExecutionException:
java.lang.UnsupportedOperationException: Unsupported Beam fieldType:
LOGICAL_TYPE
at
org.apache.beam.runners.direct.DirectRunner$DirectPipelineResult.waitUntilFinish(DirectRunner.java:348)
at
org.apache.beam.runners.direct.DirectRunner$DirectPipelineResult.waitUntilFinish(DirectRunner.java:318)
at
org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:213)
at org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:67)
at org.apache.beam.sdk.Pipeline.run(Pipeline.java:317)
at org.apache.beam.sdk.Pipeline.run(Pipeline.java:303)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.runCollector(BeamEnumerableConverter.java:201)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.collectRows(BeamEnumerableConverter.java:218)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.toRowList(BeamEnumerableConverter.java:150)
at
org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.toRowList(BeamEnumerableConverter.java:127)
at
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl.executeQuery(ExecuteQueryServiceServer.java:329)
at
com.google.zetasql.testing.SqlComplianceServiceGrpc$MethodHandlers.invoke(SqlComplianceServiceGrpc.java:423)
at
com.google.zetasql.io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:171)
at
com.google.zetasql.io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:283)
at
com.google.zetasql.io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(ServerImpl.java:711)
at
com.google.zetasql.io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37)
at
com.google.zetasql.io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123)
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)
Caused by: java.lang.UnsupportedOperationException: Unsupported Beam fieldType:
LOGICAL_TYPE
at
org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlUtils.zetaSqlValueToJavaObject(ZetaSqlUtils.java:221)
at
org.apache.beam.sdk.extensions.sql.zetasql.BeamZetaSqlCalcRel$CalcFn.processElement(BeamZetaSqlCalcRel.java:193)
{code}
{code}
Apr 01, 2020 6:00:21 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT CAST(@p0 AS DATE) AS ColA
Apr 01, 2020 6:03:59 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT DISTINCT val.DATE
from (select DATE"2014-01-01" DATE union all
select cast(NULL as date) union all
select DATE"2014-01-02" union all
select DATE"2014-01-01" union all
select cast(NULL as date)) val
Apr 01, 2020 6:10:09 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT COALESCE(NULL, DATE '2014-12-18')
Apr 01, 2020 6:03:26 PM
cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
executeQuery
INFO: Processing Sql statement: SELECT CAST(null AS TIME),
CAST('12:34:56.123456' AS TIME),
CAST(CAST(null AS TIME) AS STRING),
CAST(CAST('12:34:56.123456' AS TIME) AS STRING),
CAST(TIME '12:34:56.123456' AS STRING),
CAST(CAST(TIME '12:34:56.123456' AS STRING) AS TIME)
{code}
> BeamZetaSqlCalcRel$CalcFn.processElement Unsupported Beam fieldType:
> LOGICAL_TYPE
> ---------------------------------------------------------------------------------
>
> Key: BEAM-9518
> URL: https://issues.apache.org/jira/browse/BEAM-9518
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql-zetasql
> Reporter: Andrew Pilloud
> Priority: Minor
> Labels: zetasql-compliance
>
> eight failures in shard 6, eight failures in shard 7, eight failures in shard
> 8, ten failures in shard 9
> {code}
> org.apache.beam.sdk.Pipeline$PipelineExecutionException:
> java.lang.UnsupportedOperationException: Unsupported Beam fieldType:
> LOGICAL_TYPE
> at
> org.apache.beam.runners.direct.DirectRunner$DirectPipelineResult.waitUntilFinish(DirectRunner.java:348)
> at
> org.apache.beam.runners.direct.DirectRunner$DirectPipelineResult.waitUntilFinish(DirectRunner.java:318)
> at
> org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:213)
> at org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:67)
> at org.apache.beam.sdk.Pipeline.run(Pipeline.java:317)
> at org.apache.beam.sdk.Pipeline.run(Pipeline.java:303)
> at
> org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.runCollector(BeamEnumerableConverter.java:201)
> at
> org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.collectRows(BeamEnumerableConverter.java:218)
> at
> org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.toRowList(BeamEnumerableConverter.java:150)
> at
> org.apache.beam.sdk.extensions.sql.impl.rel.BeamEnumerableConverter.toRowList(BeamEnumerableConverter.java:127)
> at
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl.executeQuery(ExecuteQueryServiceServer.java:329)
> at
> com.google.zetasql.testing.SqlComplianceServiceGrpc$MethodHandlers.invoke(SqlComplianceServiceGrpc.java:423)
> at
> com.google.zetasql.io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:171)
> at
> com.google.zetasql.io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:283)
> at
> com.google.zetasql.io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(ServerImpl.java:711)
> at
> com.google.zetasql.io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37)
> at
> com.google.zetasql.io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123)
> 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)
> Caused by: java.lang.UnsupportedOperationException: Unsupported Beam
> fieldType: LOGICAL_TYPE
> at
> org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlUtils.zetaSqlValueToJavaObject(ZetaSqlUtils.java:221)
> at
> org.apache.beam.sdk.extensions.sql.zetasql.BeamZetaSqlCalcRel$CalcFn.processElement(BeamZetaSqlCalcRel.java:193)
> {code}
> {code}
> Apr 01, 2020 6:00:21 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT CAST(@p0 AS DATE) AS ColA
> Apr 01, 2020 6:03:59 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT DISTINCT val.DATE
> from (select DATE"2014-01-01" DATE union all
> select cast(NULL as date) union all
> select DATE"2014-01-02" union all
> select DATE"2014-01-01" union all
> select cast(NULL as date)) val
> Apr 01, 2020 6:10:09 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT COALESCE(NULL, DATE '2014-12-18')
> Apr 01, 2020 6:03:26 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT CAST(null AS TIME),
> CAST('12:34:56.123456' AS TIME),
> CAST(CAST(null AS TIME) AS STRING),
> CAST(CAST('12:34:56.123456' AS TIME) AS STRING),
> CAST(TIME '12:34:56.123456' AS STRING),
> CAST(CAST(TIME '12:34:56.123456' AS STRING) AS TIME)
> Apr 01, 2020 5:59:59 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT SAFE_CAST(@p0 AS DATE) AS ColA
> Apr 01, 2020 6:07:07 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT
> CAST(CAST(TIME "00:00:00" as STRING) as TIME),
> CAST(CAST(TIME "23:59:59.999999" as STRING) as TIME),
> CAST(CAST(TIME "01:02:03.123456" as STRING) as TIME),
> CAST(CAST(TIME "01:02:03.12345" as STRING) as TIME),
> CAST(CAST(TIME "01:02:03.120000" as STRING) as TIME),
> CAST(CAST(TIME "01:02:3" as STRING) as TIME),
> CAST(CAST(TIME "01:2:03" as STRING) as TIME),
> CAST(CAST(TIME "1:02:03" as STRING) as TIME),
> #Leap second cases
> CAST(CAST(TIME "23:59:60" as STRING) as TIME),
> CAST(CAST(TIME "12:59:60" as STRING) as TIME),
> CAST(CAST(TIME "12:59:60.123456" as STRING) as TIME),
> CAST(CAST("00:00:00" as TIME) as STRING),
> CAST(CAST("23:59:59.999999" as TIME) as STRING),
> CAST(CAST("01:02:03.123456" as TIME) as STRING),
> CAST(CAST("01:02:03.12345" as TIME) as STRING),
> CAST(CAST("01:02:03.120000" as TIME) as STRING),
> CAST(CAST("01:02:3" as TIME) as STRING),
> CAST(CAST("01:2:03" as TIME) as STRING),
> CAST(CAST("1:02:03" as TIME) as STRING),
> #Leap second cases
> CAST(CAST("23:59:60" as TIME) as STRING),
> CAST(CAST("12:59:60" as TIME) as STRING),
> CAST(CAST("12:59:60.123456" as TIME) as STRING)
> Apr 01, 2020 6:07:11 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT
> CAST(TIMESTAMP "0001-01-01 00:00:00" as TIME),
> CAST(TIMESTAMP "9999-12-31 15:59:59.999999" as TIME),
> CAST(TIMESTAMP "2006-01-02" as TIME),
> # Leap second cases
> CAST(TIMESTAMP "2015-11-06 23:59:60" as TIME),
> CAST(TIMESTAMP "2015-11-06 12:59:60" as TIME),
> CAST(TIMESTAMP "2015-11-06 12:59:60.123456" as TIME)
> Apr 01, 2020 6:07:12 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT
> CAST(str_time_col_2 as TIME) as time_col_3,
> CAST(time_col_2 as STRING) as str_time_col_3
> FROM (
> SELECT
> CAST(str_time_col as TIME) as time_col_2,
> CAST(time_col as STRING) as str_time_col_2
> FROM (
> SELECT
> "12:34:56.123456" as str_time_col,
> TIME "12:34:56.123456" as time_col
> ))
> Apr 01, 2020 6:07:14 PM
> cloud.dataflow.sql.ExecuteQueryServiceServer$SqlComplianceServiceImpl
> executeQuery
> INFO: Processing Sql statement: SELECT
> CAST(DATETIME "0001-01-01 08:00:00" as TIME),
> CAST(DATETIME "0001-01-01 11:22:33.123456" as TIME),
> CAST(DATETIME "9999-12-31 13:59:59.999999" as TIME),
> CAST(DATETIME "2006-01-02" as TIME),
> # Leap second cases
> CAST(DATETIME "2015-11-06 23:59:60" as TIME),
> CAST(DATETIME "2015-11-06 12:59:60" as TIME),
> CAST(DATETIME "2015-11-06 12:59:60.123456" as TIME)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
