Test Result : SQLQuerySuiteAE

0 failures , 3 skipped
114 tests
Took 4 min 34 sec.

All Tests

Test nameDurationStatus
Auto alias construction of get_json_object91 msPassed
CTAS with WITH clause1.2 secPassed
CTAS with default fileformat0.99 secPassed
CTAS with serde8.2 secPassed
CTAS without serde with location5.2 secPassed
CTAS without serde without location5.7 secPassed
Call add jar in a different thread (SPARK-8306)15 msPassed
Cast STRING to BIGINT0.33 secPassed
Insert overwrite with partition3.1 secPassed
Project should not be resolved if it contains aggregates or generators0.99 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.3 secPassed
SPARK-11453: append data to partitioned table3.6 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.64 secPassed
SPARK-14981: DESC not supported for sorting columns13 msPassed
SPARK-15752 optimize metadata only query for hive table22 secPassed
SPARK-17108: Fix BIGINT and INT comparison failure in spark sql0.65 secPassed
SPARK-17354: Partitioning by dates/timestamps works with Parquet vectorized reader1.7 secPassed
SPARK-17409: Do Not Optimize Query in CTAS (Hive Serde Table) More Than Once1.2 secPassed
SPARK-17796 Support wildcard '?'char in middle as part of local file path1.1 secPassed
SPARK-17796 Support wildcard '?'char in start as part of local file path0.76 secPassed
SPARK-17796 Support wildcard character in filename for LOAD DATA LOCAL INPATH1.1 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 - parquet17 secPassed
SPARK-19292: filter with partition columns should be case-insensitive on Hive tables3 secPassed
SPARK-19912 String literals should be escaped for Hive metastore partition pruning2.3 secPassed
SPARK-21101 UDTF should override initialize(ObjectInspector[] args)0.17 secPassed
SPARK-21721: Clear FileSystem deleterOnExit cache if path is successfully removed10 secPassed
SPARK-21912 ORC/Parquet table should not create invalid column names7 secPassed
SPARK-23425 Test LOAD DATA LOCAL INPATH with space in file name0.89 secPassed
SPARK-24085 scalar subquery in partitioning expression15 secPassed
SPARK-25158: Executor accidentally exit because ScriptTransformationWriterThread throw Exception0.19 secPassed
SPARK-25271: Hive ctas commands should use data source if it is convertible8.5 secPassed
SPARK-2554 SumDistinct partial aggregation1.4 secPassed
SPARK-25738: defaultFs can have a port0 msPassed
SPARK-26181 hasMinMaxStats method of ColumnStatsMap is not correct1.7 secPassed
SPARK-26709: OptimizeMetadataOnlyQuery does not handle empty records correctly3 secPassed
SPARK-28084 check for case insensitive property of partition column name in load command1.4 secPassed
SPARK-29295: dynamic insert overwrite external partition should not have old data21 secPassed
SPARK-29295: dynamic partition map parsed from partition path should be case insensitive1.8 secPassed
SPARK-29295: insert overwrite external partition should not have old data6.1 secPassed
SPARK-31522: hive metastore related configurations should be static56 msPassed
SPARK-3708 Backticks aren't handled correctly is aliases0.32 secPassed
SPARK-3814 Support Bitwise & operator0.51 secPassed
SPARK-3814 Support Bitwise ^ operator0.28 secPassed
SPARK-3814 Support Bitwise | operator0.3 secPassed
SPARK-3814 Support Bitwise ~ operator0.26 secPassed
SPARK-3834 Backticks not correctly handled in subquery aliases0.34 secPassed
SPARK-4154 Query does not work if it has 'not between' in Spark SQL and HQL0.8 secPassed
SPARK-4296 Grouping field with Hive UDF as sub expression0.78 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.59 secPassed
SPARK-4825 save join to table3.7 secPassed
SPARK-4963 DataFrame sample on mutable row return wrong result2.1 secPassed
SPARK-5203 union with different decimal precision28 msPassed
SPARK-5284 Insert into Hive throws NPE when a inner complex type field has a null value1 secPassed
SPARK-5371: union with null and sum0.54 secPassed
SPARK-6785: HiveQuerySuite - Date cast0.41 secPassed
SPARK-6785: HiveQuerySuite - Date comparison test 20.29 secPassed
SPARK-6835: udtf in lateral view0.16 secPassed
SPARK-6851: Self-joined converted parquet tables3.9 secPassed
SPARK-7269 Check analysis failed in case in-sensitive1.6 secPassed
SPARK-8976 Wrong Result for CUBE #11.9 secPassed
SPARK-8976 Wrong Result for CUBE #21.5 secPassed
SPARK-8976 Wrong Result for GroupingSet1.3 secPassed
SPARK-8976 Wrong Result for Rollup #11.6 secPassed
SPARK-8976 Wrong Result for Rollup #21.7 secPassed
SPARK-8976 Wrong Result for Rollup #32.3 secPassed
SPARK-9371: fix the support for special chars in column names for hive context0.3 secPassed
Sorting columns are not in Generate1 secPassed
Star Expansion - script transform7.3 secPassed
Support wildcard character in folderlevel for LOAD DATA LOCAL INPATH1.1 secPassed
TGF with non-TGF in projection0.25 secPassed
column resolution scenarios with hive table1.4 secPassed
command substitution0.82 secPassed
describe functions - built-in functions0.12 secPassed
describe functions - temporary user defined functions0.49 secPassed
describe functions - user defined functions0.56 secPassed
double nested data1.1 secPassed
dynamic partition value test3.5 secPassed
explode nested Field0.53 secPassed
inConversion fires too early0.19 secPassed
insert into datasource table0.85 secPassed
multi-insert with lateral view2.2 secPassed
non-existent global temp view8 msPassed
ordering not in agg0.89 secPassed
ordering not in select0.69 secPassed
partition pruning should handle date correctly2.1 secPassed
q2 secPassed
q2.1 secPassed
query global temp view0.12 secPassed
resolve udtf in projection #167 msPassed
resolve udtf in projection #20.46 secPassed
run sql directly on files - csv1.7 secPassed
run sql directly on files - hive0.32 secPassed
run sql directly on files - json1 secPassed
run sql directly on files - orc1.1 secPassed
run sql directly on files - parquet1 secPassed
sanity test for SPARK-66183 secPassed
script0.34 secPassed
select partitioned table3.4 secPassed
show functions0.93 secPassed
spark-15557 promote string test1.8 secPassed
specifying database name for a temporary view is not allowed0.64 secPassed
specifying the column list for CTAS1.2 secPassed
test CTAS2.1 secPassed
test case key when0.18 secPassed
test script transform data type0.31 secPassed
test script transform for stderr6.5 secPassed
test script transform for stdout7.1 secPassed