OPAL Deprecated Function Aliases

Deprecated names are old names of functions that have more consistent new names. In all new code, you should use the new name, and you may get a deprecated name usage warning if you try to use the old name in the OPAL console. These names may stop working at some point in the future.

Old Name	Current Name
any_null	variant_null
array_pivot	pivot_array
array_unpivot	unpivot_array
countdistinct	count_distinct
countdistinctexact	count_distinct_exact
decodebase64	decode_base64
denserank	dense_rank
encodebase64	encode_base64
endswith	ends_with
groupby	group_by
ifnull	if_null
isnull	is_null
makeobject	make_object
match_regex_all	get_regex_all
medianexact	median_exact
milliseconds	from_milliseconds
nanoseconds	from_nanoseconds
orderby	order_by
parsehex	parse_hex
parseip	parse_ip
parseisotime	parse_isotime
parsejson	parse_json
parsekvs	parse_kvs
parseurl	parse_url
percentilecont	percentile_cont
percentiledisc	percentile_disc
primarykey	primary_key
queryendtime	query_end_time
querystarttime	query_start_time
regex_match	match_regex
regex_replace	replace_regex
row_endtime	row_end_time
rownumber	row_number
seconds	from_seconds
startswith	starts_with
strcat	concat_strings
string_concat	concat_strings
validfor	valid_for