Test Result : HiveQuerySuite

0 failures (±0) , 2 skipped (±0)
138 tests (±0)
Took 1 min 50 sec.

All Tests

Test nameDurationStatus
! operator0.33 secPassed
ADD FILE command0.31 secPassed
ADD JAR command0.24 secPassed
ADD JAR command 20.8 secPassed
CREATE TABLE AS runs once0.84 secPassed
CREATE TEMPORARY FUNCTION73 msPassed
CTE feature #10.72 secPassed
CTE feature #20.8 secPassed
CTE feature #30.72 secPassed
Cast Timestamp to Timestamp in UDF0.73 secPassed
Constant Folding Optimization for AVG_SUM_COUNT1 secPassed
DISTINCT0.97 secPassed
DataFrame toString27 msPassed
Date comparison test 10.7 secPassed
Dynamic partition folder layout-1 msSkipped
Escape sequences0.67 secPassed
Exactly once semantics for DDL and command statements0.28 secPassed
IgnoreExplain0.59 secPassed
LIKE0.71 secPassed
NaN to Decimal0.69 secPassed
Partition spec validation0.33 secPassed
Query expressed in HiveQL62 msPassed
Query with constant folding the CAST86 msPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN0.31 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #10.99 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.76 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #40.8 secPassed
SPARK-1704: Explain commands as a DataFrame0.32 secPassed
SPARK-2180: HAVING support in GROUP BY clauses (positive)0.57 secPassed
SPARK-2180: HAVING with non-boolean clause raises no exceptions0.76 secPassed
SPARK-2263: Insert Map<K, V> values1 secPassed
SPARK-28054: Unable to insert partitioned table when partition name is upper case2.4 secPassed
SPARK-3414 regression: should store analyzed logical plan when creating a temporary view62 msPassed
SPARK-3810: PreprocessTableInsertion dynamic partitioning support1.3 secPassed
SPARK-3810: PreprocessTableInsertion static partitioning support3 secPassed
SPARK-5367: resolve star expression in udf0.37 secPassed
SPARK-5383 alias for udfs with multi output columns0.16 secPassed
SPARK-7270: consider dynamic partition when comparing table output0.84 secPassed
SPARK-9034 Reflect field names defined in GenericUDTF #10.68 secPassed
SPARK-9034 Reflect field names defined in GenericUDTF #20.66 secPassed
Simple Average0.66 secPassed
Simple Average + 10.7 secPassed
Simple Average + 1 with group1 secPassed
Specify the udtf output0.68 secPassed
URISyntaxException when dynamic partitioning3.1 secPassed
between0.68 secPassed
boolean = number0.67 secPassed
case else null0.65 secPassed
case sensitivity when query Hive table0.78 secPassed
case sensitivity: created temporary view95 msPassed
case statements WITHOUT key #10.69 secPassed
case statements WITHOUT key #20.8 secPassed
case statements WITHOUT key #30.95 secPassed
case statements WITHOUT key #40.9 secPassed
case statements with key #10.66 secPassed
case statements with key #20.74 secPassed
case statements with key #30.76 secPassed
case statements with key #40.75 secPassed
constant null testing0.7 secPassed
constant null testing timestamp70 msPassed
constant object inspector for generic udf0.69 secPassed
create table as1.6 secPassed
create table as with db name1.5 secPassed
create table as with db name within backticks1.5 secPassed
create/drop macro commands are not supported1 msPassed
create/drop/alter index commands are not supported2 msPassed
current_database with multiple sessions0.84 secPassed
div0.65 secPassed
division0.16 secPassed
double case0.67 secPassed
dynamic_partition5.1 secPassed
empty aggregate input0.69 secPassed
get_json_object #11.1 secPassed
get_json_object #101 secPassed
get_json_object #21 secPassed
get_json_object #31 secPassed
get_json_object #41.1 secPassed
get_json_object #50.99 secPassed
get_json_object #61 secPassed
get_json_object #71 secPassed
get_json_object #81 secPassed
get_json_object #91 secPassed
having no references0.93 secPassed
implement identity function using case statement0.2 secPassed
import/export commands are not supported2 msPassed
insert into and insert overwrite3.1 secPassed
insert table with db name1.6 secPassed
insert table with generator with column name1.7 secPassed
insert table with generator with multiple column names1.6 secPassed
insert table with generator without column name1.4 secPassed
lateral view10.65 secPassed
lateral view20.62 secPassed
lateral view30.7 secPassed
lateral view41.9 secPassed
lateral view50.71 secPassed
lateral view60.72 secPassed
lock/unlock table and database commands are not supported2 msPassed
lookup hive UDF in another thread66 msPassed
mode is nonstrict2.5 secPassed
modulus0.64 secPassed
multiple generators in projection47 msPassed
no from clause0.24 secPassed
non-boolean conditions in a CaseWhen are illegal-1 msSkipped
null case0.66 secPassed
parse HQL set commands36 msPassed
partitioned table scan3 secPassed
predicates contains an empty AttributeSet() references0.12 secPassed
role management commands are not supported12 msPassed
sampling44 msPassed
schema-less transform0.94 secPassed
select from thrift based table1.8 secPassed
select null from table0.66 secPassed
single case0.64 secPassed
some show commands are not supported5 msPassed
string literal0.74 secPassed
timestamp cast #191 msPassed
timestamp cast #20.72 secPassed
timestamp cast #389 msPassed
timestamp cast #40.68 secPassed
timestamp cast #581 msPassed
timestamp cast #60.68 secPassed
timestamp cast #775 msPassed
timestamp cast #80.61 secPassed
transform0.97 secPassed
transform with SerDe0.8 secPassed
transform with SerDe21.1 secPassed
transform with SerDe30.79 secPassed
transform with SerDe40.9 secPassed
transform with custom field delimiter0.8 secPassed
transform with custom field delimiter20.81 secPassed
transform with custom field delimiter30.75 secPassed
trivial join ON clause0.77 secPassed
trivial join where clause0.86 secPassed
udf0.73 secPassed
udf_radians0.27 secPassed
union/except/intersect0.91 secPassed
use database0.22 secPassed