Test Result : SQLQuerySuite

0 failures
212 tests
Took 1 min 31 sec.

All Tests

Test nameDurationStatus
Add Parser of SQL COALESCE()0.21 secPassed
Allow only a single WITH clause per query2 msPassed
CREATE TABLE USING should not fail if a same-name temp view exists0.12 secPassed
CTE feature0.28 secPassed
Common subexpression elimination1.1 secPassed
EXCEPT1.1 secPassed
Eliminate noop ordinal ORDER BY29 msPassed
Fold RepartitionExpression num partition should check if partition expression is empty45 msPassed
INTERSECT0.51 secPassed
MINUS0.91 secPassed
Multi-column COUNT(DISTINCT ...)0.65 secPassed
Multiple join0.19 secPassed
Non-deterministic aggregate functions should not be deduplicated11 msPassed
RuntimeReplaceable functions should not take extra parameters11 msPassed
SET commands semantics using sql()0.15 secPassed
SET commands with illegal or inappropriate argument13 msPassed
SET mapreduce.job.reduces automatically converted to spark.sql.shuffle.partitions8 msPassed
SPARK-10130 type coercion for IF should have children resolved first67 msPassed
SPARK-10215 Div of Decimal returns null0.27 secPassed
SPARK-10389: order by non-attribute grouping expression on Aggregate0.53 secPassed
SPARK-10707: nullability should be correctly propagated through set operations (1)0.11 secPassed
SPARK-10707: nullability should be correctly propagated through set operations (2)86 msPassed
SPARK-11111 null-safe join should not use cartesian product0.24 secPassed
SPARK-11226 Skip empty line in json file0.58 secPassed
SPARK-11303: filter should not be pushed down into sample0.41 secPassed
SPARK-12868: Allow adding jars from hdfs1 msPassed
SPARK-13056: Null in map value causes NPE0.13 secPassed
SPARK-14415: All functions should have own descriptions3 secPassed
SPARK-15327: fail to compile generated code with complex data structure0.73 secPassed
SPARK-15752 optimize metadata only query for datasource table1.7 secPassed
SPARK-16644: Aggregate should not put aggregate expressions to constraints0.24 secPassed
SPARK-16674: field names containing dots for both fields and partitioned fields0.3 secPassed
SPARK-16748: SparkExceptions during planning should not wrapped in TreeNodeException0.14 secPassed
SPARK-16975: Column-partition path starting '_' should be handled correctly0.28 secPassed
SPARK-17515: CollectLimit.execute() should perform per-partition limits79 msPassed
SPARK-17863: SELECT distinct does not work correctly if order by missing attribute0.33 secPassed
SPARK-18053: ARRAY equality is broken0.22 secPassed
SPARK-19059: read file based table whose name starts with underscore0.25 secPassed
SPARK-19157: should be able to change spark.sql.runSQLOnFiles at runtime0.22 secPassed
SPARK-19218 SET command should show a result in a sorted order21 msPassed
SPARK-19218 `SET -v` should not fail with null value configuration28 msPassed
SPARK-19334: check code injection is prevented88 msPassed
SPARK-19650: An action on a Command should not trigger a Spark job43 msPassed
SPARK-20164: AnalysisException should be tolerant to null query plan1 msPassed
SPARK-2041 column name equals tablename71 msPassed
SPARK-21228: InSet incorrect handling of structs0.21 secPassed
SPARK-21247: Allow case-insensitive type equality in Set operation0.56 secPassed
SPARK-21335: support un-aliased subquery83 msPassed
SPARK-21652: rule confliction of InferFiltersFromConstraints and ConstantPropagation0.16 secPassed
SPARK-21743: top-most limit should not cause memory leak86 msPassed
SPARK-22266: the same aggregate function was calculated multiple times0.16 secPassed
SPARK-22356: overlapped columns between data and partition schema in data source tables0.35 secPassed
SPARK-23079: constraints should be inferred correctly with aliases0.38 secPassed
SPARK-23281: verify the correctness of sort direction on composite order by clause0.8 secPassed
SPARK-2407 Added Parser of SQL SUBSTR()0.27 secPassed
SPARK-24696 ColumnPruning rule fails to remove extra Project0.61 secPassed
SPARK-24940: coalesce and repartition hint1.2 secPassed
SPARK-25084: 'distribute by' on multiple columns may lead to codegen issue0.44 secPassed
SPARK-25144 'distinct' causes memory leak0.18 secPassed
SPARK-25454: decimal division with negative scale59 msPassed
SPARK-25988: self join with aliases on partitioned tables #10.43 secPassed
SPARK-25988: self join with aliases on partitioned tables #285 msPassed
SPARK-26138 Pushdown limit through InnerLike when condition is empty0.5 secPassed
SPARK-26218: Fix the corner case when casting float to Integer19 msPassed
SPARK-26366: verify ReplaceExceptWithFilter1.7 secPassed
SPARK-26402: accessing nested fields with different cases in case insensitive mode0.17 secPassed
SPARK-26709: OptimizeMetadataOnlyQuery does not handle empty records correctly1.4 secPassed
SPARK-27619: Throw analysis exception when hash and xxhash64 is used on MapType34 msPassed
SPARK-27619: When spark.sql.legacy.allowHashOnMapType is true, hash can be used on Maptype0.14 secPassed
SPARK-27699 Validate pushed down filters0.79 secPassed
SPARK-28156: self-join should not miss cached view0.43 secPassed
SPARK-29000: arithmetic computation overflow when don't allow decimal precision loss0.2 secPassed
SPARK-29213: FilterExec should not throw NPE0.21 secPassed
SPARK-29239: Subquery should not cause NPE when eliminating subexpression0.23 secPassed
SPARK-29682: Conflicting attributes in Expand are resolved0.36 secPassed
SPARK-29860: Fix dataType mismatch issue for InSubquery0.81 secPassed
SPARK-30279 Support 32 or more grouping attributes for GROUPING_ID()1 secPassed
SPARK-30447: fix constant propagation inside NOT79 msPassed
SPARK-30870: Column pruning shouldn't alias a nested column for the whole structure0.11 secPassed
SPARK-30955: Exclude Generate output when aliasing in nested column pruning0.18 secPassed
SPARK-31166: UNION map<null, null> and other maps should not fail0.11 secPassed
SPARK-31242: clone SparkSession should respect sessionInitWithConfigDefaults2 msPassed
SPARK-31594: Do not display the seed of rand/randn with no argument in output schema18 msPassed
SPARK-31670: Trim unnecessary Struct field alias in Aggregate/GroupingSets1.8 secPassed
SPARK-3173 Timestamp support in the parser0.71 secPassed
SPARK-3176 Added Parser of SQL LAST()0.12 secPassed
SPARK-31761: test byte, short, integer overflow for (Divide) integral type0.15 secPassed
SPARK-31875: remove hints from plan when spark.sql.optimizer.disableHints = true88 msPassed
SPARK-32280: Avoid duplicate rewrite attributes when there're multiple JOINs0.2 secPassed
SPARK-32372: ResolveReferences.dedupRight should only rewrite attributes for ancestor plans of the conflict plan0.76 secPassed
SPARK-32788: non-partitioned table scan should not have partition filter0.22 secPassed
SPARK-33084: Add jar support Ivy URI in SQL3.8 secPassed
SPARK-33084: Add jar support Ivy URI in SQL -- jar contains udf class2.4 secPassed
SPARK-33306: Timezone is needed when cast Date to String0.89 secPassed
SPARK-33338: GROUP BY using literal map should not fail0.53 secPassed
SPARK-33482: Fix FileScan canonicalization0.33 secPassed
SPARK-3349 partitioning after limit0.52 secPassed
SPARK-33591: null as string partition literal value 'null' after setting legacy conf0.24 secPassed
SPARK-33593: Vector reader got incorrect data with binary partition value0.9 secPassed
SPARK-33677: LikeSimplification should be skipped if pattern contains any escapeChar1.3 secPassed
SPARK-3371 Renaming a function expression with group by gives error0.18 secPassed
SPARK-33964: Combine distinct unions that have noop project between them39 msPassed
SPARK-34030: Fold RepartitionExpression num partition should at Optimizer14 msPassed
SPARK-34212 Parquet should read decimals correctly1.3 secPassed
SPARK-3423 BETWEEN0.19 secPassed
SPARK-34421: Resolve temporary objects in permanent views with CTEs34 msPassed
SPARK-34421: Resolve temporary objects in temporary views with CTEs0.16 secPassed
SPARK-34514: Push down limit through LEFT SEMI and LEFT ANTI join0.89 secPassed
SPARK-34575 Push down limit through window when partitionSpec is empty0.6 secPassed
SPARK-34678: describe functions for table-valued functions14 msPassed
SPARK-34796: Avoid code-gen compilation error for LIMIT query0.39 secPassed
SPARK-3483 Special chars in column names50 msPassed
SPARK-3813 CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END0.12 secPassed
SPARK-3813 CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END0.14 secPassed
SPARK-3814 Support Bitwise & operator66 msPassed
SPARK-3814 Support Bitwise ^ operator67 msPassed
SPARK-3814 Support Bitwise | operator77 msPassed
SPARK-3814 Support Bitwise ~ operator65 msPassed
SPARK-4120 Join of multiple tables does not work in SparkSQL0.16 secPassed
SPARK-4154 Query does not work if it has 'not between' in Spark SQL and HQL0.2 secPassed
SPARK-4207 Query which has syntax like 'not like' is not working in Spark SQL0.15 secPassed
SPARK-4322 Grouping field with struct field as sub expression0.33 secPassed
SPARK-4432 Fix attribute reference resolution error when using ORDER BY0.17 secPassed
SPARK-4625 support SORT BY in SimpleSQLParser & DSL0.17 secPassed
SPARK-4699 case sensitivity SQL query0.11 secPassed
SPARK-6145: ORDER BY test for nested fields0.97 secPassed
SPARK-6145: special cases0.32 secPassed
SPARK-6201 IN type conversion0.17 secPassed
SPARK-6583 order by aggregated function1.8 secPassed
SPARK-6743: no columns from cache1 secPassed
SPARK-6898: complete support for special chars in column names0.1 secPassed
SPARK-7067: order by queries for complex ExtractValue chain0.21 secPassed
SPARK-7158 collect and take return different results0.48 secPassed
SPARK-7952: fix the equality check between boolean and numeric types0.15 secPassed
SPARK-8010: promote numeric to string1.5 secPassed
SPARK-8668 expr function0.79 secPassed
SPARK-8753: add interval type87 msPassed
SPARK-8782: ORDER BY NULL69 msPassed
SPARK-8828 sum should return null if all input values are null0.19 secPassed
SPARK-8837: use keyword in column name0.11 secPassed
SPARK-8945: add and subtract expressions for interval type0.16 secPassed
SPARK-9511: error with table starting with number0.13 secPassed
SQRT86 msPassed
SQRT with automatic string casts78 msPassed
SortMergeJoin returns wrong results when using UnsafeRows0.5 secPassed
Star Expansion - group by0.18 secPassed
Star Expansion - table with zero column0.15 secPassed
Struct Star Expansion2 secPassed
Struct Star Expansion - Name conflict0.14 secPassed
Support filter clause for aggregate function uses SortAggregateExec0.14 secPassed
Support filter clause for aggregate function with hash aggregate0.31 secPassed
Supporting relational operator '<=>' in Spark SQL0.22 secPassed
UNION0.44 secPassed
UNION with column mismatches0.39 secPassed
aggregation with codegen4.9 secPassed
aggregation with codegen updates peak execution memory0.18 secPassed
apply schema0.52 secPassed
approximate count distinct0.34 secPassed
approximate count distinct with user provided standard deviation0.28 secPassed
average0.12 secPassed
average overflow0.19 secPassed
big inner join, 4 matches per row0.54 secPassed
cartesian product join0.12 secPassed
cast boolean to string91 msPassed
check code injection is prevented0.56 secPassed
count0.16 secPassed
count distinct0.17 secPassed
count of empty table97 msPassed
data source table created in InMemoryCatalog should be able to read/write0.61 secPassed
date row0.12 secPassed
describe functions72 msPassed
external sorting2 secPassed
external sorting updates peak execution memory97 msPassed
filter on a grouping column that is not presented in SELECT0.15 secPassed
from follow multiple brackets0.4 secPassed
full outer join0.29 secPassed
grouping on nested fields0.49 secPassed
hash function70 msPassed
inner join ON with table name as qualifier0.14 secPassed
inner join ON, one match per row0.15 secPassed
inner join where, one match per row0.22 secPassed
inner join, no matches0.1 secPassed
inner join, where, multiple matches0.18 secPassed
join with using clause1.1 secPassed
left outer join0.18 secPassed
left semi greater than predicate0.16 secPassed
left semi greater than predicate and equal operator0.41 secPassed
limit partition num to 1 when distributing by foldable expressions25 msPassed
metadata is propagated correctly50 msPassed
mixed-case keywords0.2 secPassed
normalize special floating numbers in subquery0.4 secPassed
null count0.54 secPassed
order by asc by default when not specify ascending and descending0.13 secPassed
precision smaller than scale0.34 secPassed
qualified select with inner join ON with table name as qualifier0.15 secPassed
reset command should not fail with cache0.1 secPassed
right outer join0.21 secPassed
run sql directly on files0.7 secPassed
select *75 msPassed
select with table name as qualifier77 msPassed
self join with alias in agg1 secPassed
self join with aliases0.78 secPassed
should be able to resolve a persistent view0.66 secPassed
show functions0.8 secPassed
simple select74 msPassed
specifying database name for a temporary view is not allowed1.8 secPassed
string date comparison1.2 secPassed
string timestamp comparison1.2 secPassed
support table.star0.4 secPassed
system function lower()0.13 secPassed
system function upper()0.14 secPassed
xxhash64 function53 msPassed