Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-05-04 Thread Ahmed Hamdy
+1 (non-binding)
Best Regards
Ahmed Hamdy


On Sat, 27 Apr 2024 at 02:46, Muhammet Orazov 
wrote:

>
> Hey Yubin, +1 (non-binding)
>
> Looks good, thanks!
>
> Best,
> Muhammet
>
> On 2024-04-24 08:56, Yubin Li wrote:
> > Hi everyone,
> >
> > During the implementation of the "describe catalog" syntax, it was
> > found that the original output style needed to be improved.
> > ```
> > desc catalog extended cat2;
> >
> +--+-+
> > | catalog_description_item |
> > catalog_description_value |
> >
> +--+-+
> > | Name |
> >  cat2 |
> > | Type |
> > generic_in_memory |
> > |  Comment |
> >   |
> > |   Properties | ('default-database','db'),
> > ('type','generic_in_memory') |
> >
> +--+-+
> > 4 rows in set
> > ```
> > After offline discussions with Jane Chan and Jark Wu, we suggest
> > improving it to the following form:
> > ```
> > desc catalog extended cat2;
> > +-+---+
> > |   info name |info value |
> > +-+---+
> > |name |  cat2 |
> > |type | generic_in_memory |
> > | comment |   |
> > | option:default-database |db |
> > +-+---+
> > 4 rows in set
> > ```
> >
> > For the following reasons:
> > 1. The title should be consistent with engines such as Databricks for
> > easy understanding, and it should also be consistent with Flink's own
> > naming style. Therefore, the title adopts "info name", "info value",
> > and the key name should be unified in lowercase, so "Name" is replaced
> > by "name".
> > Note: Databricks output style [1] as follows:
> > ```
> >> DESCRIBE CATALOG main;
> >  info_name info_value
> >    
> >  Catalog Name  main
> >   Comment   Main catalog (auto-created)
> > Owner metastore-admin-users
> >  Catalog Type   Regular
> > ```
> > 2. There may be many attributes of the catalog, and it is very poor in
> > readability when displayed in one line. It should be expanded into
> > multiple lines, and the key name is prefixed with "option:" to
> > identify that this is an attribute row. And since `type` is an
> > important information of the catalog, even if `extended` is not
> > specified, it should also be displayed, and correspondingly,
> > "option:type" should be removed to avoid redundancy.
> >
> > WDYT? Looking forward to your reply!
> >
> > [1]
> >
> https://learn.microsoft.com/zh-tw/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-catalog
> >
> > Best,
> > Yubin
> >
> > On Wed, Mar 20, 2024 at 2:15 PM Benchao Li 
> > wrote:
> >>
> >> +1 (binding)
> >>
> >> gongzhongqiang  于2024年3月20日周三 11:40写道:
> >> >
> >> > +1 (non-binding)
> >> >
> >> > Best,
> >> > Zhongqiang Gong
> >> >
> >> > Yubin Li  于2024年3月19日周二 18:03写道:
> >> >
> >> > > Hi everyone,
> >> > >
> >> > > Thanks for all the feedback, I'd like to start a vote on the
> FLIP-436:
> >> > > Introduce Catalog-related Syntax [1]. The discussion thread is here
> >> > > [2].
> >> > >
> >> > > The vote will be open for at least 72 hours unless there is an
> >> > > objection or insufficient votes.
> >> > >
> >> > > [1]
> >> > >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> >> > > [2]
> https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> >> > >
> >> > > Best regards,
> >> > > Yubin
> >> > >
> >>
> >>
> >>
> >> --
> >>
> >> Best,
> >> Benchao Li
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-04-26 Thread Muhammet Orazov



Hey Yubin, +1 (non-binding)

Looks good, thanks!

Best,
Muhammet

On 2024-04-24 08:56, Yubin Li wrote:

Hi everyone,

During the implementation of the "describe catalog" syntax, it was
found that the original output style needed to be improved.
```
desc catalog extended cat2;
+--+-+
| catalog_description_item |
catalog_description_value |
+--+-+
| Name |
 cat2 |
| Type |
generic_in_memory |
|  Comment |
  |
|   Properties | ('default-database','db'),
('type','generic_in_memory') |
+--+-+
4 rows in set
```
After offline discussions with Jane Chan and Jark Wu, we suggest
improving it to the following form:
```
desc catalog extended cat2;
+-+---+
|   info name |info value |
+-+---+
|name |  cat2 |
|type | generic_in_memory |
| comment |   |
| option:default-database |db |
+-+---+
4 rows in set
```

For the following reasons:
1. The title should be consistent with engines such as Databricks for
easy understanding, and it should also be consistent with Flink's own
naming style. Therefore, the title adopts "info name", "info value",
and the key name should be unified in lowercase, so "Name" is replaced
by "name".
Note: Databricks output style [1] as follows:
```

DESCRIBE CATALOG main;

 info_name info_value
   
 Catalog Name  main
  Comment   Main catalog (auto-created)
Owner metastore-admin-users
 Catalog Type   Regular
```
2. There may be many attributes of the catalog, and it is very poor in
readability when displayed in one line. It should be expanded into
multiple lines, and the key name is prefixed with "option:" to
identify that this is an attribute row. And since `type` is an
important information of the catalog, even if `extended` is not
specified, it should also be displayed, and correspondingly,
"option:type" should be removed to avoid redundancy.

