Test Result : SQLQueryTestSuite

0 failures (±0) , 27 skipped (±0)
262 tests (±0)
Took 17 min.

All Tests

Test nameDurationStatus
ansi/array.sql0.4 secPassed
ansi/datetime.sql3.2 secPassed
ansi/decimalArithmeticOperations.sql0.49 secPassed
ansi/group-analytics.sql3.8 secPassed
ansi/higher-order-functions.sql0.71 secPassed
ansi/interval.sql2.7 secPassed
ansi/literals.sql0.65 secPassed
ansi/map.sql8 msPassed
ansi/parse-schema-string.sql48 msPassed
ansi/string-functions.sql0.65 secPassed
array.sql0.66 secPassed
bitwise.sql2 secPassed
cast.sql1.8 secPassed
change-column.sql0.38 secPassed
charvarchar.sql5.5 secPassed
columnresolution-negative.sql0.63 secPassed
columnresolution-views.sql0.52 secPassed
columnresolution.sql2.9 secPassed
comments.sql0.46 secPassed
comparator.sql0.24 secPassed
count.sql2.9 secPassed
cross-join.sql1 secPassed
csv-functions.sql0.55 secPassed
cte-legacy.sql0.58 secPassed
cte-nested.sql0.77 secPassed
cte-nonlegacy.sql1.1 secPassed
cte.sql0.49 secPassed
current_database_catalog.sql33 msPassed
datetime-formatting-invalid.sql0.22 secPassed
datetime-formatting-legacy.sql1.2 secPassed
datetime-formatting.sql1.3 secPassed
datetime-legacy.sql5.6 secPassed
datetime-parsing-invalid.sql0.46 secPassed
datetime-parsing-legacy.sql0.93 secPassed
datetime-parsing.sql1 secPassed
datetime.sql9.7 secPassed
decimalArithmeticOperations.sql2.1 secPassed
describe-part-after-analyze.sql1.2 secPassed
describe-query.sql0.19 secPassed
describe-table-after-alter-table.sql0.28 secPassed
describe-table-column.sql1.6 secPassed
describe.sql0.41 secPassed
except-all.sql6.1 secPassed
except.sql3 secPassed
explain-aqe.sql0.62 secPassed
explain-cbo.sql0.84 secPassed
explain.sql0.53 secPassed
extract.sql7.4 secPassed
group-analytics.sql10 secPassed
group-by-filter.sql1 min 8 secPassed
group-by-ordinal.sql4.5 secPassed
group-by.sql16 secPassed
grouping_set.sql3.9 secPassed
having.sql2.2 secPassed
higher-order-functions.sql4 secPassed
ignored.sql0 msSkipped
inline-table.sql0.12 secPassed
inner-join.sql2.9 secPassed
intersect-all.sql6.8 secPassed
interval.sql8.1 secPassed
join-empty-relation.sql0.56 secPassed
join-lateral.sql13 secPassed
json-functions.sql2.3 secPassed
like-all.sql0.71 secPassed
like-any.sql0.45 secPassed
limit.sql0.5 secPassed
literals.sql1.3 secPassed
map.sql0.12 secPassed
misc-functions.sql0.41 secPassed
natural-join.sql3.6 secPassed
null-handling.sql3.8 secPassed
null-propagation.sql0.55 secPassed
operators.sql3.2 secPassed
order-by-nulls-ordering.sql8 secPassed
order-by-ordinal.sql0.66 secPassed
outer-join.sql4.1 secPassed
parse-schema-string.sql0.13 secPassed
pivot.sql7.2 secPassed
postgreSQL/aggregates_part1.sql8.6 secPassed
postgreSQL/aggregates_part2.sql5.5 secPassed
postgreSQL/aggregates_part3.sql2 secPassed
postgreSQL/aggregates_part4.sql76 msPassed
postgreSQL/boolean.sql5.6 secPassed
postgreSQL/case.sql3.2 secPassed
postgreSQL/comments.sql0.1 secPassed
postgreSQL/create_view.sql1.8 secPassed
postgreSQL/date.sql2.4 secPassed
postgreSQL/float4.sql1.5 secPassed
postgreSQL/float8.sql5.1 secPassed
postgreSQL/groupingsets.sql6.4 secPassed
postgreSQL/insert.sql0.82 secPassed
postgreSQL/int2.sql1.6 secPassed
postgreSQL/int4.sql2.1 secPassed
postgreSQL/int8.sql4.2 secPassed
postgreSQL/interval.sql0.25 secPassed
postgreSQL/join.sql2 min 40 secPassed
postgreSQL/limit.sql0.44 secPassed
postgreSQL/numeric.sql1 min 1 secPassed
postgreSQL/select.sql2.1 secPassed
postgreSQL/select_distinct.sql0.96 secPassed
postgreSQL/select_having.sql1.7 secPassed
postgreSQL/select_implicit.sql5.4 secPassed
postgreSQL/strings.sql2.2 secPassed
postgreSQL/text.sql0.7 secPassed
postgreSQL/timestamp.sql2.2 secPassed
postgreSQL/union.sql7.2 secPassed
postgreSQL/window_part1.sql20 secPassed
postgreSQL/window_part2.sql5.6 secPassed
postgreSQL/window_part3.sql2.9 secPassed
postgreSQL/window_part4.sql5.4 secPassed
postgreSQL/with.sql3 secPassed
pred-pushdown.sql0.23 secPassed
predicate-functions.sql1.8 secPassed
query_regex_column.sql1.7 secPassed
random.sql0.42 secPassed
regexp-functions.sql0.95 secPassed
show-create-table.sql0.4 secPassed
show-tables.sql0.4 secPassed
show-tblproperties.sql0.1 secPassed
show-views.sql0.19 secPassed
show_columns.sql0.28 secPassed
sql-compatibility-functions.sql0.85 secPassed
string-functions.sql1.9 secPassed
struct.sql0.44 secPassed
subexp-elimination.sql3.7 secPassed
subquery/exists-subquery/exists-aggregate.sql2.6 secPassed
subquery/exists-subquery/exists-basic.sql1.1 secPassed
subquery/exists-subquery/exists-cte.sql0.93 secPassed
subquery/exists-subquery/exists-having.sql0.67 secPassed
subquery/exists-subquery/exists-joins-and-set-ops.sql21 secPassed
subquery/exists-subquery/exists-orderby-limit.sql3.8 secPassed
subquery/exists-subquery/exists-within-and-or.sql0.42 secPassed
subquery/in-subquery/in-basic.sql0.45 secPassed
subquery/in-subquery/in-group-by.sql8.5 secPassed
subquery/in-subquery/in-having.sql2.8 secPassed
subquery/in-subquery/in-joins.sql1 min 18 secPassed
subquery/in-subquery/in-limit.sql1.1 secPassed
subquery/in-subquery/in-multiple-columns.sql1.4 secPassed
subquery/in-subquery/in-order-by.sql12 secPassed
subquery/in-subquery/in-set-operations.sql8 secPassed
subquery/in-subquery/in-with-cte.sql8.4 secPassed
subquery/in-subquery/nested-not-in.sql2 secPassed
subquery/in-subquery/not-in-group-by.sql2.3 secPassed
subquery/in-subquery/not-in-joins.sql2.8 secPassed
subquery/in-subquery/not-in-unit-tests-multi-column-literal.sql0.21 secPassed
subquery/in-subquery/not-in-unit-tests-multi-column.sql0.6 secPassed
subquery/in-subquery/not-in-unit-tests-single-column-literal.sql0.3 secPassed
subquery/in-subquery/not-in-unit-tests-single-column.sql0.67 secPassed
subquery/in-subquery/simple-in.sql1.8 secPassed
subquery/negative-cases/invalid-correlation.sql89 msPassed
subquery/negative-cases/subq-input-typecheck.sql60 msPassed
subquery/scalar-subquery/scalar-subquery-predicate.sql3.5 secPassed
subquery/scalar-subquery/scalar-subquery-select.sql2.7 secPassed
subquery/subquery-in-from.sql0.22 secPassed
table-aliases.sql1 secPassed
table-valued-functions.sql0.46 secPassed
tablesample-negative.sql0.59 secPassed
timestampNTZ/datetime.sql3.6 secPassed
timezone.sql62 msPassed
transform.sql7.7 secPassed
try_arithmetic.sql0.36 secPassed
try_cast.sql1.1 secPassed
typeCoercion/native/arrayJoin.sql0.18 secPassed
typeCoercion/native/binaryComparison.sql4.6 secPassed
typeCoercion/native/booleanEquality.sql1.2 secPassed
typeCoercion/native/caseWhenCoercion.sql1.5 secPassed
typeCoercion/native/concat.sql0.51 secPassed
typeCoercion/native/dateTimeOperations.sql0.28 secPassed
typeCoercion/native/decimalPrecision.sql14 secPassed
typeCoercion/native/division.sql1.3 secPassed
typeCoercion/native/elt.sql0.16 secPassed
typeCoercion/native/ifCoercion.sql1.4 secPassed
typeCoercion/native/implicitTypeCasts.sql0.82 secPassed
typeCoercion/native/inConversion.sql3.1 secPassed
typeCoercion/native/mapZipWith.sql0.71 secPassed
typeCoercion/native/mapconcat.sql0.34 secPassed
typeCoercion/native/promoteStrings.sql5 secPassed
typeCoercion/native/stringCastAndExpressions.sql0.51 secPassed
typeCoercion/native/widenSetOperationTypes.sql4 secPassed
typeCoercion/native/windowFrameCoercion.sql1.2 secPassed
udaf.sql0.35 secPassed
udf/postgreSQL/udf-aggregates_part1.sql - Regular Python UDF7.6 secPassed
udf/postgreSQL/udf-aggregates_part1.sql - Scala UDF5.3 secPassed
udf/postgreSQL/udf-aggregates_part1.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/postgreSQL/udf-aggregates_part2.sql - Regular Python UDF3.1 secPassed
udf/postgreSQL/udf-aggregates_part2.sql - Scala UDF2.6 secPassed
udf/postgreSQL/udf-aggregates_part2.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/postgreSQL/udf-aggregates_part3.sql - Regular Python UDF0.46 secPassed
udf/postgreSQL/udf-aggregates_part3.sql - Scala UDF0.21 secPassed
udf/postgreSQL/udf-aggregates_part3.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/postgreSQL/udf-aggregates_part4.sql - Regular Python UDF26 msPassed
udf/postgreSQL/udf-aggregates_part4.sql - Scala UDF82 msPassed
udf/postgreSQL/udf-aggregates_part4.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/postgreSQL/udf-case.sql - Regular Python UDF3 secPassed
udf/postgreSQL/udf-case.sql - Scala UDF3.4 secPassed
udf/postgreSQL/udf-case.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/postgreSQL/udf-join.sql - Regular Python UDF41 secPassed
udf/postgreSQL/udf-join.sql - Scala UDF36 secPassed
udf/postgreSQL/udf-join.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/postgreSQL/udf-select_having.sql - Regular Python UDF3.3 secPassed
udf/postgreSQL/udf-select_having.sql - Scala UDF3.1 secPassed
udf/postgreSQL/udf-select_having.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/postgreSQL/udf-select_implicit.sql - Regular Python UDF5.9 secPassed
udf/postgreSQL/udf-select_implicit.sql - Scala UDF4.6 secPassed
udf/postgreSQL/udf-select_implicit.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-count.sql - Regular Python UDF0.49 secPassed
udf/udf-count.sql - Scala UDF0.37 secPassed
udf/udf-count.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-cross-join.sql - Regular Python UDF0.88 secPassed
udf/udf-cross-join.sql - Scala UDF0.44 secPassed
udf/udf-cross-join.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-except-all.sql - Regular Python UDF6.2 secPassed
udf/udf-except-all.sql - Scala UDF4.7 secPassed
udf/udf-except-all.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-except.sql - Regular Python UDF1.1 secPassed
udf/udf-except.sql - Scala UDF0.87 secPassed
udf/udf-except.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-group-analytics.sql - Regular Python UDF2.9 secPassed
udf/udf-group-analytics.sql - Scala UDF2.6 secPassed
udf/udf-group-analytics.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-group-by.sql - Regular Python UDF8 secPassed
udf/udf-group-by.sql - Scala UDF5.6 secPassed
udf/udf-group-by.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-having.sql - Regular Python UDF0.63 secPassed
udf/udf-having.sql - Scala UDF0.38 secPassed
udf/udf-having.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-inline-table.sql - Regular Python UDF0.64 secPassed
udf/udf-inline-table.sql - Scala UDF0.49 secPassed
udf/udf-inline-table.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-inner-join.sql - Regular Python UDF0.47 secPassed
udf/udf-inner-join.sql - Scala UDF0.15 secPassed
udf/udf-inner-join.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-intersect-all.sql - Regular Python UDF3.9 secPassed
udf/udf-intersect-all.sql - Scala UDF2.6 secPassed
udf/udf-intersect-all.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-join-empty-relation.sql - Regular Python UDF0.61 secPassed
udf/udf-join-empty-relation.sql - Scala UDF0.41 secPassed
udf/udf-join-empty-relation.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-natural-join.sql - Regular Python UDF0.69 secPassed
udf/udf-natural-join.sql - Scala UDF0.51 secPassed
udf/udf-natural-join.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-outer-join.sql - Regular Python UDF1.1 secPassed
udf/udf-outer-join.sql - Scala UDF0.26 secPassed
udf/udf-outer-join.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-pivot.sql - Regular Python UDF3.6 secPassed
udf/udf-pivot.sql - Scala UDF2.9 secPassed
udf/udf-pivot.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-special-values.sql - Regular Python UDF0.3 secPassed
udf/udf-special-values.sql - Scala UDF0.15 secPassed
udf/udf-special-values.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-udaf.sql - Regular Python UDF0.19 secPassed
udf/udf-udaf.sql - Scala UDF0.13 secPassed
udf/udf-udaf.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-union.sql - Regular Python UDF0.89 secPassed
udf/udf-union.sql - Scala UDF0.43 secPassed
udf/udf-union.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
udf/udf-window.sql - Regular Python UDF12 secPassed
udf/udf-window.sql - Scala UDF13 secPassed
udf/udf-window.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
union.sql1.1 secPassed
using-join.sql4.2 secPassed
window.sql22 secPassed