Test Result : SQLQueryTestSuite

0 failures (±0) , 27 skipped (±0)
241 tests (±0)
Took 14 min.

All Tests

Test nameDurationStatus
ansi/datetime.sql1.9 secPassed
ansi/decimalArithmeticOperations.sql0.5 secPassed
ansi/higher-order-functions.sql0.83 secPassed
ansi/interval.sql1.6 secPassed
ansi/literals.sql0.69 secPassed
ansi/string-functions.sql0.76 secPassed
array.sql0.47 secPassed
bitwise.sql1 secPassed
blacklist.sql0 msSkipped
cast.sql1 secPassed
change-column.sql0.11 secPassed
columnresolution-negative.sql0.21 secPassed
columnresolution-views.sql0.23 secPassed
columnresolution.sql1.9 secPassed
comparator.sql0.16 secPassed
count.sql0.46 secPassed
cross-join.sql0.59 secPassed
csv-functions.sql0.25 secPassed
cte-legacy.sql0.81 secPassed
cte-nested.sql0.37 secPassed
cte-nonlegacy.sql0.67 secPassed
cte.sql0.42 secPassed
datetime-formatting-invalid.sql0.16 secPassed
datetime-formatting-legacy.sql0.77 secPassed
datetime-formatting.sql0.92 secPassed
datetime-legacy.sql2.2 secPassed
datetime-parsing-invalid.sql0.27 secPassed
datetime-parsing-legacy.sql0.81 secPassed
datetime-parsing.sql0.74 secPassed
datetime.sql2.2 secPassed
decimalArithmeticOperations.sql1.2 secPassed
describe-part-after-analyze.sql0.67 secPassed
describe-query.sql0.12 secPassed
describe-table-after-alter-table.sql91 msPassed
describe-table-column.sql1 secPassed
describe.sql0.23 secPassed
except-all.sql2.8 secPassed
except.sql1.9 secPassed
explain-aqe.sql0.43 secPassed
explain.sql0.54 secPassed
extract.sql1.9 secPassed
group-analytics.sql3.2 secPassed
group-by-filter.sql2.7 secPassed
group-by-ordinal.sql0.81 secPassed
group-by.sql8.1 secPassed
grouping_set.sql1.7 secPassed
having.sql1.1 secPassed
higher-order-functions.sql2.2 secPassed
inline-table.sql0.15 secPassed
inner-join.sql1.5 secPassed
intersect-all.sql3.5 secPassed
interval.sql1.8 secPassed
join-empty-relation.sql0.41 secPassed
json-functions.sql0.84 secPassed
limit.sql0.47 secPassed
literals.sql0.88 secPassed
misc-functions.sql0.15 secPassed
natural-join.sql0.64 secPassed
null-handling.sql1.8 secPassed
null-propagation.sql0.25 secPassed
operators.sql2.1 secPassed
order-by-nulls-ordering.sql4.3 secPassed
order-by-ordinal.sql0.34 secPassed
outer-join.sql2.6 secPassed
pivot.sql3.5 secPassed
postgreSQL/aggregates_part1.sql9.8 secPassed
postgreSQL/aggregates_part2.sql7.9 secPassed
postgreSQL/aggregates_part3.sql1.1 secPassed
postgreSQL/aggregates_part4.sql52 msPassed
postgreSQL/boolean.sql4.7 secPassed
postgreSQL/case.sql2.7 secPassed
postgreSQL/comments.sql0.11 secPassed
postgreSQL/create_view.sql2.3 secPassed
postgreSQL/date.sql2.1 secPassed
postgreSQL/float4.sql1.6 secPassed
postgreSQL/float8.sql3.8 secPassed
postgreSQL/groupingsets.sql7.7 secPassed
postgreSQL/insert.sql0.87 secPassed
postgreSQL/int2.sql2.2 secPassed
postgreSQL/int4.sql2.8 secPassed
postgreSQL/int8.sql4.2 secPassed
postgreSQL/interval.sql0.3 secPassed
postgreSQL/join.sql2 min 39 secPassed
postgreSQL/limit.sql0.59 secPassed
postgreSQL/numeric.sql1 min 3 secPassed
postgreSQL/select.sql2.3 secPassed
postgreSQL/select_distinct.sql1.1 secPassed
postgreSQL/select_having.sql2.5 secPassed
postgreSQL/select_implicit.sql4.8 secPassed
postgreSQL/strings.sql3.2 secPassed
postgreSQL/text.sql1.4 secPassed
postgreSQL/timestamp.sql2.5 secPassed
postgreSQL/union.sql9.1 secPassed
postgreSQL/window_part1.sql13 secPassed
postgreSQL/window_part2.sql6.6 secPassed
postgreSQL/window_part3.sql3 secPassed
postgreSQL/window_part4.sql6.4 secPassed
postgreSQL/with.sql3.5 secPassed
pred-pushdown.sql0.11 secPassed
predicate-functions.sql0.89 secPassed
query_regex_column.sql1 secPassed
random.sql0.28 secPassed
regexp-functions.sql0.14 secPassed
show-create-table.sql0.26 secPassed
show-tables.sql0.11 secPassed
show-tblproperties.sql87 msPassed
show-views.sql0.1 secPassed
show_columns.sql0.12 secPassed
sql-compatibility-functions.sql0.5 secPassed
string-functions.sql0.86 secPassed
struct.sql0.24 secPassed
subquery/exists-subquery/exists-aggregate.sql4.1 secPassed
subquery/exists-subquery/exists-basic.sql1 secPassed
subquery/exists-subquery/exists-cte.sql1.5 secPassed
subquery/exists-subquery/exists-having.sql1 secPassed
subquery/exists-subquery/exists-joins-and-set-ops.sql27 secPassed
subquery/exists-subquery/exists-orderby-limit.sql3.8 secPassed
subquery/exists-subquery/exists-within-and-or.sql0.62 secPassed
subquery/in-subquery/in-basic.sql0.36 secPassed
subquery/in-subquery/in-group-by.sql10 secPassed
subquery/in-subquery/in-having.sql2.3 secPassed
subquery/in-subquery/in-joins.sql1 min 0 secPassed
subquery/in-subquery/in-limit.sql1.1 secPassed
subquery/in-subquery/in-multiple-columns.sql1 secPassed
subquery/in-subquery/in-order-by.sql9.9 secPassed
subquery/in-subquery/in-set-operations.sql6.3 secPassed
subquery/in-subquery/in-with-cte.sql3.1 secPassed
subquery/in-subquery/not-in-group-by.sql2.8 secPassed
subquery/in-subquery/not-in-joins.sql2.1 secPassed
subquery/in-subquery/not-in-unit-tests-multi-column-literal.sql0.14 secPassed
subquery/in-subquery/not-in-unit-tests-multi-column.sql0.67 secPassed
subquery/in-subquery/not-in-unit-tests-single-column-literal.sql0.13 secPassed
subquery/in-subquery/not-in-unit-tests-single-column.sql0.68 secPassed
subquery/in-subquery/simple-in.sql1.4 secPassed
subquery/negative-cases/invalid-correlation.sql93 msPassed
subquery/negative-cases/subq-input-typecheck.sql70 msPassed
subquery/scalar-subquery/scalar-subquery-predicate.sql4.8 secPassed
subquery/scalar-subquery/scalar-subquery-select.sql2.4 secPassed
subquery/subquery-in-from.sql0.23 secPassed
table-aliases.sql0.37 secPassed
table-valued-functions.sql0.44 secPassed
tablesample-negative.sql0.11 secPassed
typeCoercion/native/arrayJoin.sql0.23 secPassed
typeCoercion/native/binaryComparison.sql5.5 secPassed
typeCoercion/native/booleanEquality.sql1.7 secPassed
typeCoercion/native/caseWhenCoercion.sql1.9 secPassed
typeCoercion/native/concat.sql0.58 secPassed
typeCoercion/native/dateTimeOperations.sql0.29 secPassed
typeCoercion/native/decimalPrecision.sql18 secPassed
typeCoercion/native/division.sql1.7 secPassed
typeCoercion/native/elt.sql0.19 secPassed
typeCoercion/native/ifCoercion.sql2 secPassed
typeCoercion/native/implicitTypeCasts.sql0.83 secPassed
typeCoercion/native/inConversion.sql3.2 secPassed
typeCoercion/native/mapZipWith.sql0.85 secPassed
typeCoercion/native/mapconcat.sql0.38 secPassed
typeCoercion/native/promoteStrings.sql6.5 secPassed
typeCoercion/native/stringCastAndExpressions.sql0.56 secPassed
typeCoercion/native/widenSetOperationTypes.sql4.2 secPassed
typeCoercion/native/windowFrameCoercion.sql1.4 secPassed
udaf.sql0.27 secPassed
udf/postgreSQL/udf-aggregates_part1.sql - Regular Python UDF7.3 secPassed
udf/postgreSQL/udf-aggregates_part1.sql - Scala UDF6.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 UDF2.3 secPassed
udf/postgreSQL/udf-aggregates_part2.sql - Scala UDF1.5 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.22 secPassed
udf/postgreSQL/udf-aggregates_part3.sql - Scala UDF0.16 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 UDF45 msPassed
udf/postgreSQL/udf-aggregates_part4.sql - Scala UDF47 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.8 secPassed
udf/postgreSQL/udf-case.sql - Scala UDF2.6 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 UDF44 secPassed
udf/postgreSQL/udf-join.sql - Scala UDF29 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 UDF2.8 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 UDF10 secPassed
udf/postgreSQL/udf-select_implicit.sql - Scala UDF7.2 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.77 secPassed
udf/udf-count.sql - Scala UDF0.55 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 UDF1.3 secPassed
udf/udf-cross-join.sql - Scala UDF0.58 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 UDF5.8 secPassed
udf/udf-except-all.sql - Scala UDF3.3 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.9 secPassed
udf/udf-except.sql - Scala UDF1.7 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 UDF5.8 secPassed
udf/udf-group-analytics.sql - Scala UDF4.2 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 UDF9 secPassed
udf/udf-group-by.sql - Scala UDF6 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 UDF1.1 secPassed
udf/udf-having.sql - Scala UDF0.58 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 UDF1.1 secPassed
udf/udf-inline-table.sql - Scala UDF0.86 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.43 secPassed
udf/udf-inner-join.sql - Scala UDF0.21 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 UDF8.3 secPassed
udf/udf-intersect-all.sql - Scala UDF4.8 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.89 secPassed
udf/udf-join-empty-relation.sql - Scala UDF0.8 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 UDF1 secPassed
udf/udf-natural-join.sql - Scala UDF0.86 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.2 secPassed
udf/udf-outer-join.sql - Scala UDF0.58 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 UDF5.6 secPassed
udf/udf-pivot.sql - Scala UDF5.6 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.63 secPassed
udf/udf-special-values.sql - Scala UDF0.42 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.34 secPassed
udf/udf-udaf.sql - Scala UDF0.2 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 UDF1.4 secPassed
udf/udf-union.sql - Scala UDF0.83 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 UDF11 secPassed
udf/udf-window.sql - Scala UDF12 secPassed
udf/udf-window.sql - Scalar Pandas UDF is skipped because pyspark,pandas and/or pyarrow were not available in [python3].0 msSkipped
union.sql0.58 secPassed
window.sql6.8 secPassed