Test Result : SQLQuerySuite

0 failures (±0) , 3 skipped (±0)
110 tests (-4)
Took 4 min 25 sec.

All Tests

Test nameDurationStatus
Auto alias construction of get_json_object0.1 secPassed
CTAS with WITH clause1.3 secPassed
CTAS with default fileformat0.78 secPassed
CTAS with serde17 secPassed
CTAS without serde with location8.1 secPassed
CTAS without serde without location11 secPassed
Call add jar in a different thread (SPARK-8306)81 msPassed
Cast STRING to BIGINT0.12 secPassed
Convert hive interval term into Literal of CalendarIntervalType0.92 secPassed
Insert overwrite with partition2.4 secPassed
Project should not be resolved if it contains aggregates or generators0.9 secPassed
SPARK-10310: script transformation using LazySimpleSerDe-1 msSkipped
SPARK-10310: script transformation using default input/output SerDe and record reader/writer-1 msSkipped
SPARK-10562: partition by column with mixed case name-1 msSkipped
SPARK-10593 same column names in lateral view0.21 secPassed
SPARK-10741: Sort on Aggregate using parquet4.2 secPassed
SPARK-11453: append data to partitioned table3.4 secPassed
SPARK-11590: use native json_tuple in lateral view0.57 secPassed
SPARK-13651: generator outputs shouldn't be resolved from its child's output1.3 secPassed
SPARK-14981: DESC not supported for sorting columns21 msPassed
SPARK-15752 optimize metadata only query for hive table20 secPassed
SPARK-17108: Fix BIGINT and INT comparison failure in spark sql0.48 secPassed
SPARK-17354: Partitioning by dates/timestamps works with Parquet vectorized reader1.3 secPassed
SPARK-17409: Do Not Optimize Query in CTAS (Hive Serde Table) More Than Once1.4 secPassed
SPARK-17796 Support wildcard '?'char in middle as part of local file path1 secPassed
SPARK-17796 Support wildcard '?'char in start as part of local file path0.73 secPassed
SPARK-17796 Support wildcard character in filename for LOAD DATA LOCAL INPATH1.3 secPassed
SPARK-18355 Read data from a hive table with a new column - orc18 secPassed
SPARK-18355 Read data from a hive table with a new column - parquet16 secPassed
SPARK-19292: filter with partition columns should be case-insensitive on Hive tables1.9 secPassed
SPARK-19912 String literals should be escaped for Hive metastore partition pruning1.2 secPassed
SPARK-21101 UDTF should override initialize(ObjectInspector[] args)0.24 secPassed
SPARK-21721: Clear FileSystem deleterOnExit cache if path is successfully removed8 secPassed
SPARK-21912 ORC/Parquet table should not create invalid column names3.6 secPassed
SPARK-23425 Test LOAD DATA LOCAL INPATH with space in file name0.98 secPassed
SPARK-24085 scalar subquery in partitioning expression11 secPassed
SPARK-2554 SumDistinct partial aggregation3.6 secPassed
SPARK-25738: defaultFs can have a port1 msPassed
SPARK-26181 hasMinMaxStats method of ColumnStatsMap is not correct1.3 secPassed
SPARK-26709: OptimizeMetadataOnlyQuery does not handle empty records correctly1.7 secPassed
SPARK-29295: dynamic insert overwrite external partition should not have old data18 secPassed
SPARK-29295: insert overwrite external partition should not have old data6 secPassed
SPARK-3708 Backticks aren't handled correctly is aliases0.29 secPassed
SPARK-3814 Support Bitwise & operator0.28 secPassed
SPARK-3814 Support Bitwise ^ operator0.26 secPassed
SPARK-3814 Support Bitwise | operator0.32 secPassed
SPARK-3814 Support Bitwise ~ operator0.27 secPassed
SPARK-3834 Backticks not correctly handled in subquery aliases0.29 secPassed
SPARK-4154 Query does not work if it has 'not between' in Spark SQL and HQL1.2 secPassed
SPARK-4296 Grouping field with Hive UDF as sub expression1.7 secPassed
SPARK-4512 Fix attribute reference resolution error when using SORT BY1.1 secPassed
SPARK-4699 SparkSession with Hive Support should be case insensitive by default0.86 secPassed
SPARK-4825 save join to table3.4 secPassed
SPARK-4963 DataFrame sample on mutable row return wrong result2.3 secPassed
SPARK-5203 union with different decimal precision0.13 secPassed
SPARK-5284 Insert into Hive throws NPE when a inner complex type field has a null value1.8 secPassed
SPARK-5371: union with null and sum1 secPassed
SPARK-6785: HiveQuerySuite - Date cast0.4 secPassed
SPARK-6785: HiveQuerySuite - Date comparison test 20.34 secPassed
SPARK-6835: udtf in lateral view0.92 secPassed
SPARK-6851: Self-joined converted parquet tables6.2 secPassed
SPARK-7269 Check analysis failed in case in-sensitive1.7 secPassed
SPARK-8976 Wrong Result for CUBE #11.4 secPassed
SPARK-8976 Wrong Result for CUBE #23.3 secPassed
SPARK-8976 Wrong Result for GroupingSet1.7 secPassed
SPARK-8976 Wrong Result for Rollup #12.1 secPassed
SPARK-8976 Wrong Result for Rollup #22.4 secPassed
SPARK-8976 Wrong Result for Rollup #31.8 secPassed
SPARK-9371: fix the support for special chars in column names for hive context0.35 secPassed
Sorting columns are not in Generate1.1 secPassed
Star Expansion - script transform3.2 secPassed
Support wildcard character in folderlevel for LOAD DATA LOCAL INPATH1.1 secPassed
TGF with non-TGF in projection1.8 secPassed
column resolution scenarios with hive table0.91 secPassed
command substitution0.87 secPassed
describe functions - built-in functions0.17 secPassed
describe functions - temporary user defined functions0.38 secPassed
describe functions - user defined functions1.1 secPassed
double nested data1.1 secPassed
dynamic partition value test2.9 secPassed
explode nested Field0.6 secPassed
inConversion fires too early0.55 secPassed
insert into datasource table1 secPassed
multi-insert with lateral view2.1 secPassed
non-existent global temp view28 msPassed
ordering not in agg2.1 secPassed
ordering not in select0.86 secPassed
partition pruning should handle date correctly1.5 secPassed
q1.7 secPassed
q1.2 secPassed
query global temp view0.84 secPassed
resolve udtf in projection #10.14 secPassed
resolve udtf in projection #20.84 secPassed
run sql directly on files - csv1.2 secPassed
run sql directly on files - hive0.25 secPassed
run sql directly on files - json1.2 secPassed
run sql directly on files - orc0.89 secPassed
run sql directly on files - parquet1 secPassed
sanity test for SPARK-66183.2 secPassed
script1.4 secPassed
select partitioned table2.5 secPassed
show functions1 secPassed
spark-15557 promote string test1.6 secPassed
specifying database name for a temporary view is not allowed0.65 secPassed
specifying the column list for CTAS0.86 secPassed
test CTAS1.5 secPassed
test case key when0.17 secPassed
test script transform data type0.49 secPassed
test script transform for stderr2.7 secPassed
test script transform for stdout2.9 secPassed