Test Result : SelectedFieldSuite

0 failures
31 tests
Took 1.6 sec.

All Tests

Test nameDurationStatus
SELECT "col2.field1" should select the schema root |-- col2: struct (nullable = true) | |-- field1: integer (nullable = true)36 msPassed
SELECT "col2.field2", "col2.field2[0] as foo" should select the schema root |-- col2: struct (nullable = true) | |-- field2: array (nullable = true) | | |-- element: integer (containsNull = false)77 msPassed
SELECT "col2.field3.subfield1" should select the schema root |-- col2: struct (nullable = true) | |-- field3: array (nullable = false) | | |-- element: struct (containsNull = true) | | | |-- subfield1: integer (nullable = true)35 msPassed
SELECT "col2.field3.subfield3", "col2.field3[0].subfield3 as foo", "col2.field3.subfield3[0] as foo", "col2.field3[0].subfield3[0] as foo" should select the schema root |-- col2: struct (nullable = true) | |-- field3: array (nullable = false) | | |-- element: struct (containsNull = true) | | | |-- subfield3: array (nullable = true) | | | | |-- element: integer (containsNull = true)0.14 secPassed
SELECT "col2.field4['foo'].subfield1 as foo" should select the schema root |-- col2: struct (nullable = true) | |-- field4: map (nullable = true) | | |-- key: string | | |-- value: struct (valueContainsNull = false) | | | |-- subfield1: integer (nullable = true)35 msPassed
SELECT "col2.field4['foo'].subfield2 as foo", "col2.field4['foo'].subfield2[0] as foo" should select the schema root |-- col2: struct (nullable = true) | |-- field4: map (nullable = true) | | |-- key: string | | |-- value: struct (valueContainsNull = false) | | | |-- subfield2: array (nullable = true) | | | | |-- element: integer (containsNull = false)71 msPassed
SELECT "col2.field5.subfield1" should select the schema root |-- col2: struct (nullable = true) | |-- field5: array (nullable = false) | | |-- element: struct (containsNull = true) | | | |-- subfield1: struct (nullable = false) | | | | |-- subsubfield1: integer (nullable = true) | | | | |-- subsubfield2: integer (nullable = true)65 msPassed
SELECT "col2.field5.subfield1.subsubfield1" should select the schema root |-- col2: struct (nullable = true) | |-- field5: array (nullable = false) | | |-- element: struct (containsNull = true) | | | |-- subfield1: struct (nullable = false) | | | | |-- subsubfield1: integer (nullable = true)38 msPassed
SELECT "col2.field5.subfield2.subsubfield1.subsubsubfield1" should select the schema root |-- col2: struct (nullable = true) | |-- field5: array (nullable = false) | | |-- element: struct (containsNull = true) | | | |-- subfield2: struct (nullable = true) | | | | |-- subsubfield1: struct (nullable = true) | | | | | |-- subsubsubfield1: string (nullable = true)35 msPassed
SELECT "col2.field6" should select the schema root |-- col2: struct (nullable = true) | |-- field6: struct (nullable = true) | | |-- subfield1: string (nullable = false) | | |-- subfield2: string (nullable = true)35 msPassed
SELECT "col2.field6.subfield1" should select the schema root |-- col2: struct (nullable = true) | |-- field6: struct (nullable = true) | | |-- subfield1: string (nullable = false)35 msPassed
SELECT "col2.field7.subfield1" should select the schema root |-- col2: struct (nullable = true) | |-- field7: struct (nullable = true) | | |-- subfield1: struct (nullable = true) | | | |-- subsubfield1: integer (nullable = true) | | | |-- subsubfield2: integer (nullable = true)35 msPassed
SELECT "col2.field8['foo'][0].subfield1 as foo" should select the schema root |-- col2: struct (nullable = true) | |-- field8: map (nullable = true) | | |-- key: string | | |-- value: array (valueContainsNull = false) | | | |-- element: struct (containsNull = true) | | | | |-- subfield1: integer (nullable = true)36 msPassed
SELECT "col2.field9", "col2.field9['foo'] as foo" should select the schema root |-- col2: struct (nullable = true) | |-- field9: map (nullable = true) | | |-- key: string | | |-- value: integer (valueContainsNull = false)72 msPassed
SELECT "col3.field1.subfield1" should select the schema root |-- col3: array (nullable = false) | |-- element: struct (containsNull = true) | | |-- field1: struct (nullable = true) | | | |-- subfield1: integer (nullable = false)35 msPassed
SELECT "col3.field2['foo'] as foo" should select the schema root |-- col3: array (nullable = false) | |-- element: struct (containsNull = true) | | |-- field2: map (nullable = true) | | | |-- key: string | | | |-- value: integer (valueContainsNull = false)35 msPassed
SELECT "col4['foo'].field1.subfield1 as foo" should select the schema root |-- col4: map (nullable = false) | |-- key: string | |-- value: struct (valueContainsNull = false) | | |-- field1: struct (nullable = true) | | | |-- subfield1: integer (nullable = false)36 msPassed
SELECT "col4['foo'].field2['bar'] as foo" should select the schema root |-- col4: map (nullable = false) | |-- key: string | |-- value: struct (valueContainsNull = false) | | |-- field2: map (nullable = true) | | | |-- key: string | | | |-- value: integer (valueContainsNull = false)35 msPassed
SELECT "col5[0]['foo'].field1.subfield1 as foo" should select the schema root |-- col5: array (nullable = true) | |-- element: map (containsNull = true) | | |-- key: string | | |-- value: struct (valueContainsNull = false) | | | |-- field1: struct (nullable = true) | | | | |-- subfield1: integer (nullable = true)36 msPassed
SELECT "col6['foo'][0].field1.subfield1 as foo" should select the schema root |-- col6: map (nullable = true) | |-- key: string | |-- value: array (valueContainsNull = true) | | |-- element: struct (containsNull = false) | | | |-- field1: struct (nullable = true) | | | | |-- subfield1: integer (nullable = true)35 msPassed
SELECT "col7.field1", "col7[0].field1 as foo", "col7.field1[0] as foo" should select the schema root |-- col7: array (nullable = true) | |-- element: struct (containsNull = true) | | |-- field1: integer (nullable = false)0.1 secPassed
SELECT "col7.field2.subfield1" should select the schema root |-- col7: array (nullable = true) | |-- element: struct (containsNull = true) | | |-- field2: struct (nullable = true) | | | |-- subfield1: integer (nullable = false)35 msPassed
SELECT "col7.field3.subfield1" should select the schema root |-- col7: array (nullable = true) | |-- element: struct (containsNull = true) | | |-- field3: array (nullable = true) | | | |-- element: struct (containsNull = true) | | | | |-- subfield1: integer (nullable = false)35 msPassed
SELECT "col8.field1", "col8[0].field1 as foo", "col8.field1[0] as foo", "col8[0].field1[0] as foo" should select the schema root |-- col8: array (nullable = true) | |-- element: struct (containsNull = true) | | |-- field1: array (nullable = false) | | | |-- element: integer (containsNull = false)0.14 secPassed
SELECT "map_keys(col2).field1 as foo" should select the schema root |-- col2: map (nullable = true) | |-- key: struct | | |-- field1: string (nullable = true) | |-- value: array (valueContainsNull = true) | | |-- element: struct (containsNull = false) | | | |-- field3: struct (nullable = true) | | | | |-- subfield1: integer (nullable = true) | | | | |-- subfield2: integer (nullable = true)38 msPassed
SELECT "map_keys(col2).field2 as foo" should select the schema root |-- col2: map (nullable = true) | |-- key: struct | | |-- field2: integer (nullable = true) | |-- value: array (valueContainsNull = true) | | |-- element: struct (containsNull = false) | | | |-- field3: struct (nullable = true) | | | | |-- subfield1: integer (nullable = true) | | | | |-- subfield2: integer (nullable = true)36 msPassed
SELECT "map_keys(col2)[0].field1 as foo" should select the schema root |-- col2: map (nullable = true) | |-- key: array | | |-- element: struct (containsNull = true) | | | |-- field1: string (nullable = true) | |-- value: array (valueContainsNull = true) | | |-- element: struct (containsNull = false) | | | |-- field3: struct (nullable = true) | | | | |-- subfield3: integer (nullable = true) | | | | |-- subfield4: integer (nullable = true)37 msPassed
SELECT "map_keys(col2)[0].field2.subfield1 as foo" should select the schema root |-- col2: map (nullable = true) | |-- key: array | | |-- element: struct (containsNull = true) | | | |-- field2: struct (nullable = true) | | | | |-- subfield1: integer (nullable = true) | |-- value: array (valueContainsNull = true) | | |-- element: struct (containsNull = false) | | | |-- field3: struct (nullable = true) | | | | |-- subfield3: integer (nullable = true) | | | | |-- subfield4: integer (nullable = true)37 msPassed
SELECT "map_values(col5[0]).field1.subfield1 as foo" should select the schema root |-- col5: array (nullable = true) | |-- element: map (containsNull = true) | | |-- key: string | | |-- value: struct (valueContainsNull = false) | | | |-- field1: struct (nullable = true) | | | | |-- subfield1: integer (nullable = true)39 msPassed
SELECT "map_values(col5[0]).field1.subfield2 as foo" should select the schema root |-- col5: array (nullable = true) | |-- element: map (containsNull = true) | | |-- key: string | | |-- value: struct (valueContainsNull = false) | | | |-- field1: struct (nullable = true) | | | | |-- subfield2: integer (nullable = true)37 msPassed
SelectedField should not match an attribute reference0.1 secPassed