Test Result : HiveQuerySuite

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

All Tests

Test nameDurationStatus
! operator0.31 secPassed
ADD FILE command0.39 secPassed
ADD JAR command0.25 secPassed
ADD JAR command 21 secPassed
CREATE TABLE AS runs once0.82 secPassed
CREATE TEMPORARY FUNCTION0.11 secPassed
CTE feature #10.74 secPassed
CTE feature #20.84 secPassed
CTE feature #30.72 secPassed
Cast Timestamp to Timestamp in UDF0.72 secPassed
Constant Folding Optimization for AVG_SUM_COUNT1 secPassed
DISTINCT1 secPassed
DataFrame toString38 msPassed
Date comparison test 10.79 secPassed
Dynamic partition folder layout-1 msSkipped
Escape sequences0.67 secPassed
Exactly once semantics for DDL and command statements0.26 secPassed
IgnoreExplain0.55 secPassed
LIKE0.78 secPassed
NaN to Decimal0.72 secPassed
Partition spec validation0.36 secPassed
Query expressed in HiveQL56 msPassed
Query with constant folding the CAST93 msPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN0.38 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #11 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #20.78 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #30.89 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #40.87 secPassed
SPARK-1704: Explain commands as a DataFrame0.3 secPassed
SPARK-2180: HAVING support in GROUP BY clauses (positive)0.5 secPassed
SPARK-2180: HAVING with non-boolean clause raises no exceptions0.73 secPassed
SPARK-2263: Insert Map<K, V> values0.95 secPassed
SPARK-28054: Unable to insert partitioned table when partition name is upper case2.3 secPassed
SPARK-3414 regression: should store analyzed logical plan when creating a temporary view70 msPassed
SPARK-3810: PreprocessTableInsertion dynamic partitioning support1.3 secPassed
SPARK-3810: PreprocessTableInsertion static partitioning support2.3 secPassed
SPARK-5367: resolve star expression in udf0.34 secPassed
SPARK-5383 alias for udfs with multi output columns0.18 secPassed
SPARK-7270: consider dynamic partition when comparing table output0.74 secPassed
SPARK-9034 Reflect field names defined in GenericUDTF #10.7 secPassed
SPARK-9034 Reflect field names defined in GenericUDTF #20.7 secPassed
Simple Average0.69 secPassed
Simple Average + 10.69 secPassed
Simple Average + 1 with group0.95 secPassed
Specify the udtf output0.69 secPassed
URISyntaxException when dynamic partitioning2.8 secPassed
between0.88 secPassed
boolean = number0.83 secPassed
case else null0.85 secPassed
case sensitivity when query Hive table0.79 secPassed
case sensitivity: created temporary view93 msPassed
case statements WITHOUT key #10.74 secPassed
case statements WITHOUT key #20.8 secPassed
case statements WITHOUT key #30.77 secPassed
case statements WITHOUT key #40.78 secPassed
case statements with key #10.75 secPassed
case statements with key #20.72 secPassed
case statements with key #30.78 secPassed
case statements with key #40.69 secPassed
constant null testing0.79 secPassed
constant null testing timestamp51 msPassed
constant object inspector for generic udf0.7 secPassed
create table as1.4 secPassed
create table as with db name1.4 secPassed
create table as with db name within backticks1.5 secPassed
create/drop macro commands are not supported2 msPassed
create/drop/alter index commands are not supported3 msPassed
current_database with multiple sessions0.71 secPassed
div0.69 secPassed
division0.14 secPassed
double case0.85 secPassed
dynamic_partition4.9 secPassed
empty aggregate input0.64 secPassed
get_json_object #11.1 secPassed
get_json_object #101.4 secPassed
get_json_object #21 secPassed
get_json_object #31.1 secPassed
get_json_object #41 secPassed
get_json_object #50.95 secPassed
get_json_object #60.94 secPassed
get_json_object #71.1 secPassed
get_json_object #81 secPassed
get_json_object #91.1 secPassed
having no references1.1 secPassed
implement identity function using case statement0.19 secPassed
import/export commands are not supported2 msPassed
insert into and insert overwrite2.9 secPassed
insert table with db name1.4 secPassed
insert table with generator with column name1.5 secPassed
insert table with generator with multiple column names1.4 secPassed
insert table with generator without column name1.5 secPassed
lateral view10.73 secPassed
lateral view20.62 secPassed
lateral view30.71 secPassed
lateral view41.9 secPassed
lateral view50.73 secPassed
lateral view60.64 secPassed
lock/unlock table and database commands are not supported4 msPassed
lookup hive UDF in another thread90 msPassed
mode is nonstrict2.6 secPassed
modulus0.7 secPassed
multiple generators in projection55 msPassed
no from clause0.3 secPassed
non-boolean conditions in a CaseWhen are illegal-1 msSkipped
null case0.79 secPassed
parse HQL set commands52 msPassed
partitioned table scan2.6 secPassed
predicates contains an empty AttributeSet() references0.13 secPassed
role management commands are not supported23 msPassed
sampling60 msPassed
schema-less transform0.92 secPassed
select from thrift based table1.9 secPassed
select null from table0.81 secPassed
single case0.74 secPassed
some show commands are not supported3 msPassed
string literal0.65 secPassed
timestamp cast #199 msPassed
timestamp cast #20.69 secPassed
timestamp cast #30.1 secPassed
timestamp cast #40.66 secPassed
timestamp cast #577 msPassed
timestamp cast #60.67 secPassed
timestamp cast #775 msPassed
timestamp cast #80.72 secPassed
transform0.82 secPassed
transform with SerDe0.76 secPassed
transform with SerDe21 secPassed
transform with SerDe30.78 secPassed
transform with SerDe40.79 secPassed
transform with custom field delimiter0.79 secPassed
transform with custom field delimiter20.81 secPassed
transform with custom field delimiter30.92 secPassed
trivial join ON clause0.82 secPassed
trivial join where clause0.8 secPassed
udf0.67 secPassed
udf_radians0.29 secPassed
union/except/intersect0.9 secPassed
use database0.24 secPassed