Test Result : HiveQuerySuite

0 failures (±0) , 2 skipped (±0)
134 tests (±0)
Took 2 min 10 sec.

All Tests

Test nameDurationStatus
! operator0.27 secPassed
ADD FILE command0.4 secPassed
ADD JAR command0.23 secPassed
ADD JAR command 20.94 secPassed
CREATE TABLE AS runs once1.1 secPassed
CREATE TEMPORARY FUNCTION0.1 secPassed
CTE feature #10.74 secPassed
CTE feature #20.87 secPassed
CTE feature #30.76 secPassed
Cast Timestamp to Timestamp in UDF0.89 secPassed
Constant Folding Optimization for AVG_SUM_COUNT1.2 secPassed
DISTINCT1.1 secPassed
DataFrame toString20 msPassed
Date comparison test 10.69 secPassed
Dynamic partition folder layout-1 msSkipped
Escape sequences0.75 secPassed
Exactly once semantics for DDL and command statements0.24 secPassed
IgnoreExplain0.79 secPassed
LIKE0.79 secPassed
NaN to Decimal1.6 secPassed
Partition spec validation0.5 secPassed
Query expressed in HiveQL63 msPassed
Query with constant folding the CAST0.15 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN0.61 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #11.5 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #21.1 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #31.1 secPassed
SPARK-10484 Optimize the Cartesian (Cross) Join with broadcast based JOIN #40.98 secPassed
SPARK-1704: Explain commands as a DataFrame0.22 secPassed
SPARK-2180: HAVING support in GROUP BY clauses (positive)0.54 secPassed
SPARK-2180: HAVING with non-boolean clause raises no exceptions0.88 secPassed
SPARK-2263: Insert Map<K, V> values0.98 secPassed
SPARK-3414 regression: should store analyzed logical plan when creating a temporary view0.33 secPassed
SPARK-3810: PreprocessTableInsertion dynamic partitioning support1.4 secPassed
SPARK-3810: PreprocessTableInsertion static partitioning support3.1 secPassed
SPARK-5367: resolve star expression in udf0.5 secPassed
SPARK-5383 alias for udfs with multi output columns0.28 secPassed
SPARK-7270: consider dynamic partition when comparing table output0.83 secPassed
SPARK-9034 Reflect field names defined in GenericUDTF #10.88 secPassed
SPARK-9034 Reflect field names defined in GenericUDTF #20.89 secPassed
Simple Average0.83 secPassed
Simple Average + 10.68 secPassed
Simple Average + 1 with group1.5 secPassed
Specify the udtf output1 secPassed
URISyntaxException when dynamic partitioning3.9 secPassed
between0.79 secPassed
boolean = number0.67 secPassed
case else null0.73 secPassed
case sensitivity when query Hive table0.58 secPassed
case sensitivity: created temporary view0.25 secPassed
case statements WITHOUT key #11 secPassed
case statements WITHOUT key #21 secPassed
case statements WITHOUT key #30.76 secPassed
case statements WITHOUT key #40.68 secPassed
case statements with key #10.85 secPassed
case statements with key #20.84 secPassed
case statements with key #30.92 secPassed
case statements with key #40.95 secPassed
constant null testing0.75 secPassed
constant null testing timestamp94 msPassed
constant object inspector for generic udf0.74 secPassed
create table as1.9 secPassed
create table as with db name1.5 secPassed
create table as with db name within backticks1.4 secPassed
create/drop macro commands are not supported3 msPassed
create/drop/alter index commands are not supported3 msPassed
current_database with multiple sessions0.78 secPassed
div1.2 secPassed
division0.64 secPassed
double case0.74 secPassed
dynamic_partition4.1 secPassed
empty aggregate input0.96 secPassed
get_json_object #11.2 secPassed
get_json_object #100.95 secPassed
get_json_object #21.1 secPassed
get_json_object #33.5 secPassed
get_json_object #41.6 secPassed
get_json_object #51.4 secPassed
get_json_object #61.1 secPassed
get_json_object #71.4 secPassed
get_json_object #81.2 secPassed
get_json_object #91 secPassed
having no references2.1 secPassed
implement identity function using case statement0.14 secPassed
import/export commands are not supported3 msPassed
insert into and insert overwrite3.5 secPassed
insert table with db name1.9 secPassed
insert table with generator with column name1.7 secPassed
insert table with generator with multiple column names2.1 secPassed
insert table with generator without column name1.6 secPassed
lateral view10.96 secPassed
lateral view20.92 secPassed
lateral view31.4 secPassed
lateral view42.5 secPassed
lateral view51 secPassed
lateral view60.81 secPassed
lock/unlock table and database commands are not supported4 msPassed
lookup hive UDF in another thread78 msPassed
mode is nonstrict3.5 secPassed
modulus0.95 secPassed
multiple generators in projection41 msPassed
no from clause0.21 secPassed
non-boolean conditions in a CaseWhen are illegal-1 msSkipped
null case0.91 secPassed
parse HQL set commands36 msPassed
partitioned table scan3.7 secPassed
predicates contains an empty AttributeSet() references0.1 secPassed
role management commands are not supported19 msPassed
sampling28 msPassed
schema-less transform1 secPassed
select from thrift based table1.6 secPassed
select null from table1.8 secPassed
single case0.86 secPassed
some show commands are not supported4 msPassed
string literal0.8 secPassed
timestamp cast #10.1 secPassed
timestamp cast #280 msPassed
timestamp cast #30.63 secPassed
timestamp cast #40.58 secPassed
timestamp cast #50.11 secPassed
timestamp cast #688 msPassed
transform0.86 secPassed
transform with SerDe1.4 secPassed
transform with SerDe21.9 secPassed
transform with SerDe30.86 secPassed
transform with SerDe40.8 secPassed
transform with custom field delimiter0.77 secPassed
transform with custom field delimiter20.9 secPassed
transform with custom field delimiter31 secPassed
trivial join ON clause0.8 secPassed
trivial join where clause1 secPassed
udf0.68 secPassed
union/except/intersect1.3 secPassed
use database0.36 secPassed