Test Result : SQLQuerySuite

0 failures (±0) , 3 skipped (±0)
117 tests (±0)
Took 3 min 1 sec.

All Tests

Test nameDurationStatus
Auto alias construction of get_json_object0.11 secPassed
CTAS with WITH clause1 secPassed
CTAS with default fileformat0.77 secPassed
CTAS with serde7.4 secPassed
CTAS without serde with location4.2 secPassed
CTAS without serde without location5.9 secPassed
Call add jar in a different thread (SPARK-8306)0.72 secPassed
Cast STRING to BIGINT55 msPassed
Insert overwrite with partition2.1 secPassed
SPARK-10310: script transformation using LazySimpleSerDe0 msSkipped
SPARK-10310: script transformation using default input/output SerDe and record reader/writer0 msSkipped
SPARK-10562: partition by column with mixed case name0 msSkipped
SPARK-10593 same column names in lateral view0.1 secPassed
SPARK-10741: Sort on Aggregate using parquet1.8 secPassed
SPARK-11453: append data to partitioned table2.3 secPassed
SPARK-11590: use native json_tuple in lateral view0.4 secPassed
SPARK-13651: generator outputs shouldn't be resolved from its child's output0.14 secPassed
SPARK-14981: DESC not supported for sorting columns9 msPassed
SPARK-15752 optimize metadata only query for hive table11 secPassed
SPARK-17108: Fix BIGINT and INT comparison failure in spark sql0.4 secPassed
SPARK-17354: Partitioning by dates/timestamps works with Parquet vectorized reader0.8 secPassed
SPARK-17409: Do Not Optimize Query in CTAS (Hive Serde Table) More Than Once0.99 secPassed
SPARK-17796 Support wildcard '?'char in middle as part of local file path0.53 secPassed
SPARK-17796 Support wildcard '?'char in start as part of local file path0.52 secPassed
SPARK-17796 Support wildcard character in filename for LOAD DATA LOCAL INPATH0.5 secPassed
SPARK-18355 Read data from a hive table with a new column - orc7.9 secPassed
SPARK-18355 Read data from a hive table with a new column - parquet7.9 secPassed
SPARK-19292: filter with partition columns should be case-insensitive on Hive tables1.6 secPassed
SPARK-19912 String literals should be escaped for Hive metastore partition pruning1.4 secPassed
SPARK-21721: Clear FileSystem deleterOnExit cache if path is successfully removed5.2 secPassed
SPARK-21912 Parquet table should not create invalid column names1.9 secPassed
SPARK-23425 Test LOAD DATA LOCAL INPATH with space in file name0.46 secPassed
SPARK-24085 scalar subquery in partitioning expression9.4 secPassed
SPARK-25158: Executor accidentally exit because ScriptTransformationWriterThread throw Exception0.26 secPassed
SPARK-25271: Hive ctas commands should use data source if it is convertible5.8 secPassed
SPARK-2554 SumDistinct partial aggregation1.6 secPassed
SPARK-25738: defaultFs can have a port1 msPassed
SPARK-26181 hasMinMaxStats method of ColumnStatsMap is not correct0.9 secPassed
SPARK-26709: OptimizeMetadataOnlyQuery does not handle empty records correctly1.8 secPassed
SPARK-28084 check for case insensitive property of partition column name in load command0.69 secPassed
SPARK-28551: CTAS Hive Table should be with non-existent or empty location4 secPassed
SPARK-29295: dynamic insert overwrite external partition should not have old data11 secPassed
SPARK-29295: dynamic partition map parsed from partition path should be case insensitive1 secPassed
SPARK-29295: insert overwrite external partition should not have old data3 secPassed
SPARK-31522: hive metastore related configurations should be static12 msPassed
SPARK-32668: HiveGenericUDTF initialize UDTF should use StructObjectInspector method0.25 secPassed
SPARK-32889: ORC table column name supports special characters11 secPassed
SPARK-36197: Use PartitionDesc instead of TableDesc for reading hive partitioned tables5.4 secPassed
SPARK-3708 Backticks aren't handled correctly is aliases0.24 secPassed
SPARK-3814 Support Bitwise & operator0.33 secPassed
SPARK-3814 Support Bitwise ^ operator0.42 secPassed
SPARK-3814 Support Bitwise | operator0.25 secPassed
SPARK-3814 Support Bitwise ~ operator0.31 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.7 secPassed
SPARK-4296 Grouping field with Hive UDF as sub expression0.81 secPassed
SPARK-4512 Fix attribute reference resolution error when using SORT BY0.92 secPassed
SPARK-4699 SparkSession with Hive Support should be case insensitive by default0.58 secPassed
SPARK-4825 save join to table2.7 secPassed
SPARK-4963 DataFrame sample on mutable row return wrong result1.8 secPassed
SPARK-5203 union with different decimal precision0.11 secPassed
SPARK-5284 Insert into Hive throws NPE when a inner complex type field has a null value1.3 secPassed
SPARK-5371: union with null and sum0.56 secPassed
SPARK-6785: HiveQuerySuite - Date cast0.23 secPassed
SPARK-6785: HiveQuerySuite - Date comparison test 20.42 secPassed
SPARK-6835: udtf in lateral view0.17 secPassed
SPARK-6851: Self-joined converted parquet tables2.8 secPassed
SPARK-7269 Check analysis failed in case in-sensitive0.78 secPassed
SPARK-8588 HiveTypeCoercion.inConversion fires too early0.22 secPassed
SPARK-8976 Wrong Result for CUBE #10.68 secPassed
SPARK-8976 Wrong Result for CUBE #20.9 secPassed
SPARK-8976 Wrong Result for GroupingSet0.78 secPassed
SPARK-8976 Wrong Result for Rollup #10.82 secPassed
SPARK-8976 Wrong Result for Rollup #20.89 secPassed
SPARK-8976 Wrong Result for Rollup #30.69 secPassed
SPARK-9371: fix the support for special chars in column names for hive context0.15 secPassed
Sorting columns are not in Generate0.42 secPassed
Star Expansion - script transform1.3 secPassed
Support wildcard character in folderlevel for LOAD DATA LOCAL INPATH0.55 secPassed
TGF with non-TGF in projection0.23 secPassed
column resolution scenarios with hive table0.9 secPassed
command substitution0.64 secPassed
derived from Hive query file: drop_database_removes_partition_dirs.q1.5 secPassed
derived from Hive query file: drop_table_removes_partition_dirs.q1.5 secPassed
describe functions - built-in functions92 msPassed
describe functions - temporary user defined functions0.35 secPassed
describe functions - user defined functions0.91 secPassed
double nested data1 secPassed
dynamic partition value test2.1 secPassed
explode nested Field0.63 secPassed
insert into datasource table0.64 secPassed
logical.Project should not be resolved if it contains aggregates or generators0.89 secPassed
multi-insert with lateral view1.5 secPassed
non-existent global temp view9 msPassed
ordering not in agg0.94 secPassed
ordering not in select0.64 secPassed
partition pruning should handle date correctly1.3 secPassed
query global temp view0.16 secPassed
resolve udtf in projection #10.16 secPassed
resolve udtf in projection #20.36 secPassed
run sql directly on files - csv1.1 secPassed
run sql directly on files - hive0.25 secPassed
run sql directly on files - json0.87 secPassed
run sql directly on files - orc0.8 secPassed
run sql directly on files - parquet0.88 secPassed
sanity test for SPARK-66182.1 secPassed
script0.4 secPassed
select partitioned table1.7 secPassed
show functions0.91 secPassed
spark-15557 promote string test1.1 secPassed
specifying database name for a temporary view is not allowed0.5 secPassed
specifying the column list for CTAS0.79 secPassed
test CTAS1 secPassed
test case key when0.11 secPassed
test script transform data type0.2 secPassed
test script transform for stderr0.9 secPassed
test script transform for stdout1 secPassed