[
https://issues.apache.org/jira/browse/SPARK-43907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728519#comment-17728519
]
Hyukjin Kwon commented on SPARK-43907:
--------------------------------------
Yes, please go ahead. But I think we should implement them in batch instead of
doing this one by one.
Here's the rough list of missing SQL functions in Python, Scala, and R:
aes_decrypt
aes_encrypt
and
any
any_value
approx_percentile
array_agg
array_size
asc
asc_nulls_first
asc_nulls_last
bigint
binary
bit_and
bit_count
bit_get
bit_or
bit_xor
bool_and
bool_or
boolean
btrim
cardinality
ceiling
char
char_length
character_length
chr
contains
convert_timezone
count_if
count_min_sketch
curdate
current_catalog
current_database
current_schema
current_timezone
current_user
date
date_diff
date_from_unix_date
date_part
dateadd
datepart
day
decimal
div
double
e
elt
endswith
equal_null
every
extract
find_in_set
first_value
float
getbit
histogram_numeric
if
ifnull
ilike
in
input_file_block_length
input_file_block_start
int
isnotnull
java_method
json_array_length
json_object_keys
last_value
lcase
left
len
like
ln
make_dt_interval
make_interval
make_timestamp
make_timestamp_ltz
make_timestamp_ntz
make_ym_interval
map
mask
mod
named_struct
negative
not
now
nullif
nvl
nvl2
or
parse_url
percentile
pi
position
positive
power
printf
random
reduce
reflect
regexp
regexp_count
regexp_extract_all
regexp_instr
regexp_like
regexp_substr
regr_avgx
regr_avgy
regr_count
regr_intercept
regr_r2
regr_slope
regr_sxx
regr_sxy
regr_syy
replace
right
rlike
sha
sign
smallint
some
space
split_part
stack
startswith
std
str_to_map
string
substr
timestamp
timestamp_micros
timestamp_millis
tinyint
to_binary
to_char
to_number
to_timestamp_ltz
to_timestamp_ntz
to_unix_timestamp
try_add
try_avg
try_divide
try_element_at
try_multiply
try_subtract
try_sum
try_to_binary
try_to_number
try_to_timestamp
typeof
ucase
unix_date
unix_micros
unix_millis
unix_seconds
url_decode
url_encode
user
uuid
version
weekday
width_bucket
xpath
xpath_boolean
xpath_double
xpath_float
xpath_int
xpath_long
xpath_number
xpath_short
xpath_string
> Add SQL functions into Scala, Python and R API
> ----------------------------------------------
>
> Key: SPARK-43907
> URL: https://issues.apache.org/jira/browse/SPARK-43907
> Project: Spark
> Issue Type: Umbrella
> Components: PySpark, SparkR, SQL
> Affects Versions: 3.5.0
> Reporter: Hyukjin Kwon
> Priority: Major
>
> See the discussion in dev mailing list
> (https://lists.apache.org/thread/0tdcfyzxzcv8w46qbgwys2rormhdgyqg).
> This is an umbrella JIRA to implement all SQL functions in Scala, Python and R
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
