Flink 1.11 jdbc查pg失败

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Flink 1.11 jdbc查pg失败

Jimmy Zhang-2
flink 1.11用jdbc查询pg表时,pg表的字段是大写 flink会把字段转成小写,而导致查询失败,有大佬知道这个问题吗


Best,
Jimmy

Signature is customized by Netease Mail Master

Reply | Threaded
Open this post in threaded view
|

回复: Flink 1.11 jdbc查pg失败

wdmcode
Hi Jimmy

给字段加双引号试试呢
Select “F1”,”F2” from xxx.xxx;


发件人: Jimmy Zhang
发送时间: Thursday, September 10, 2020 9:41 AM
收件人: [hidden email]
主题: Flink 1.11 jdbc查pg失败

flink 1.11用jdbc查询pg表时,pg表的字段是大写 flink会把字段转成小写,而导致查询失败,有大佬知道这个问题吗

Best,
Jimmy Signature is customized by Netease Mail Master

Reply | Threaded
Open this post in threaded view
|

Re: Flink 1.11 jdbc查pg失败

godfrey he
In reply to this post by Jimmy Zhang-2
据我所知,目前flink是大小写不敏感,但是pg是大小写敏感。这问题暂时没法解

wdmcode <[hidden email]> 于2020年9月10日周四 上午9:44写道:

> Hi Jimmy
>
> 给字段加双引号试试呢
> Select “F1”,”F2” from xxx.xxx;
>
>
> 发件人: Jimmy Zhang
> 发送时间: Thursday, September 10, 2020 9:41 AM
> 收件人: [hidden email]
> 主题: Flink 1.11 jdbc查pg失败
>
> flink 1.11用jdbc查询pg表时,pg表的字段是大写 flink会把字段转成小写,而导致查询失败,有大佬知道这个问题吗
>
> Best,
> Jimmy Signature is customized by Netease Mail Master
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Flink 1.11 jdbc查pg失败

Jark
Administrator
能贴下你的 DDL 和 query 吗?

你可以试试用反引号,  select `F1`, `F2` from xxx;

Best,
Jark

On Thu, 17 Sep 2020 at 23:28, godfrey he <[hidden email]> wrote:

> 据我所知,目前flink是大小写不敏感,但是pg是大小写敏感。这问题暂时没法解
>
> wdmcode <[hidden email]> 于2020年9月10日周四 上午9:44写道:
>
> > Hi Jimmy
> >
> > 给字段加双引号试试呢
> > Select “F1”,”F2” from xxx.xxx;
> >
> >
> > 发件人: Jimmy Zhang
> > 发送时间: Thursday, September 10, 2020 9:41 AM
> > 收件人: [hidden email]
> > 主题: Flink 1.11 jdbc查pg失败
> >
> > flink 1.11用jdbc查询pg表时,pg表的字段是大写 flink会把字段转成小写,而导致查询失败,有大佬知道这个问题吗
> >
> > Best,
> > Jimmy Signature is customized by Netease Mail Master
> >
> >
>