[FLINK-24893] SQL Client prompt customisation

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Table SQL / Client
• Labels: pull-request-available stale-assigned
• Assignee: Sergey Nuyanzin
• Reporter: Sergey Nuyanzin
• Created: 15/Nov/21 07:58
• Updated: 04/May/23 23:01

Description

Pattern	Description
\c	Current catalog.
\d	Current database.
[…]	Prompts can contain terminal control characters which, for example, change the color, background, or style of the prompt text. These non-printing control characters must be designated as invisible by surrounding them with [ and ]. Multiple pairs of these can occur within the prompt.
{…}	Datetime pattern to convert current datetime. Compatible with Java’s SimpleDateFormat.
\:…\:	The value of Flink property_name property.
\D	The full current date (`yyyy-MM-dd HH:mm:ss.SSS`).
\m	Minutes of the current time.
\O	The current month in three-letter format (Jan, Feb, …).
\o	The current month in numeric format.
\P	am/pm.
\R	The current time, in 24-hour military time (0–23).
\r	The current time, standard 12-hour time (1–12).
\s	Seconds of the current time.
\w	The current day of the week in three-letter format (Mon, Tue, …).
\Y	The current year, four digits.
\y	The current year, two digits.
\	A literal \ backslash character.
\x	x, for any x not listed above.

 

Also the details are here
https://cwiki.apache.org/confluence/display/FLINK/FLIP-189%3A+SQL+Client+Usability+Improvements#FLIP189:SQLClientUsabilityImprovements-Supportedpromptoptions(bothforleftandrightprompts)

Issue Links

• relates to: FLINK-24730 Support prompt style in SqlCli
• links to: GitHub Pull Request #17830