Test Result : SQLQuerySuite

0 failures (±0) , 3 skipped (±0)
113 tests (±0)
Took 3 min 54 sec.

All Tests

Test nameDurationStatus
Auto alias construction of get_json_object96 msPassed
CTAS with WITH clause1.1 secPassed
CTAS with default fileformat0.94 secPassed
CTAS with serde11 secPassed
CTAS without serde with location6.2 secPassed
CTAS without serde without location8.7 secPassed
Call add jar in a different thread (SPARK-8306)31 msPassed
Cast STRING to BIGINT68 msPassed
Insert overwrite with partition3.7 secPassed
Project should not be resolved if it contains aggregates or generators0.95 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.19 secPassed
SPARK-10741: Sort on Aggregate using parquet2.6 secPassed
SPARK-11453: append data to partitioned table4.1 secPassed
SPARK-11590: use native json_tuple in lateral view0.58 secPassed
SPARK-13651: generator outputs shouldn't be resolved from its child's output0.66 secPassed
SPARK-14981: DESC not supported for sorting columns10 msPassed
SPARK-15752 optimize metadata only query for hive table15 secPassed
SPARK-17108: Fix BIGINT and INT comparison failure in spark sql0.66 secPassed
SPARK-17354: Partitioning by dates/timestamps works with Parquet vectorized reader1 secPassed
SPARK-17409: Do Not Optimize Query in CTAS (Hive Serde Table) More Than Once1.1 secPassed
SPARK-17796 Support wildcard '?'char in middle as part of local file path0.7 secPassed
SPARK-17796 Support wildcard '?'char in start as part of local file path0.58 secPassed
SPARK-17796 Support wildcard character in filename for LOAD DATA LOCAL INPATH0.75 secPassed
SPARK-18355 Read data from a hive table with a new column - orc14 secPassed
SPARK-18355 Read data from a hive table with a new column - parquet12 secPassed
SPARK-19292: filter with partition columns should be case-insensitive on Hive tables2 secPassed
SPARK-19912 String literals should be escaped for Hive metastore partition pruning1.6 secPassed
SPARK-21101 UDTF should override initialize(ObjectInspector[] args)0.21 secPassed
SPARK-21721: Clear FileSystem deleterOnExit cache if path is successfully removed5.8 secPassed
SPARK-21912 ORC/Parquet table should not create invalid column names5.4 secPassed
SPARK-23425 Test LOAD DATA LOCAL INPATH with space in file name0.51 secPassed
SPARK-24085 scalar subquery in partitioning expression10 secPassed
SPARK-25158: Executor accidentally exit because ScriptTransformationWriterThread throw Exception0.19 secPassed
SPARK-25271: Hive ctas commands should use data source if it is convertible6.1 secPassed
SPARK-2554 SumDistinct partial aggregation2.4 secPassed
SPARK-25738: defaultFs can have a port0 msPassed
SPARK-26181 hasMinMaxStats method of ColumnStatsMap is not correct1.2 secPassed
SPARK-26709: OptimizeMetadataOnlyQuery does not handle empty records correctly2 secPassed
SPARK-28084 check for case insensitive property of partition column name in load command1 secPassed
SPARK-29295: dynamic insert overwrite external partition should not have old data14 secPassed
SPARK-29295: insert overwrite external partition should not have old data3.9 secPassed
SPARK-31522: hive metastore related configurations should be static26 msPassed
SPARK-3708 Backticks aren't handled correctly is aliases0.51 secPassed
SPARK-3814 Support Bitwise & operator0.38 secPassed
SPARK-3814 Support Bitwise ^ operator0.69 secPassed
SPARK-3814 Support Bitwise | operator0.26 secPassed
SPARK-3814 Support Bitwise ~ operator0.24 secPassed
SPARK-3834 Backticks not correctly handled in subquery aliases0.25 secPassed
SPARK-4154 Query does not work if it has 'not between' in Spark SQL and HQL0.78 secPassed
SPARK-4296 Grouping field with Hive UDF as sub expression0.85 secPassed
SPARK-4512 Fix attribute reference resolution error when using SORT BY1 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 secPassed
SPARK-5203 union with different decimal precision58 msPassed
SPARK-5284 Insert into Hive throws NPE when a inner complex type field has a null value0.97 secPassed
SPARK-5371: union with null and sum0.53 secPassed
SPARK-6785: HiveQuerySuite - Date cast0.4 secPassed
SPARK-6785: HiveQuerySuite - Date comparison test 20.29 secPassed
SPARK-6835: udtf in lateral view0.33 secPassed
SPARK-6851: Self-joined converted parquet tables3.6 secPassed
SPARK-7269 Check analysis failed in case in-sensitive1.1 secPassed
SPARK-8976 Wrong Result for CUBE #10.99 secPassed
SPARK-8976 Wrong Result for CUBE #22 secPassed
SPARK-8976 Wrong Result for GroupingSet1.6 secPassed
SPARK-8976 Wrong Result for Rollup #11 secPassed
SPARK-8976 Wrong Result for Rollup #22.4 secPassed
SPARK-8976 Wrong Result for Rollup #31.6 secPassed
SPARK-9371: fix the support for special chars in column names for hive context0.16 secPassed
Sorting columns are not in Generate0.81 secPassed
Star Expansion - script transform6.8 secPassed
Support wildcard character in folderlevel for LOAD DATA LOCAL INPATH0.71 secPassed
TGF with non-TGF in projection0.2 secPassed
column resolution scenarios with hive table0.99 secPassed
command substitution0.73 secPassed
describe functions - built-in functions0.13 secPassed
describe functions - temporary user defined functions0.42 secPassed
describe functions - user defined functions1.5 secPassed
double nested data2.2 secPassed
dynamic partition value test3.3 secPassed
explode nested Field0.57 secPassed
inConversion fires too early0.16 secPassed
insert into datasource table0.64 secPassed
multi-insert with lateral view2.1 secPassed
non-existent global temp view12 msPassed
ordering not in agg2 secPassed
ordering not in select1 secPassed
partition pruning should handle date correctly1.6 secPassed
q1.6 secPassed
q1.6 secPassed
query global temp view0.17 secPassed
resolve udtf in projection #152 msPassed
resolve udtf in projection #20.37 secPassed
run sql directly on files - csv1.1 secPassed
run sql directly on files - hive0.26 secPassed
run sql directly on files - json0.86 secPassed
run sql directly on files - orc0.66 secPassed
run sql directly on files - parquet0.88 secPassed
sanity test for SPARK-66182.4 secPassed
script0.59 secPassed
select partitioned table2 secPassed
show functions0.92 secPassed
spark-15557 promote string test1.3 secPassed
specifying database name for a temporary view is not allowed1.1 secPassed
specifying the column list for CTAS1 secPassed
test CTAS1.4 secPassed
test case key when0.17 secPassed
test script transform data type0.36 secPassed
test script transform for stderr6.2 secPassed
test script transform for stdout7.3 secPassed