You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Dmitry Tolpeko <dm...@gmail.com> on 2022/04/29 15:42:16 UTC
Re: HPLSQL questions of dynamic SQL
Johnson,
Can you please send the complete source code of this procedure, not a
screenshot.
Thanks,
Dmitry
On Fri, Apr 29, 2022 at 6:36 PM Tao, Johnson /CN <Jo...@sanofi.com>
wrote:
> Hello sir and other experts,
>
>
>
> Today, I met a very strange problem as below:
>
>
>
>
>
>
>
> But unfortunately I got this result:
>
>
>
>
>
>
>
> We want to add single quotes on the left and right side of
> sta_wod_md_op_topic_option like this:
>
>
>
> *SELECT* col_name,col_type *FROM* landing.meta *where* tb_name =
> ‘sta_wop_md_op_topic_option’
>
>
>
> We try to several methods but all failed, we need your help to
> resolve this issue.
>
>
>
> Look forward to your reply, thanks a lot. 😀
>
>
>
> Regards
>
> Johnson
>
>
>
> The information in this email and any of its attachment is confidential
> and may be legally privileged. It is intended solely for the named
> addressee. Access to this email and any of its attachment by anyone other
> than the addressee is unauthorized.
> 本电子邮件及其附件所载之信息为保密信息，并且享有法律特权，仅供指定的收件人使用，其他任何人无权获取或使用本电子邮件及其附件。
>
> If you are not the intended recipient, please notify the sender and
> permanently delete the email and its attachments and destroy all copies of
> them. Any other action taken or omitted to be taken in reliance on it, is
> unlawful.
>
> 如果您不是本电子邮件的指定收件人，请立即回复并通知发件人，并永久删除该电子邮件及其所有附件和销毁所有复印件。任何其他基于本电子邮件或其包含的附件或信息而采取或停止采取的行为都是非法的。
>
> Any statements contained in this email should not be relied upon unless
> they are confirmed in writing by sanofi.
> 对于本电子邮件中包含的陈述，除非已经赛诺菲书面确认，不应被作为任何行为的依据。
>
> Sanofi cannot guarantee that email communications are secure or error
> free, as information could be intercepted, corrupted, amended, lost,
> destroyed, arrive late or incomplete, or contain virus.
> 由于电子邮件中所包含的信息可能被截取、破坏、修改、遗失、毁坏、迟延送达、不完全或携带病毒，赛诺菲不保证本电子邮件是安全的和没有错误的。
>
Re: HPLSQL questions of dynamic SQL
Posted by Dmitry Tolpeko <dm...@gmail.com>.
Looks like a bug, can you please create a Jira ticket with all these
details.
Thanks,
Dmitry
On Sat, May 7, 2022 at 10:29 AM Tao, Johnson /CN <Jo...@sanofi.com>
wrote:
> Dear Dmitry,
>
> If there’re any updates, please spend a few time to share with
> me, thanks. 🙂
>
>
>
> I’ll try other ways at the same time.
>
>
>
>
>
>
>
> Regards
>
> Johnson
>
>
>
> *From:* Dmitry Tolpeko <dm...@gmail.com>
> *Sent:* 2022年4月29日 23:42
> *To:* Tao, Johnson /CN <Jo...@sanofi.com>
> *Cc:* user@hive.apache.org
> *Subject:* Re: HPLSQL questions of dynamic SQL
>
>
>
> Johnson,
>
>
>
> Can you please send the complete source code of this procedure, not a
> screenshot.
>
>
>
> Thanks,
>
> Dmitry
>
>
>
> On Fri, Apr 29, 2022 at 6:36 PM Tao, Johnson /CN <Jo...@sanofi.com>
> wrote:
>
> Hello sir and other experts,
>
>
>
> Today, I met a very strange problem as below:
>
>
>
>
>
>
>
> But unfortunately I got this result:
>
>
>
>
>
>
>
> We want to add single quotes on the left and right side of
> sta_wod_md_op_topic_option like this:
>
>
>
> *SELECT* col_name,col_type *FROM* landing.meta *where* tb_name =
> ‘sta_wop_md_op_topic_option’
>
>
>
> We try to several methods but all failed, we need your help to
> resolve this issue.
>
>
>
> Look forward to your reply, thanks a lot. 😀
>
>
>
> Regards
>
> Johnson
>
>
>
> The information in this email and any of its attachment is confidential
> and may be legally privileged. It is intended solely for the named
> addressee. Access to this email and any of its attachment by anyone other
> than the addressee is unauthorized.
> 本电子邮件及其附件所载之信息为保密信息，并且享有法律特权，仅供指定的收件人使用，其他任何人无权获取或使用本电子邮件及其附件。
>
> If you are not the intended recipient, please notify the sender and
> permanently delete the email and its attachments and destroy all copies of
> them. Any other action taken or omitted to be taken in reliance on it, is
> unlawful.
>
> 如果您不是本电子邮件的指定收件人，请立即回复并通知发件人，并永久删除该电子邮件及其所有附件和销毁所有复印件。任何其他基于本电子邮件或其包含的附件或信息而采取或停止采取的行为都是非法的。
>
> Any statements contained in this email should not be relied upon unless
> they are confirmed in writing by sanofi.
> 对于本电子邮件中包含的陈述，除非已经赛诺菲书面确认，不应被作为任何行为的依据。
>
> Sanofi cannot guarantee that email communications are secure or error
> free, as information could be intercepted, corrupted, amended, lost,
> destroyed, arrive late or incomplete, or contain virus.
> 由于电子邮件中所包含的信息可能被截取、破坏、修改、遗失、毁坏、迟延送达、不完全或携带病毒，赛诺菲不保证本电子邮件是安全的和没有错误的。
>
> The information in this email and any of its attachment is confidential
> and may be legally privileged. It is intended solely for the named
> addressee. Access to this email and any of its attachment by anyone other
> than the addressee is unauthorized.
> 本电子邮件及其附件所载之信息为保密信息，并且享有法律特权，仅供指定的收件人使用，其他任何人无权获取或使用本电子邮件及其附件。
>
> If you are not the intended recipient, please notify the sender and
> permanently delete the email and its attachments and destroy all copies of
> them. Any other action taken or omitted to be taken in reliance on it, is
> unlawful.
>
> 如果您不是本电子邮件的指定收件人，请立即回复并通知发件人，并永久删除该电子邮件及其所有附件和销毁所有复印件。任何其他基于本电子邮件或其包含的附件或信息而采取或停止采取的行为都是非法的。
>
> Any statements contained in this email should not be relied upon unless
> they are confirmed in writing by sanofi.
> 对于本电子邮件中包含的陈述，除非已经赛诺菲书面确认，不应被作为任何行为的依据。
>
> Sanofi cannot guarantee that email communications are secure or error
> free, as information could be intercepted, corrupted, amended, lost,
> destroyed, arrive late or incomplete, or contain virus.
> 由于电子邮件中所包含的信息可能被截取、破坏、修改、遗失、毁坏、迟延送达、不完全或携带病毒，赛诺菲不保证本电子邮件是安全的和没有错误的。
>