Google Git
Sign in
apache / spark / 8879df5fc12b4c80df8382a55fddec87520b9ee8 / . / sql / connect / common / src / test / resources / query-tests / explain-results
tree: be10e5036956602f6b73f9c6acd939dacfbf8015 [path history] [tgz]
  1. alias_string.explain
  2. alias_symbol.explain
  3. apply.explain
  4. as_string.explain
  5. as_symbol.explain
  6. between_expr.explain
  7. coalesce.explain
  8. col.explain
  9. colRegex.explain
  10. column_add.explain
  11. column_alias.explain
  12. column_and.explain
  13. column_apply.explain
  14. column_as_multi.explain
  15. column_as_with_metadata.explain
  16. column_asc.explain
  17. column_asc_nulls_first.explain
  18. column_asc_nulls_last.explain
  19. column_between.explain
  20. column_bitwiseAND.explain
  21. column_bitwiseOR.explain
  22. column_bitwiseXOR.explain
  23. column_cast.explain
  24. column_contains.explain
  25. column_desc.explain
  26. column_desc_nulls_first.explain
  27. column_desc_nulls_last.explain
  28. column_divide.explain
  29. column_dropFields.explain
  30. column_endsWith.explain
  31. column_eqNullSafe.explain
  32. column_equals.explain
  33. column_geq.explain
  34. column_getField.explain
  35. column_getItem.explain
  36. column_gt.explain
  37. column_ilike.explain
  38. column_isin.explain
  39. column_isNaN.explain
  40. column_isNotNull.explain
  41. column_isNull.explain
  42. column_leq.explain
  43. column_like.explain
  44. column_lt.explain
  45. column_modulo.explain
  46. column_multiply.explain
  47. column_not.explain
  48. column_not_equals.explain
  49. column_or.explain
  50. column_rlike.explain
  51. column_star.explain
  52. column_star_with_target.explain
  53. column_startsWith.explain
  54. column_substr.explain
  55. column_subtract.explain
  56. column_try_cast.explain
  57. column_unary_minus.explain
  58. column_when_otherwise.explain
  59. column_withField.explain
  60. crossJoin.explain
  61. crosstab.explain
  62. csv_from_dataset.explain
  63. cube_column.explain
  64. cube_string.explain
  65. describe.explain
  66. distinct.explain
  67. drop.explain
  68. drop_multiple_column.explain
  69. drop_multiple_strings.explain
  70. drop_single_column.explain
  71. drop_single_string.explain
  72. dropDuplicates.explain
  73. dropDuplicates_names_array.explain
  74. dropDuplicates_names_seq.explain
  75. dropDuplicates_varargs.explain
  76. except.explain
  77. exceptAll.explain
  78. expression_extension.explain
  79. expression_extension_deprecated.explain
  80. fill.explain
  81. filter.explain
  82. filter_expr.explain
  83. freqItems.explain
  84. from_avro_with_options.explain
  85. from_avro_without_options.explain
  86. from_protobuf_messageClassName_descFilePath.explain
  87. from_protobuf_messageClassName_descFilePath_options.explain
  88. function_abs.explain
  89. function_acos.explain
  90. function_acosh.explain
  91. function_add_months.explain
  92. function_aes_decrypt.explain
  93. function_aes_decrypt_with_mode.explain
  94. function_aes_decrypt_with_mode_padding.explain
  95. function_aes_decrypt_with_mode_padding_aad.explain
  96. function_aes_encrypt.explain
  97. function_aes_encrypt_with_mode.explain
  98. function_aes_encrypt_with_mode_padding.explain
  99. function_aes_encrypt_with_mode_padding_iv.explain
  100. function_aes_encrypt_with_mode_padding_iv_aad.explain
  101. function_aggregate.explain
  102. function_aggregate_with_finish_lambda.explain
  103. function_any.explain
  104. function_any_value_with_ignore_nulls.explain
  105. function_any_value_with_respect_nulls.explain
  106. function_approx_count_distinct.explain
  107. function_approx_count_distinct_rsd.explain
  108. function_approx_percentile.explain
  109. function_array.explain
  110. function_array_agg.explain
  111. function_array_append.explain
  112. function_array_compact.explain
  113. function_array_contains.explain
  114. function_array_distinct.explain
  115. function_array_except.explain
  116. function_array_insert.explain
  117. function_array_intersect.explain
  118. function_array_join.explain
  119. function_array_join_with_null_replacement.explain
  120. function_array_max.explain
  121. function_array_min.explain
  122. function_array_position.explain
  123. function_array_prepend.explain
  124. function_array_remove.explain
  125. function_array_repeat.explain
  126. function_array_size.explain
  127. function_array_sort.explain
  128. function_array_sort_with_comparator.explain
  129. function_array_union.explain
  130. function_arrays_overlap.explain
  131. function_arrays_zip.explain
  132. function_asc.explain
  133. function_asc_nulls_first.explain
  134. function_asc_nulls_last.explain
  135. function_ascii.explain
  136. function_asin.explain
  137. function_asinh.explain
  138. function_assert_true_with_message.explain
  139. function_atan.explain
  140. function_atan2.explain
  141. function_atanh.explain
  142. function_avg.explain
  143. function_base64.explain
  144. function_bin.explain
  145. function_bit_and.explain
  146. function_bit_count.explain
  147. function_bit_get.explain
  148. function_bit_length.explain
  149. function_bit_or.explain
  150. function_bit_xor.explain
  151. function_bitmap_bit_position.explain
  152. function_bitmap_bucket_number.explain
  153. function_bitmap_construct_agg.explain
  154. function_bitmap_count.explain
  155. function_bitmap_or_agg.explain
  156. function_bitwise_not.explain
  157. function_bool_and.explain
  158. function_bool_or.explain
  159. function_bround.explain
  160. function_btrim.explain
  161. function_btrim_with_specified_trim_string.explain
  162. function_bucket.explain
  163. function_call_function.explain
  164. function_call_function_orphaned.explain
  165. function_cardinality.explain
  166. function_ceil.explain
  167. function_ceil_scale.explain
  168. function_ceiling.explain
  169. function_ceiling_scale.explain
  170. function_char.explain
  171. function_char_length.explain
  172. function_character_length.explain
  173. function_chr.explain
  174. function_coalesce.explain
  175. function_col.explain
  176. function_collate.explain
  177. function_collation.explain
  178. function_collect_list.explain
  179. function_collect_set.explain
  180. function_concat.explain
  181. function_concat_ws.explain
  182. function_contains.explain
  183. function_conv.explain
  184. function_convert_timezone_with_source_time_zone.explain
  185. function_convert_timezone_without_source_time_zone.explain
  186. function_corr.explain
  187. function_cos.explain
  188. function_cosh.explain
  189. function_cot.explain
  190. function_count.explain
  191. function_count_if.explain
  192. function_count_min_sketch.explain
  193. function_count_typed.explain
  194. function_countDistinct.explain
  195. function_covar_pop.explain
  196. function_covar_samp.explain
  197. function_crc32.explain
  198. function_csc.explain
  199. function_cume_dist.explain
  200. function_curdate.explain
  201. function_current_catalog.explain
  202. function_current_database.explain
  203. function_current_date.explain
  204. function_current_schema.explain
  205. function_current_timestamp.explain
  206. function_current_timezone.explain
  207. function_current_user.explain
  208. function_date_add.explain
  209. function_date_diff.explain
  210. function_date_format.explain
  211. function_date_from_unix_date.explain
  212. function_date_part.explain
  213. function_date_sub.explain
  214. function_date_trunc.explain
  215. function_dateadd.explain
  216. function_datediff.explain
  217. function_datepart.explain
  218. function_day.explain
  219. function_dayname.explain
  220. function_dayofmonth.explain
  221. function_dayofweek.explain
  222. function_dayofyear.explain
  223. function_days.explain
  224. function_decode.explain
  225. function_degrees.explain
  226. function_dense_rank.explain
  227. function_desc.explain
  228. function_desc_nulls_first.explain
  229. function_desc_nulls_last.explain
  230. function_e.explain
  231. function_element_at.explain
  232. function_elt.explain
  233. function_encode.explain
  234. function_endswith.explain
  235. function_equal_null.explain
  236. function_every.explain
  237. function_exists.explain
  238. function_exp.explain
  239. function_explode.explain
  240. function_explode_outer.explain
  241. function_expm1.explain
  242. function_expr.explain
  243. function_extract.explain
  244. function_factorial.explain
  245. function_filter.explain
  246. function_filter_with_pair_input.explain
  247. function_find_in_set.explain
  248. function_first_value_with_ignore_nulls.explain
  249. function_first_value_with_respect_nulls.explain
  250. function_first_with_ignore_nulls.explain
  251. function_first_with_respect_nulls.explain
  252. function_flatten.explain
  253. function_floor.explain
  254. function_floor_scale.explain
  255. function_forall.explain
  256. function_format_number.explain
  257. function_from_csv.explain
  258. function_from_json.explain
  259. function_from_json_orphaned.explain
  260. function_from_json_with_json_schema.explain
  261. function_from_unixtime.explain
  262. function_from_utc_timestamp.explain
  263. function_from_xml.explain
  264. function_from_xml_with_json_schema.explain
  265. function_get.explain
  266. function_get_json_object.explain
  267. function_getbit.explain
  268. function_greatest.explain
  269. function_hash.explain
  270. function_hex.explain
  271. function_histogram_numeric.explain
  272. function_hour.explain
  273. function_hours.explain
  274. function_hypot.explain
  275. function_ifnull.explain
  276. function_ilike.explain
  277. function_ilike_with_escape.explain
  278. function_initcap.explain
  279. function_inline.explain
  280. function_inline_outer.explain
  281. function_input_file_block_length.explain
  282. function_input_file_block_start.explain
  283. function_input_file_name.explain
  284. function_is_variant_null.explain
  285. function_isnan.explain
  286. function_isnotnull.explain
  287. function_isnull.explain
  288. function_java_method.explain
  289. function_json_array_length.explain
  290. function_json_object_keys.explain
  291. function_json_tuple.explain
  292. function_kurtosis.explain
  293. function_lag.explain
  294. function_last_day.explain
  295. function_last_value_with_ignore_nulls.explain
  296. function_last_value_with_respect_nulls.explain
  297. function_last_with_ignore_nulls.explain
  298. function_last_with_respect_nulls.explain
  299. function_lcase.explain
  300. function_lead.explain
  301. function_least.explain
  302. function_left.explain
  303. function_len.explain
  304. function_length.explain
  305. function_levenshtein.explain
  306. function_levenshtein_with_threshold.explain
  307. function_like.explain
  308. function_like_with_escape.explain
  309. function_lit.explain
  310. function_lit_array.explain
  311. function_ln.explain
  312. function_localtimestamp.explain
  313. function_locate.explain
  314. function_locate_with_pos.explain
  315. function_log.explain
  316. function_log10.explain
  317. function_log1p.explain
  318. function_log2.explain
  319. function_log_with_base.explain
  320. function_lower.explain
  321. function_lpad.explain
  322. function_lpad_binary.explain
  323. function_ltrim.explain
  324. function_ltrim_with_pattern.explain
  325. function_make_date.explain
  326. function_make_dt_interval.explain
  327. function_make_dt_interval_days.explain
  328. function_make_dt_interval_days_hours.explain
  329. function_make_dt_interval_days_hours_mins.explain
  330. function_make_dt_interval_days_hours_mins_secs.explain
  331. function_make_interval.explain
  332. function_make_interval_years.explain
  333. function_make_interval_years_months.explain
  334. function_make_interval_years_months_weeks.explain
  335. function_make_interval_years_months_weeks_days.explain
  336. function_make_interval_years_months_weeks_days_hours.explain
  337. function_make_interval_years_months_weeks_days_hours_mins.explain
  338. function_make_interval_years_months_weeks_days_hours_mins_secs.explain
  339. function_make_timestamp_ltz_with_timezone.explain
  340. function_make_timestamp_ltz_without_timezone.explain
  341. function_make_timestamp_ntz.explain
  342. function_make_timestamp_with_timezone.explain
  343. function_make_timestamp_without_timezone.explain
  344. function_make_ym_interval.explain
  345. function_make_ym_interval_years.explain
  346. function_make_ym_interval_years_months.explain
  347. function_map.explain
  348. function_map_concat.explain
  349. function_map_contains_key.explain
  350. function_map_entries.explain
  351. function_map_filter.explain
  352. function_map_from_arrays.explain
  353. function_map_from_entries.explain
  354. function_map_keys.explain
  355. function_map_values.explain
  356. function_map_zip_with.explain
  357. function_mask.explain
  358. function_mask_with_specific_upperChar.explain
  359. function_mask_with_specific_upperChar_lowerChar.explain
  360. function_mask_with_specific_upperChar_lowerChar_digitChar.explain
  361. function_mask_with_specific_upperChar_lowerChar_digitChar_otherChar.explain
  362. function_max.explain
  363. function_max_by.explain
  364. function_md5.explain
  365. function_median.explain
  366. function_min.explain
  367. function_min_by.explain
  368. function_minute.explain
  369. function_mode.explain
  370. function_mode_orphaned.explain
  371. function_monotonically_increasing_id.explain
  372. function_month.explain
  373. function_monthname.explain
  374. function_months.explain
  375. function_months_between.explain
  376. function_months_between_with_roundoff.explain
  377. function_named_struct.explain
  378. function_nanvl.explain
  379. function_negate.explain
  380. function_negative.explain
  381. function_next_day.explain
  382. function_now.explain
  383. function_nth_value.explain
  384. function_ntile.explain
  385. function_nullif.explain
  386. function_nvl.explain
  387. function_nvl2.explain
  388. function_octet_length.explain
  389. function_overlay.explain
  390. function_overlay_with_len.explain
  391. function_parse_json.explain
  392. function_parse_url.explain
  393. function_parse_url_with_key.explain
  394. function_percent_rank.explain
  395. function_percentile_approx.explain
  396. function_percentile_with_frequency.explain
  397. function_percentile_without_frequency.explain
  398. function_pi.explain
  399. function_pmod.explain
  400. function_posexplode.explain
  401. function_posexplode_outer.explain
  402. function_position.explain
  403. function_position_with_start.explain
  404. function_positive.explain
  405. function_pow.explain
  406. function_power.explain
  407. function_printf.explain
  408. function_product.explain
  409. function_quarter.explain
  410. function_radians.explain
  411. function_raise_error.explain
  412. function_rand_with_seed.explain
  413. function_randn_with_seed.explain
  414. function_random_with_seed.explain
  415. function_rank.explain
  416. function_reduce.explain
  417. function_reflect.explain
  418. function_regexp.explain
  419. function_regexp_count.explain
  420. function_regexp_extract.explain
  421. function_regexp_extract_all_with_regex_group_index.explain
  422. function_regexp_extract_all_without_regex_group_index.explain
  423. function_regexp_instr_with_regex_group_index.explain
  424. function_regexp_instr_without_regex_group_index.explain
  425. function_regexp_like.explain
  426. function_regexp_replace.explain
  427. function_regexp_substr.explain
  428. function_regr_avgx.explain
  429. function_regr_avgy.explain
  430. function_regr_count.explain
  431. function_regr_intercept.explain
  432. function_regr_r2.explain
  433. function_regr_slope.explain
  434. function_regr_sxx.explain
  435. function_regr_sxy.explain
  436. function_regr_syy.explain
  437. function_replace.explain
  438. function_replace_with_specified_string.explain
  439. function_reverse.explain
  440. function_right.explain
  441. function_rint.explain
  442. function_rlike.explain
  443. function_round.explain
  444. function_row_number.explain
  445. function_rpad.explain
  446. function_rpad_binary.explain
  447. function_rtrim.explain
  448. function_rtrim_with_pattern.explain
  449. function_schema_of_csv.explain
  450. function_schema_of_json.explain
  451. function_schema_of_json_with_options.explain
  452. function_schema_of_variant.explain
  453. function_schema_of_variant_agg.explain
  454. function_sec.explain
  455. function_second.explain
  456. function_sentences.explain
  457. function_sentences_with_locale.explain
  458. function_sequence.explain
  459. function_session_user.explain
  460. function_session_window.explain
  461. function_session_window_orphaned.explain
  462. function_sha.explain
  463. function_sha1.explain
  464. function_sha2.explain
  465. function_shiftleft.explain
  466. function_shiftright.explain
  467. function_shiftrightunsigned.explain
  468. function_sign.explain
  469. function_signum.explain
  470. function_sin.explain
  471. function_sinh.explain
  472. function_size.explain
  473. function_skewness.explain
  474. function_slice.explain
  475. function_some.explain
  476. function_sort_array.explain
  477. function_spark_partition_id.explain
  478. function_split.explain
  479. function_split_part.explain
  480. function_split_using_columns.explain
  481. function_split_with_limit.explain
  482. function_split_with_limit_using_columns.explain
  483. function_sqrt.explain
  484. function_stack.explain
  485. function_startswith.explain
  486. function_std.explain
  487. function_stddev.explain
  488. function_stddev_pop.explain
  489. function_stddev_samp.explain
  490. function_str_to_map.explain
  491. function_str_to_map_with_pair_and_keyValue_delimiter.explain
  492. function_str_to_map_with_pair_delimiter.explain
  493. function_struct.explain
  494. function_substr.explain
  495. function_substr_with_len.explain
  496. function_substring.explain
  497. function_substring_index.explain
  498. function_substring_using_columns.explain
  499. function_substring_with_columns.explain
  500. function_sum.explain
  501. function_sum_distinct.explain
  502. function_tan.explain
  503. function_tanh.explain
  504. function_timestamp_add.explain
  505. function_timestamp_diff.explain
  506. function_timestamp_micros.explain
  507. function_timestamp_millis.explain
  508. function_timestamp_seconds.explain
  509. function_to_binary.explain
  510. function_to_binary_with_format.explain
  511. function_to_char.explain
  512. function_to_csv.explain
  513. function_to_date.explain
  514. function_to_date_with_format.explain
  515. function_to_json.explain
  516. function_to_number.explain
  517. function_to_timestamp.explain
  518. function_to_timestamp_ltz.explain
  519. function_to_timestamp_ltz_with_format.explain
  520. function_to_timestamp_ntz.explain
  521. function_to_timestamp_ntz_with_format.explain
  522. function_to_timestamp_with_format.explain
  523. function_to_unix_timestamp.explain
  524. function_to_unix_timestamp_with_format.explain
  525. function_to_utc_timestamp.explain
  526. function_to_varchar.explain
  527. function_transform.explain
  528. function_transform_keys.explain
  529. function_transform_values.explain
  530. function_transform_with_index.explain
  531. function_translate.explain
  532. function_trim.explain
  533. function_trim_with_pattern.explain
  534. function_trunc.explain
  535. function_try_add.explain
  536. function_try_aes_decrypt.explain
  537. function_try_aes_decrypt_with_mode.explain
  538. function_try_aes_decrypt_with_mode_padding.explain
  539. function_try_aes_decrypt_with_mode_padding_aad.explain
  540. function_try_avg.explain
  541. function_try_divide.explain
  542. function_try_element_at_array.explain
  543. function_try_element_at_map.explain
  544. function_try_multiply.explain
  545. function_try_parse_json.explain
  546. function_try_reflect.explain
  547. function_try_subtract.explain
  548. function_try_sum.explain
  549. function_try_to_binary.explain
  550. function_try_to_binary_without_format.explain
  551. function_try_to_number.explain
  552. function_try_to_timestamp.explain
  553. function_try_to_timestamp_without_format.explain
  554. function_try_url_decode.explain
  555. function_try_variant_get.explain
  556. function_typedLit.explain
  557. function_typeof.explain
  558. function_ucase.explain
  559. function_unbase64.explain
  560. function_unhex.explain
  561. function_unix_date.explain
  562. function_unix_micros.explain
  563. function_unix_millis.explain
  564. function_unix_seconds.explain
  565. function_unix_timestamp.explain
  566. function_unix_timestamp_with_format.explain
  567. function_upper.explain
  568. function_url_decode.explain
  569. function_url_encode.explain
  570. function_user.explain
  571. function_var_pop.explain
  572. function_var_samp.explain
  573. function_variance.explain
  574. function_variant_get.explain
  575. function_weekday.explain
  576. function_weekofyear.explain
  577. function_window.explain
  578. function_window_time.explain
  579. function_xpath.explain
  580. function_xpath_boolean.explain
  581. function_xpath_double.explain
  582. function_xpath_float.explain
  583. function_xpath_int.explain
  584. function_xpath_long.explain
  585. function_xpath_number.explain
  586. function_xpath_short.explain
  587. function_xpath_string.explain
  588. function_xxhash64.explain
  589. function_year.explain
  590. function_years.explain
  591. function_zip_with.explain
  592. groupby_agg.explain
  593. groupby_agg_columns.explain
  594. groupby_agg_orphaned.explain
  595. groupby_agg_string.explain
  596. groupby_avg.explain
  597. groupby_count.explain
  598. groupby_max.explain
  599. groupby_mean.explain
  600. groupby_min.explain
  601. groupby_sum.explain
  602. grouping_and_grouping_id.explain
  603. groupingSets.explain
  604. hint.explain
  605. hll_sketch_agg.explain
  606. hll_sketch_agg_with_column_lgConfigK.explain
  607. hll_sketch_agg_with_column_lgConfigK_int.explain
  608. hll_sketch_agg_with_columnName.explain
  609. hll_sketch_agg_with_columnName_lgConfigK_int.explain
  610. hll_union_agg.explain
  611. hll_union_agg_with_column_allowDifferentLgConfigK.explain
  612. hll_union_agg_with_column_allowDifferentLgConfigK_boolean.explain
  613. hll_union_agg_with_columnName.explain
  614. hll_union_agg_with_columnName_allowDifferentLgConfigK_boolean.explain
  615. intersect.explain
  616. intersectAll.explain
  617. join_condition.explain
  618. join_inner_condition.explain
  619. join_inner_no_condition.explain
  620. join_inner_using_multiple_col_array.explain
  621. join_inner_using_multiple_col_seq.explain
  622. join_inner_using_single_col.explain
  623. join_using_multiple_col_array.explain
  624. join_using_multiple_col_seq.explain
  625. join_using_single_col.explain
  626. json_from_dataset.explain
  627. limit.explain
  628. melt_no_values.explain
  629. melt_values.explain
  630. offset.explain
  631. orderBy_columns.explain
  632. orderBy_strings.explain
  633. pivot.explain
  634. pivot_without_column_values.explain
  635. range.explain
  636. read.explain
  637. read_csv.explain
  638. read_jdbc.explain
  639. read_jdbc_with_partition.explain
  640. read_jdbc_with_predicates.explain
  641. read_json.explain
  642. read_orc.explain
  643. read_parquet.explain
  644. read_table.explain
  645. read_text.explain
  646. relation_extension.explain
  647. relation_extension_deprecated.explain
  648. repartition.explain
  649. repartition_expressions.explain
  650. repartition_num_partitions_expressions.explain
  651. repartitionByRange_expressions.explain
  652. repartitionByRange_num_partitions_expressions.explain
  653. replace.explain
  654. rollup_column.explain
  655. rollup_string.explain
  656. sample_fraction_seed.explain
  657. sample_withReplacement_fraction_seed.explain
  658. sampleBy.explain
  659. select.explain
  660. select_collated_string.explain
  661. select_strings.explain
  662. select_typed_1-arg.explain
  663. select_typed_2-arg.explain
  664. select_typed_3-arg.explain
  665. select_typed_4-arg.explain
  666. select_typed_5-arg.explain
  667. selectExpr.explain
  668. sort_columns.explain
  669. sort_strings.explain
  670. sortWithinPartitions_columns.explain
  671. sortWithinPartitions_strings.explain
  672. streaming_table_API_with_options.explain
  673. summary.explain
  674. table.explain
  675. table_API_with_options.explain
  676. test_broadcast.explain
  677. to.explain
  678. to_avro_with_schema.explain
  679. to_avro_without_schema.explain
  680. to_protobuf_messageClassName.explain
  681. to_protobuf_messageClassName_descFilePath.explain
  682. to_protobuf_messageClassName_descFilePath_options.explain
  683. to_protobuf_messageClassName_options.explain
  684. toDF.explain
  685. toJSON.explain
  686. union.explain
  687. unionAll.explain
  688. unionByName.explain
  689. unionByName_allowMissingColumns.explain
  690. unpivot_no_values.explain
  691. unpivot_values.explain
  692. where_column.explain
  693. where_expr.explain
  694. width_bucket.explain
  695. window.explain
  696. withColumn_single.explain
  697. withColumnRenamed_java_map.explain
  698. withColumnRenamed_scala_map.explain
  699. withColumnRenamed_single.explain
  700. withColumns_java_map.explain
  701. withColumns_scala_map.explain
  702. withMetadata.explain