WDYT? Looking forward to your reply!

[1] 
https://learn.microsoft.com/zh-tw/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-catalog


Best,
Yubin

On Wed, Mar 20, 2024 at 2:15 PM Benchao Li  
wrote:


+1 (binding)

gongzhongqiang  于2024年3月20日周三 11:40写道:
>
> +1 (non-binding)
>
> Best,
> Zhongqiang Gong
>
> Yubin Li  于2024年3月19日周二 18:03写道:
>
> > Hi everyone,
> >
> > Thanks for all the feedback, I'd like to start a vote on the FLIP-436:
> > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > [2].
> >
> > The vote will be open for at least 72 hours unless there is an
> > objection or insufficient votes.
> >
> > [1]
> > 
https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > [2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> >
> > Best regards,
> > Yubin
> >



--

Best,
Benchao Li


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-04-26 Thread yuxia
+1(binding)

Best regards,
Yuxia

- 原始邮件 -
发件人: "Jane Chan" 
收件人: "dev" 
发送时间: 星期五, 2024年 4 月 26日 下午 1:56:25
主题: Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

Hi Yubin,

Thanks for your effort. +1 with the display layout change (binding).

Best,
Jane

On Wed, Apr 24, 2024 at 5:28 PM Ahmed Hamdy  wrote:

> Hi, +1 (non-binding)
> Best Regards
> Ahmed Hamdy
>
>
> On Wed, 24 Apr 2024 at 09:58, Yubin Li  wrote:
>
> > Hi everyone,
> >
> > During the implementation of the "describe catalog" syntax, it was
> > found that the original output style needed to be improved.
> > ```
> > desc catalog extended cat2;
> >
> >
> +--+-+
> > | catalog_description_item |
> > catalog_description_value |
> >
> >
> +--+-+
> > | Name |
> >  cat2 |
> > | Type |
> > generic_in_memory |
> > |  Comment |
> >   |
> > |   Properties | ('default-database','db'),
> > ('type','generic_in_memory') |
> >
> >
> +--+-+
> > 4 rows in set
> > ```
> > After offline discussions with Jane Chan and Jark Wu, we suggest
> > improving it to the following form:
> > ```
> > desc catalog extended cat2;
> > +-+---+
> > |   info name |info value |
> > +-+---+
> > |name |  cat2 |
> > |type | generic_in_memory |
> > | comment |   |
> > | option:default-database |db |
> > +-+---+
> > 4 rows in set
> > ```
> >
> > For the following reasons:
> > 1. The title should be consistent with engines such as Databricks for
> > easy understanding, and it should also be consistent with Flink's own
> > naming style. Therefore, the title adopts "info name", "info value",
> > and the key name should be unified in lowercase, so "Name" is replaced
> > by "name".
> > Note: Databricks output style [1] as follows:
> > ```
> > > DESCRIBE CATALOG main;
> >  info_name info_value
> >    
> >  Catalog Name  main
> >   Comment   Main catalog (auto-created)
> > Owner metastore-admin-users
> >  Catalog Type   Regular
> > ```
> > 2. There may be many attributes of the catalog, and it is very poor in
> > readability when displayed in one line. It should be expanded into
> > multiple lines, and the key name is prefixed with "option:" to
> > identify that this is an attribute row. And since `type` is an
> > important information of the catalog, even if `extended` is not
> > specified, it should also be displayed, and correspondingly,
> > "option:type" should be removed to avoid redundancy.
> >
> > WDYT? Looking forward to your reply!
> >
> > [1]
> >
> https://learn.microsoft.com/zh-tw/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-catalog
> >
> > Best,
> > Yubin
> >
> > On Wed, Mar 20, 2024 at 2:15 PM Benchao Li  wrote:
> > >
> > > +1 (binding)
> > >
> > > gongzhongqiang  于2024年3月20日周三 11:40写道:
> > > >
> > > > +1 (non-binding)
> > > >
> > > > Best,
> > > > Zhongqiang Gong
> > > >
> > > > Yubin Li  于2024年3月19日周二 18:03写道:
> > > >
> > > > > Hi everyone,
> > > > >
> > > > > Thanks for all the feedback, I'd like to start a vote on the
> > FLIP-436:
> > > > > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > > > > [2].
> > > > >
> > > > > The vote will be open for at least 72 hours unless there is an
> > > > > objection or insufficient votes.
> > > > >
> > > > > [1]
> > > > >
> >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > > > > [2]
> https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > > > >
> > > > > Best regards,
> > > > > Yubin
> > > > >
> > >
> > >
> > >
> > > --
> > >
> > > Best,
> > > Benchao Li
> >
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-04-26 Thread Leonard Xu
+1 for the new layout, it’s a minor but good improvement.

Best,
Leonard
 

> 2024年4月26日 下午2:03,Jark Wu  写道:
> 
> Thanks for driving this, Jane and Yubin.
> 
> +1. The new layout looks good to me.
> 
> Best,
> Jark
> 
> On Fri, 26 Apr 2024 at 13:57, Jane Chan  wrote:
> 
>> Hi Yubin,
>> 
>> Thanks for your effort. +1 with the display layout change (binding).
>> 
>> Best,
>> Jane
>> 
>> On Wed, Apr 24, 2024 at 5:28 PM Ahmed Hamdy  wrote:
>> 
>>> Hi, +1 (non-binding)
>>> Best Regards
>>> Ahmed Hamdy
>>> 
>>> 
>>> On Wed, 24 Apr 2024 at 09:58, Yubin Li  wrote:
>>> 
 Hi everyone,
 
 During the implementation of the "describe catalog" syntax, it was
 found that the original output style needed to be improved.
 ```
 desc catalog extended cat2;
 
 
>>> 
>> +--+-+
 | catalog_description_item |
 catalog_description_value |
 
 
>>> 
>> +--+-+
 | Name |
 cat2 |
 | Type |
 generic_in_memory |
 |  Comment |
  |
 |   Properties | ('default-database','db'),
 ('type','generic_in_memory') |
 
 
>>> 
>> +--+-+
 4 rows in set
 ```
 After offline discussions with Jane Chan and Jark Wu, we suggest
 improving it to the following form:
 ```
 desc catalog extended cat2;
 +-+---+
 |   info name |info value |
 +-+---+
 |name |  cat2 |
 |type | generic_in_memory |
 | comment |   |
 | option:default-database |db |
 +-+---+
 4 rows in set
 ```
 
 For the following reasons:
 1. The title should be consistent with engines such as Databricks for
 easy understanding, and it should also be consistent with Flink's own
 naming style. Therefore, the title adopts "info name", "info value",
 and the key name should be unified in lowercase, so "Name" is replaced
 by "name".
 Note: Databricks output style [1] as follows:
 ```
> DESCRIBE CATALOG main;
 info_name info_value
   
 Catalog Name  main
  Comment   Main catalog (auto-created)
Owner metastore-admin-users
 Catalog Type   Regular
 ```
 2. There may be many attributes of the catalog, and it is very poor in
 readability when displayed in one line. It should be expanded into
 multiple lines, and the key name is prefixed with "option:" to
 identify that this is an attribute row. And since `type` is an
 important information of the catalog, even if `extended` is not
 specified, it should also be displayed, and correspondingly,
 "option:type" should be removed to avoid redundancy.
 
 WDYT? Looking forward to your reply!
 
 [1]
 
>>> 
>> https://learn.microsoft.com/zh-tw/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-catalog
 
 Best,
 Yubin
 
 On Wed, Mar 20, 2024 at 2:15 PM Benchao Li 
>> wrote:
> 
> +1 (binding)
> 
> gongzhongqiang  于2024年3月20日周三 11:40写道:
>> 
>> +1 (non-binding)
>> 
>> Best,
>> Zhongqiang Gong
>> 
>> Yubin Li  于2024年3月19日周二 18:03写道:
>> 
>>> Hi everyone,
>>> 
>>> Thanks for all the feedback, I'd like to start a vote on the
 FLIP-436:
>>> Introduce Catalog-related Syntax [1]. The discussion thread is
>> here
>>> [2].
>>> 
>>> The vote will be open for at least 72 hours unless there is an
>>> objection or insufficient votes.
>>> 
>>> [1]
>>> 
 
>>> 
>> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
>>> [2]
>>> https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
>>> 
>>> Best regards,
>>> Yubin
>>> 
> 
> 
> 
> --
> 
> Best,
> Benchao Li
 
>>> 
>> 



Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-04-26 Thread Jark Wu
Thanks for driving this, Jane and Yubin.

+1. The new layout looks good to me.

Best,
Jark

On Fri, 26 Apr 2024 at 13:57, Jane Chan  wrote:

> Hi Yubin,
>
> Thanks for your effort. +1 with the display layout change (binding).
>
> Best,
> Jane
>
> On Wed, Apr 24, 2024 at 5:28 PM Ahmed Hamdy  wrote:
>
> > Hi, +1 (non-binding)
> > Best Regards
> > Ahmed Hamdy
> >
> >
> > On Wed, 24 Apr 2024 at 09:58, Yubin Li  wrote:
> >
> > > Hi everyone,
> > >
> > > During the implementation of the "describe catalog" syntax, it was
> > > found that the original output style needed to be improved.
> > > ```
> > > desc catalog extended cat2;
> > >
> > >
> >
> +--+-+
> > > | catalog_description_item |
> > > catalog_description_value |
> > >
> > >
> >
> +--+-+
> > > | Name |
> > >  cat2 |
> > > | Type |
> > > generic_in_memory |
> > > |  Comment |
> > >   |
> > > |   Properties | ('default-database','db'),
> > > ('type','generic_in_memory') |
> > >
> > >
> >
> +--+-+
> > > 4 rows in set
> > > ```
> > > After offline discussions with Jane Chan and Jark Wu, we suggest
> > > improving it to the following form:
> > > ```
> > > desc catalog extended cat2;
> > > +-+---+
> > > |   info name |info value |
> > > +-+---+
> > > |name |  cat2 |
> > > |type | generic_in_memory |
> > > | comment |   |
> > > | option:default-database |db |
> > > +-+---+
> > > 4 rows in set
> > > ```
> > >
> > > For the following reasons:
> > > 1. The title should be consistent with engines such as Databricks for
> > > easy understanding, and it should also be consistent with Flink's own
> > > naming style. Therefore, the title adopts "info name", "info value",
> > > and the key name should be unified in lowercase, so "Name" is replaced
> > > by "name".
> > > Note: Databricks output style [1] as follows:
> > > ```
> > > > DESCRIBE CATALOG main;
> > >  info_name info_value
> > >    
> > >  Catalog Name  main
> > >   Comment   Main catalog (auto-created)
> > > Owner metastore-admin-users
> > >  Catalog Type   Regular
> > > ```
> > > 2. There may be many attributes of the catalog, and it is very poor in
> > > readability when displayed in one line. It should be expanded into
> > > multiple lines, and the key name is prefixed with "option:" to
> > > identify that this is an attribute row. And since `type` is an
> > > important information of the catalog, even if `extended` is not
> > > specified, it should also be displayed, and correspondingly,
> > > "option:type" should be removed to avoid redundancy.
> > >
> > > WDYT? Looking forward to your reply!
> > >
> > > [1]
> > >
> >
> https://learn.microsoft.com/zh-tw/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-catalog
> > >
> > > Best,
> > > Yubin
> > >
> > > On Wed, Mar 20, 2024 at 2:15 PM Benchao Li 
> wrote:
> > > >
> > > > +1 (binding)
> > > >
> > > > gongzhongqiang  于2024年3月20日周三 11:40写道:
> > > > >
> > > > > +1 (non-binding)
> > > > >
> > > > > Best,
> > > > > Zhongqiang Gong
> > > > >
> > > > > Yubin Li  于2024年3月19日周二 18:03写道:
> > > > >
> > > > > > Hi everyone,
> > > > > >
> > > > > > Thanks for all the feedback, I'd like to start a vote on the
> > > FLIP-436:
> > > > > > Introduce Catalog-related Syntax [1]. The discussion thread is
> here
> > > > > > [2].
> > > > > >
> > > > > > The vote will be open for at least 72 hours unless there is an
> > > > > > objection or insufficient votes.
> > > > > >
> > > > > > [1]
> > > > > >
> > >
> >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > > > > > [2]
> > https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > > > > >
> > > > > > Best regards,
> > > > > > Yubin
> > > > > >
> > > >
> > > >
> > > >
> > > > --
> > > >
> > > > Best,
> > > > Benchao Li
> > >
> >
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-04-25 Thread Jane Chan
Hi Yubin,

Thanks for your effort. +1 with the display layout change (binding).

Best,
Jane

On Wed, Apr 24, 2024 at 5:28 PM Ahmed Hamdy  wrote:

> Hi, +1 (non-binding)
> Best Regards
> Ahmed Hamdy
>
>
> On Wed, 24 Apr 2024 at 09:58, Yubin Li  wrote:
>
> > Hi everyone,
> >
> > During the implementation of the "describe catalog" syntax, it was
> > found that the original output style needed to be improved.
> > ```
> > desc catalog extended cat2;
> >
> >
> +--+-+
> > | catalog_description_item |
> > catalog_description_value |
> >
> >
> +--+-+
> > | Name |
> >  cat2 |
> > | Type |
> > generic_in_memory |
> > |  Comment |
> >   |
> > |   Properties | ('default-database','db'),
> > ('type','generic_in_memory') |
> >
> >
> +--+-+
> > 4 rows in set
> > ```
> > After offline discussions with Jane Chan and Jark Wu, we suggest
> > improving it to the following form:
> > ```
> > desc catalog extended cat2;
> > +-+---+
> > |   info name |info value |
> > +-+---+
> > |name |  cat2 |
> > |type | generic_in_memory |
> > | comment |   |
> > | option:default-database |db |
> > +-+---+
> > 4 rows in set
> > ```
> >
> > For the following reasons:
> > 1. The title should be consistent with engines such as Databricks for
> > easy understanding, and it should also be consistent with Flink's own
> > naming style. Therefore, the title adopts "info name", "info value",
> > and the key name should be unified in lowercase, so "Name" is replaced
> > by "name".
> > Note: Databricks output style [1] as follows:
> > ```
> > > DESCRIBE CATALOG main;
> >  info_name info_value
> >    
> >  Catalog Name  main
> >   Comment   Main catalog (auto-created)
> > Owner metastore-admin-users
> >  Catalog Type   Regular
> > ```
> > 2. There may be many attributes of the catalog, and it is very poor in
> > readability when displayed in one line. It should be expanded into
> > multiple lines, and the key name is prefixed with "option:" to
> > identify that this is an attribute row. And since `type` is an
> > important information of the catalog, even if `extended` is not
> > specified, it should also be displayed, and correspondingly,
> > "option:type" should be removed to avoid redundancy.
> >
> > WDYT? Looking forward to your reply!
> >
> > [1]
> >
> https://learn.microsoft.com/zh-tw/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-catalog
> >
> > Best,
> > Yubin
> >
> > On Wed, Mar 20, 2024 at 2:15 PM Benchao Li  wrote:
> > >
> > > +1 (binding)
> > >
> > > gongzhongqiang  于2024年3月20日周三 11:40写道:
> > > >
> > > > +1 (non-binding)
> > > >
> > > > Best,
> > > > Zhongqiang Gong
> > > >
> > > > Yubin Li  于2024年3月19日周二 18:03写道:
> > > >
> > > > > Hi everyone,
> > > > >
> > > > > Thanks for all the feedback, I'd like to start a vote on the
> > FLIP-436:
> > > > > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > > > > [2].
> > > > >
> > > > > The vote will be open for at least 72 hours unless there is an
> > > > > objection or insufficient votes.
> > > > >
> > > > > [1]
> > > > >
> >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > > > > [2]
> https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > > > >
> > > > > Best regards,
> > > > > Yubin
> > > > >
> > >
> > >
> > >
> > > --
> > >
> > > Best,
> > > Benchao Li
> >
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-04-24 Thread Ahmed Hamdy
Hi, +1 (non-binding)
Best Regards
Ahmed Hamdy


On Wed, 24 Apr 2024 at 09:58, Yubin Li  wrote:

> Hi everyone,
>
> During the implementation of the "describe catalog" syntax, it was
> found that the original output style needed to be improved.
> ```
> desc catalog extended cat2;
>
> +--+-+
> | catalog_description_item |
> catalog_description_value |
>
> +--+-+
> | Name |
>  cat2 |
> | Type |
> generic_in_memory |
> |  Comment |
>   |
> |   Properties | ('default-database','db'),
> ('type','generic_in_memory') |
>
> +--+-+
> 4 rows in set
> ```
> After offline discussions with Jane Chan and Jark Wu, we suggest
> improving it to the following form:
> ```
> desc catalog extended cat2;
> +-+---+
> |   info name |info value |
> +-+---+
> |name |  cat2 |
> |type | generic_in_memory |
> | comment |   |
> | option:default-database |db |
> +-+---+
> 4 rows in set
> ```
>
> For the following reasons:
> 1. The title should be consistent with engines such as Databricks for
> easy understanding, and it should also be consistent with Flink's own
> naming style. Therefore, the title adopts "info name", "info value",
> and the key name should be unified in lowercase, so "Name" is replaced
> by "name".
> Note: Databricks output style [1] as follows:
> ```
> > DESCRIBE CATALOG main;
>  info_name info_value
>    
>  Catalog Name  main
>   Comment   Main catalog (auto-created)
> Owner metastore-admin-users
>  Catalog Type   Regular
> ```
> 2. There may be many attributes of the catalog, and it is very poor in
> readability when displayed in one line. It should be expanded into
> multiple lines, and the key name is prefixed with "option:" to
> identify that this is an attribute row. And since `type` is an
> important information of the catalog, even if `extended` is not
> specified, it should also be displayed, and correspondingly,
> "option:type" should be removed to avoid redundancy.
>
> WDYT? Looking forward to your reply!
>
> [1]
> https://learn.microsoft.com/zh-tw/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-catalog
>
> Best,
> Yubin
>
> On Wed, Mar 20, 2024 at 2:15 PM Benchao Li  wrote:
> >
> > +1 (binding)
> >
> > gongzhongqiang  于2024年3月20日周三 11:40写道:
> > >
> > > +1 (non-binding)
> > >
> > > Best,
> > > Zhongqiang Gong
> > >
> > > Yubin Li  于2024年3月19日周二 18:03写道:
> > >
> > > > Hi everyone,
> > > >
> > > > Thanks for all the feedback, I'd like to start a vote on the
> FLIP-436:
> > > > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > > > [2].
> > > >
> > > > The vote will be open for at least 72 hours unless there is an
> > > > objection or insufficient votes.
> > > >
> > > > [1]
> > > >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > > > [2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > > >
> > > > Best regards,
> > > > Yubin
> > > >
> >
> >
> >
> > --
> >
> > Best,
> > Benchao Li
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-04-24 Thread Yubin Li
Hi everyone,

During the implementation of the "describe catalog" syntax, it was
found that the original output style needed to be improved.
```
desc catalog extended cat2;
+--+-+
| catalog_description_item |
catalog_description_value |
+--+-+
| Name |
 cat2 |
| Type |
generic_in_memory |
|  Comment |
  |
|   Properties | ('default-database','db'),
('type','generic_in_memory') |
+--+-+
4 rows in set
```
After offline discussions with Jane Chan and Jark Wu, we suggest
improving it to the following form:
```
desc catalog extended cat2;
+-+---+
|   info name |info value |
+-+---+
|name |  cat2 |
|type | generic_in_memory |
| comment |   |
| option:default-database |db |
+-+---+
4 rows in set
```

For the following reasons:
1. The title should be consistent with engines such as Databricks for
easy understanding, and it should also be consistent with Flink's own
naming style. Therefore, the title adopts "info name", "info value",
and the key name should be unified in lowercase, so "Name" is replaced
by "name".
Note: Databricks output style [1] as follows:
```
> DESCRIBE CATALOG main;
 info_name info_value
   
 Catalog Name  main
  Comment   Main catalog (auto-created)
Owner metastore-admin-users
 Catalog Type   Regular
```
2. There may be many attributes of the catalog, and it is very poor in
readability when displayed in one line. It should be expanded into
multiple lines, and the key name is prefixed with "option:" to
identify that this is an attribute row. And since `type` is an
important information of the catalog, even if `extended` is not
specified, it should also be displayed, and correspondingly,
"option:type" should be removed to avoid redundancy.

WDYT? Looking forward to your reply!

[1] 
https://learn.microsoft.com/zh-tw/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-catalog

Best,
Yubin

On Wed, Mar 20, 2024 at 2:15 PM Benchao Li  wrote:
>
> +1 (binding)
>
> gongzhongqiang  于2024年3月20日周三 11:40写道:
> >
> > +1 (non-binding)
> >
> > Best,
> > Zhongqiang Gong
> >
> > Yubin Li  于2024年3月19日周二 18:03写道:
> >
> > > Hi everyone,
> > >
> > > Thanks for all the feedback, I'd like to start a vote on the FLIP-436:
> > > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > > [2].
> > >
> > > The vote will be open for at least 72 hours unless there is an
> > > objection or insufficient votes.
> > >
> > > [1]
> > > https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > > [2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > >
> > > Best regards,
> > > Yubin
> > >
>
>
>
> --
>
> Best,
> Benchao Li


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-20 Thread Benchao Li
+1 (binding)

gongzhongqiang  于2024年3月20日周三 11:40写道:
>
> +1 (non-binding)
>
> Best,
> Zhongqiang Gong
>
> Yubin Li  于2024年3月19日周二 18:03写道:
>
> > Hi everyone,
> >
> > Thanks for all the feedback, I'd like to start a vote on the FLIP-436:
> > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > [2].
> >
> > The vote will be open for at least 72 hours unless there is an
> > objection or insufficient votes.
> >
> > [1]
> > https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > [2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> >
> > Best regards,
> > Yubin
> >



-- 

Best,
Benchao Li


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread gongzhongqiang
+1 (non-binding)

Best,
Zhongqiang Gong

Yubin Li  于2024年3月19日周二 18:03写道:

> Hi everyone,
>
> Thanks for all the feedback, I'd like to start a vote on the FLIP-436:
> Introduce Catalog-related Syntax [1]. The discussion thread is here
> [2].
>
> The vote will be open for at least 72 hours unless there is an
> objection or insufficient votes.
>
> [1]
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> [2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
>
> Best regards,
> Yubin
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread Hang Ruan
+1 (non-binding)

Best,
Hang

Jane Chan  于2024年3月19日周二 22:02写道:

> +1 (binding)
>
> Best,
> Jane
>
> On Tue, Mar 19, 2024 at 9:30 PM Leonard Xu  wrote:
>
> > +1(binding)
> >
> >
> > Best,
> > Leonard
> > > 2024年3月19日 下午9:03,Lincoln Lee  写道:
> > >
> > > +1 (binding)
> > >
> > > Best,
> > > Lincoln Lee
> > >
> > >
> > > Feng Jin  于2024年3月19日周二 19:59写道:
> > >
> > >> +1 (non-binding)
> > >>
> > >> Best,
> > >> Feng
> > >>
> > >> On Tue, Mar 19, 2024 at 7:46 PM Ferenc Csaky
>  > >
> > >> wrote:
> > >>
> > >>> +1 (non-binding).
> > >>>
> > >>> Best,
> > >>> Ferenc
> > >>>
> > >>>
> > >>>
> > >>>
> > >>> On Tuesday, March 19th, 2024 at 12:39, Jark Wu 
> > wrote:
> > >>>
> > 
> > 
> >  +1 (binding)
> > 
> >  Best,
> >  Jark
> > 
> >  On Tue, 19 Mar 2024 at 19:05, Yuepeng Pan panyuep...@apache.org
> > wrote:
> > 
> > > Hi, Yubin
> > >
> > > Thanks for driving it !
> > >
> > > +1 non-binding.
> > >
> > > Best,
> > > Yuepeng Pan.
> > >
> > > At 2024-03-19 17:56:42, "Yubin Li" lyb5...@gmail.com wrote:
> > >
> > >> Hi everyone,
> > >>
> > >> Thanks for all the feedback, I'd like to start a vote on the
> > >>> FLIP-436:
> > >> Introduce Catalog-related Syntax [1]. The discussion thread is
> here
> > >> [2].
> > >>
> > >> The vote will be open for at least 72 hours unless there is an
> > >> objection or insufficient votes.
> > >>
> > >> [1]
> > >>
> > >>>
> > >>
> >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > >> [2]
> > >> https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > >>
> > >> Best regards,
> > >> Yubin
> > >>>
> > >>
> >
> >
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread Jane Chan
+1 (binding)

Best,
Jane

On Tue, Mar 19, 2024 at 9:30 PM Leonard Xu  wrote:

> +1(binding)
>
>
> Best,
> Leonard
> > 2024年3月19日 下午9:03,Lincoln Lee  写道:
> >
> > +1 (binding)
> >
> > Best,
> > Lincoln Lee
> >
> >
> > Feng Jin  于2024年3月19日周二 19:59写道:
> >
> >> +1 (non-binding)
> >>
> >> Best,
> >> Feng
> >>
> >> On Tue, Mar 19, 2024 at 7:46 PM Ferenc Csaky  >
> >> wrote:
> >>
> >>> +1 (non-binding).
> >>>
> >>> Best,
> >>> Ferenc
> >>>
> >>>
> >>>
> >>>
> >>> On Tuesday, March 19th, 2024 at 12:39, Jark Wu 
> wrote:
> >>>
> 
> 
>  +1 (binding)
> 
>  Best,
>  Jark
> 
>  On Tue, 19 Mar 2024 at 19:05, Yuepeng Pan panyuep...@apache.org
> wrote:
> 
> > Hi, Yubin
> >
> > Thanks for driving it !
> >
> > +1 non-binding.
> >
> > Best,
> > Yuepeng Pan.
> >
> > At 2024-03-19 17:56:42, "Yubin Li" lyb5...@gmail.com wrote:
> >
> >> Hi everyone,
> >>
> >> Thanks for all the feedback, I'd like to start a vote on the
> >>> FLIP-436:
> >> Introduce Catalog-related Syntax [1]. The discussion thread is here
> >> [2].
> >>
> >> The vote will be open for at least 72 hours unless there is an
> >> objection or insufficient votes.
> >>
> >> [1]
> >>
> >>>
> >>
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> >> [2]
> >> https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> >>
> >> Best regards,
> >> Yubin
> >>>
> >>
>
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread Leonard Xu
+1(binding)


Best,
Leonard
> 2024年3月19日 下午9:03,Lincoln Lee  写道:
> 
> +1 (binding)
> 
> Best,
> Lincoln Lee
> 
> 
> Feng Jin  于2024年3月19日周二 19:59写道:
> 
>> +1 (non-binding)
>> 
>> Best,
>> Feng
>> 
>> On Tue, Mar 19, 2024 at 7:46 PM Ferenc Csaky 
>> wrote:
>> 
>>> +1 (non-binding).
>>> 
>>> Best,
>>> Ferenc
>>> 
>>> 
>>> 
>>> 
>>> On Tuesday, March 19th, 2024 at 12:39, Jark Wu  wrote:
>>> 
 
 
 +1 (binding)
 
 Best,
 Jark
 
 On Tue, 19 Mar 2024 at 19:05, Yuepeng Pan panyuep...@apache.org wrote:
 
> Hi, Yubin
> 
> Thanks for driving it !
> 
> +1 non-binding.
> 
> Best,
> Yuepeng Pan.
> 
> At 2024-03-19 17:56:42, "Yubin Li" lyb5...@gmail.com wrote:
> 
>> Hi everyone,
>> 
>> Thanks for all the feedback, I'd like to start a vote on the
>>> FLIP-436:
>> Introduce Catalog-related Syntax [1]. The discussion thread is here
>> [2].
>> 
>> The vote will be open for at least 72 hours unless there is an
>> objection or insufficient votes.
>> 
>> [1]
>> 
>>> 
>> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
>> [2]
>> https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
>> 
>> Best regards,
>> Yubin
>>> 
>> 



Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread Lincoln Lee
+1 (binding)

Best,
Lincoln Lee


Feng Jin  于2024年3月19日周二 19:59写道:

> +1 (non-binding)
>
> Best,
> Feng
>
> On Tue, Mar 19, 2024 at 7:46 PM Ferenc Csaky 
> wrote:
>
> > +1 (non-binding).
> >
> > Best,
> > Ferenc
> >
> >
> >
> >
> > On Tuesday, March 19th, 2024 at 12:39, Jark Wu  wrote:
> >
> > >
> > >
> > > +1 (binding)
> > >
> > > Best,
> > > Jark
> > >
> > > On Tue, 19 Mar 2024 at 19:05, Yuepeng Pan panyuep...@apache.org wrote:
> > >
> > > > Hi, Yubin
> > > >
> > > > Thanks for driving it !
> > > >
> > > > +1 non-binding.
> > > >
> > > > Best,
> > > > Yuepeng Pan.
> > > >
> > > > At 2024-03-19 17:56:42, "Yubin Li" lyb5...@gmail.com wrote:
> > > >
> > > > > Hi everyone,
> > > > >
> > > > > Thanks for all the feedback, I'd like to start a vote on the
> > FLIP-436:
> > > > > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > > > > [2].
> > > > >
> > > > > The vote will be open for at least 72 hours unless there is an
> > > > > objection or insufficient votes.
> > > > >
> > > > > [1]
> > > > >
> >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > > > > [2]
> https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > > > >
> > > > > Best regards,
> > > > > Yubin
> >
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread Feng Jin
+1 (non-binding)

Best,
Feng

On Tue, Mar 19, 2024 at 7:46 PM Ferenc Csaky 
wrote:

> +1 (non-binding).
>
> Best,
> Ferenc
>
>
>
>
> On Tuesday, March 19th, 2024 at 12:39, Jark Wu  wrote:
>
> >
> >
> > +1 (binding)
> >
> > Best,
> > Jark
> >
> > On Tue, 19 Mar 2024 at 19:05, Yuepeng Pan panyuep...@apache.org wrote:
> >
> > > Hi, Yubin
> > >
> > > Thanks for driving it !
> > >
> > > +1 non-binding.
> > >
> > > Best,
> > > Yuepeng Pan.
> > >
> > > At 2024-03-19 17:56:42, "Yubin Li" lyb5...@gmail.com wrote:
> > >
> > > > Hi everyone,
> > > >
> > > > Thanks for all the feedback, I'd like to start a vote on the
> FLIP-436:
> > > > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > > > [2].
> > > >
> > > > The vote will be open for at least 72 hours unless there is an
> > > > objection or insufficient votes.
> > > >
> > > > [1]
> > > >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > > > [2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > > >
> > > > Best regards,
> > > > Yubin
>


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread Ferenc Csaky
+1 (non-binding).

Best,
Ferenc




On Tuesday, March 19th, 2024 at 12:39, Jark Wu  wrote:

> 
> 
> +1 (binding)
> 
> Best,
> Jark
> 
> On Tue, 19 Mar 2024 at 19:05, Yuepeng Pan panyuep...@apache.org wrote:
> 
> > Hi, Yubin
> > 
> > Thanks for driving it !
> > 
> > +1 non-binding.
> > 
> > Best,
> > Yuepeng Pan.
> > 
> > At 2024-03-19 17:56:42, "Yubin Li" lyb5...@gmail.com wrote:
> > 
> > > Hi everyone,
> > > 
> > > Thanks for all the feedback, I'd like to start a vote on the FLIP-436:
> > > Introduce Catalog-related Syntax [1]. The discussion thread is here
> > > [2].
> > > 
> > > The vote will be open for at least 72 hours unless there is an
> > > objection or insufficient votes.
> > > 
> > > [1]
> > > https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> > > [2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> > > 
> > > Best regards,
> > > Yubin


Re: [VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread Jark Wu
+1 (binding)

Best,
Jark

On Tue, 19 Mar 2024 at 19:05, Yuepeng Pan  wrote:

> Hi, Yubin
>
>
> Thanks for driving it !
>
> +1 non-binding.
>
>
>
>
>
>
>
> Best,
> Yuepeng Pan.
>
>
>
>
>
>
>
>
> At 2024-03-19 17:56:42, "Yubin Li"  wrote:
> >Hi everyone,
> >
> >Thanks for all the feedback, I'd like to start a vote on the FLIP-436:
> >Introduce Catalog-related Syntax [1]. The discussion thread is here
> >[2].
> >
> >The vote will be open for at least 72 hours unless there is an
> >objection or insufficient votes.
> >
> >[1]
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
> >[2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
> >
> >Best regards,
> >Yubin
>


Re:[VOTE] FLIP-436: Introduce Catalog-related Syntax

2024-03-19 Thread Yuepeng Pan
Hi, Yubin


Thanks for driving it !

+1 non-binding.







Best,
Yuepeng Pan.








At 2024-03-19 17:56:42, "Yubin Li"  wrote:
>Hi everyone,
>
>Thanks for all the feedback, I'd like to start a vote on the FLIP-436:
>Introduce Catalog-related Syntax [1]. The discussion thread is here
>[2].
>
>The vote will be open for at least 72 hours unless there is an
>objection or insufficient votes.
>
>[1] 
>https://cwiki.apache.org/confluence/display/FLINK/FLIP-436%3A+Introduce+Catalog-related+Syntax
>[2] https://lists.apache.org/thread/10k1bjb4sngyjwhmfqfky28lyoo7sv0z
>
>Best regards,
>Yubin