Test Result : HiveQuerySuite

0 failures (±0) , 2 skipped (±0)
136 tests (+2)
Took 2 min 16 sec.

All Tests

Test nameDurationStatus
! operator2.7 secPassed
ADD FILE command0.34 secPassed
ADD JAR command0.27 secPassed
ADD JAR command 20.99 secPassed
CREATE TABLE AS runs once0.88 secPassed
CREATE TEMPORARY FUNCTION0.19 secPassed
CTE feature #10.81 secPassed
CTE feature #20.67 secPassed
CTE feature #30.61 secPassed
Cast Timestamp to Timestamp in UDF1.6 secPassed
Constant Folding Optimization for AVG_SUM_COUNT2.1 secPassed
DISTINCT0.92 secPassed
DataFrame toString26 msPassed
Date comparison test 11.2 secPassed
Dynamic partition folder layout-1 msSkipped
Escape sequences1.1 secPassed
Exactly once semantics for DDL and command statements0.35 secPassed
IgnoreExplain0.81 secPassed
LIKE0.68 secPassed
NaN to Decimal1.5 secPassed
Partition spec validation0.47 secPassed
Query expressed in HiveQL0.1 secPassed
Query with constant folding the CAST0.69 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN0.25 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #10.86 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #20.82 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #30.9 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #40.79 secPassed
SPARK-1704: Explain commands as a DataFrame0.54 secPassed
SPARK-2180: HAVING support in GROUP BY clauses (positive)0.53 secPassed
SPARK-2180: HAVING with non-boolean clause raises no exceptions0.77 secPassed
SPARK-2263: Insert Map<K, V> values1.1 secPassed
SPARK-28054: Unable to insert partitioned table when partition name is upper case3.2 secPassed
SPARK-3414 regression: should store analyzed logical plan when creating a temporary view88 msPassed
SPARK-3810: PreprocessTableInsertion dynamic partitioning support1.4 secPassed
SPARK-3810: PreprocessTableInsertion static partitioning support3.2 secPassed
SPARK-5367: resolve star expression in udf0.41 secPassed
SPARK-5383 alias for udfs with multi output columns0.17 secPassed
SPARK-7270: consider dynamic partition when comparing table output0.78 secPassed
SPARK-9034 Reflect field names defined in GenericUDTF #10.78 secPassed
SPARK-9034 Reflect field names defined in GenericUDTF #20.83 secPassed
Simple Average1.3 secPassed
Simple Average + 10.94 secPassed
Simple Average + 1 with group1.6 secPassed
Specify the udtf output0.89 secPassed
URISyntaxException when dynamic partitioning3.4 secPassed
between1.3 secPassed
boolean = number0.83 secPassed
case else null0.69 secPassed
case sensitivity when query Hive table1 secPassed
case sensitivity: created temporary view0.15 secPassed
case statements WITHOUT key #10.92 secPassed
case statements WITHOUT key #20.95 secPassed
case statements WITHOUT key #31 secPassed
case statements WITHOUT key #41.4 secPassed
case statements with key #10.91 secPassed
case statements with key #21.1 secPassed
case statements with key #31.1 secPassed
case statements with key #40.84 secPassed
constant null testing0.85 secPassed
constant null testing timestamp61 msPassed
constant object inspector for generic udf1.5 secPassed
create table as2.3 secPassed
create table as with db name1.5 secPassed
create table as with db name within backticks2 secPassed
create/drop macro commands are not supported3 msPassed
create/drop/alter index commands are not supported4 msPassed
current_database with multiple sessions0.79 secPassed
div0.93 secPassed
division0.33 secPassed
double case0.66 secPassed
dynamic_partition4.5 secPassed
empty aggregate input0.77 secPassed
get_json_object #11.1 secPassed
get_json_object #100.92 secPassed
get_json_object #21.2 secPassed
get_json_object #31.2 secPassed
get_json_object #41.2 secPassed
get_json_object #51.3 secPassed
get_json_object #61.8 secPassed
get_json_object #71.4 secPassed
get_json_object #81.6 secPassed
get_json_object #91.3 secPassed
having no references1.1 secPassed
implement identity function using case statement0.2 secPassed
import/export commands are not supported3 msPassed
insert into and insert overwrite3 secPassed
insert table with db name1.6 secPassed
insert table with generator with column name2 secPassed
insert table with generator with multiple column names1.5 secPassed
insert table with generator without column name1.4 secPassed
lateral view10.76 secPassed
lateral view20.95 secPassed
lateral view30.99 secPassed
lateral view42.5 secPassed
lateral view51.3 secPassed
lateral view61.2 secPassed
lock/unlock table and database commands are not supported3 msPassed
lookup hive UDF in another thread90 msPassed
mode is nonstrict3 secPassed
modulus1.6 secPassed
multiple generators in projection49 msPassed
no from clause0.26 secPassed
non-boolean conditions in a CaseWhen are illegal-1 msSkipped
null case0.75 secPassed
parse HQL set commands47 msPassed
partitioned table scan3.8 secPassed
predicates contains an empty AttributeSet() references0.1 secPassed
role management commands are not supported17 msPassed
sampling46 msPassed
schema-less transform0.93 secPassed
select from thrift based table1.9 secPassed
select null from table0.92 secPassed
single case0.69 secPassed
some show commands are not supported9 msPassed
string literal0.91 secPassed
timestamp cast #10.11 secPassed
timestamp cast #20.18 secPassed
timestamp cast #31.2 secPassed
timestamp cast #40.88 secPassed
timestamp cast #50.11 secPassed
timestamp cast #60.18 secPassed
transform0.83 secPassed
transform with SerDe0.96 secPassed
transform with SerDe20.97 secPassed
transform with SerDe30.76 secPassed
transform with SerDe40.73 secPassed
transform with custom field delimiter0.8 secPassed
transform with custom field delimiter20.83 secPassed
transform with custom field delimiter30.9 secPassed
trivial join ON clause1 secPassed
trivial join where clause1 secPassed
udf1 secPassed
udf_radians0.27 secPassed
union/except/intersect0.89 secPassed
use database0.28 secPassed