[jira] [Resolved] (SPARK-28669) System Information Functions

["Xiao Li (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-28669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xiao Li resolved SPARK-28669.
-----------------------------
    Resolution: Later

> System Information Functions
> ----------------------------
>
>                 Key: SPARK-28669
>                 URL: https://issues.apache.org/jira/browse/SPARK-28669
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> ||Name||Return Type||Description||
> |{{current_catalog}}|{{name}}|name of current database (called “catalog” in the SQL standard)|
> |{{current_database()}}|{{name}}|name of current database|
> |{{current_query()}}|{{text}}|text of the currently executing query, as submitted by the client (might contain more than one statement)|
> |{{current_role}}|{{name}}|equivalent to {{current_user}}|
> |{{current_schema}}{{[()]}}|{{name}}|name of current schema|
> |{{current_schemas(}}{{boolean}}{{)}}|{{name[]}}|names of schemas in search path, optionally including implicit schemas|
> |{{current_user}}|{{name}}|user name of current execution context|
> |{{inet_client_addr()}}|{{inet}}|address of the remote connection|
> |{{inet_client_port()}}|{{int}}|port of the remote connection|
> |{{inet_server_addr()}}|{{inet}}|address of the local connection|
> |{{inet_server_port()}}|{{int}}|port of the local connection|
> |{{pg_backend_pid()}}|{{int}}|Process ID of the server process attached to the current session|
> |{{pg_blocking_pids(}}{{int}}{{)}}|{{int[]}}|Process ID(s) that are blocking specified server process ID from acquiring a lock|
> |{{pg_conf_load_time()}}|{{timestamp with time zone}}|configuration load time|
> |{{pg_current_logfile([{{text}}])}}|{{text}}|Primary log file name, or log in the requested format, currently in use by the logging collector|
> |{{pg_my_temp_schema()}}|{{oid}}|OID of session's temporary schema, or 0 if none|
> |{{pg_is_other_temp_schema(}}{{oid}}{{)}}|{{boolean}}|is schema another session's temporary schema?|
> |{{pg_listening_channels()}}|{{setof text}}|channel names that the session is currently listening on|
> |{{pg_notification_queue_usage()}}|{{double}}|fraction of the asynchronous notification queue currently occupied (0-1)|
> |{{pg_postmaster_start_time()}}|{{timestamp with time zone}}|server start time|
> |{{pg_safe_snapshot_blocking_pids(}}{{int}}{{)}}|{{int[]}}|Process ID(s) that are blocking specified server process ID from acquiring a safe snapshot|
> |{{pg_trigger_depth()}}|{{int}}|current nesting level of PostgreSQL triggers (0 if not called, directly or indirectly, from inside a trigger)|
> |{{session_user}}|{{name}}|session user name|
> |{{user}}|{{name}}|equivalent to {{current_user}}|
> Example:
> {code:sql}
> postgres=# SELECT pg_collation_for(description) FROM pg_description LIMIT 1;
>  pg_collation_for
> ------------------
>  "default"
> (1 row)
> {code}
> https://www.postgresql.org/docs/10/functions-info.html



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org